> ## Documentation Index
> Fetch the complete documentation index at: https://docs.usedatabrain.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Chart Actions

> Enhance your data visualization and analysis with these powerful chart customization features.

Unlock the full potential of your data visualizations with Databrain's powerful chart actions. From interactive click behaviors and intelligent drill-downs to advanced forecasting and security controls, these features transform static charts into dynamic analytical tools. This guide walks you through essential chart actions that will help you create more engaging, interactive, and secure data experiences.

1. **Access Chart Actions**:

* Navigate to your metric card.
* Click on the **“Settings”** icon in the top-right corner of the chart area.
* Head to the **“Actions”** tab to begin customizing.

<Frame>
  <img src="https://mintcdn.com/databrainlabs-bef6850a/w40i74o67wVB_OZm/images/guides/access-chart-actions.png?fit=max&auto=format&n=w40i74o67wVB_OZm&q=85&s=22eea12c89145c2c10b77e0c4682621a" alt="Navigating to chart actions through the settings icon in the metric card" width="2940" height="1662" data-path="images/guides/access-chart-actions.png" />
</Frame>

2. **Card Click Actions**:

* Click on the card in your dashboard to redirect to a specific page. Toggle to activate or deactivate.
* **Redirect Type**: Define the type of redirection.
* **Identifier Type**: Choose the identifier for redirection.
* **Destination Base URL**: Specify the URL to direct users.

<Frame>
  <img src="https://mintcdn.com/databrainlabs-bef6850a/w40i74o67wVB_OZm/images/guides/card-click-action.png?fit=max&auto=format&n=w40i74o67wVB_OZm&q=85&s=3169a48a4422138996efb99f6e7731d4" alt="Configuring card click actions including redirect type and destination URL" width="2940" height="1660" data-path="images/guides/card-click-action.png" />
</Frame>

For more details, kindly refer the below link

<Card title="Card Click Action" href="https://docs.usedatabrain.com/guides/visualizations-actions-and-appearance/chart-actions/card-click-action">
  This card links to the full documentation on configuring card click actions in your dashboard.
</Card>

### 3. **Chart Click Actions**

* Enable the toggle to set up actions when you click on the chart.
* **Redirect Type**: Choose how you want to redirect.
* **Value Column**: Select the data column for redirection.
* **Destination Base URL**: Enter the URL for redirection.

<Frame>
  <img src="https://mintcdn.com/databrainlabs-bef6850a/w40i74o67wVB_OZm/images/guides/chart-click-action.png?fit=max&auto=format&n=w40i74o67wVB_OZm&q=85&s=5e3fcc2dc25f623c805a8495faf0e688" alt="Setting up chart click actions including value column and redirect URL" width="2940" height="1656" data-path="images/guides/chart-click-action.png" />
</Frame>

For more details, kindly refer to the link below:

<Card title="Chart Click Action" href="https://docs.usedatabrain.com/guides/visualizations-actions-and-appearance/chart-actions/chart-click-action">
  Learn how to configure redirection logic when clicking on chart elements including internal route types, value column mapping, and dynamic URL targets.
</Card>

### 3. **Chart Click Actions with Metric**

* Specify the Metric name to which Chart should be redirected.

<Frame>
  <img src="https://mintcdn.com/databrainlabs-bef6850a/FXACK5bS1yJQ_mT1/images/guides/chart-click-actions-with-metric.png?fit=max&auto=format&n=FXACK5bS1yJQ_mT1&q=85&s=64486f02e9ce10c77cc3aa2848c0bec0" alt="Configuring chart click actions to redirect to a specific metric" width="2940" height="1656" data-path="images/guides/chart-click-actions-with-metric.png" />
</Frame>

### 4. **Group X-Axis**

Enable grouping to group your data along the x-axis to streamline visualization.

#### Use Case:

Let us take a combo chart with dual scales showing quantity sold (purple bars) and profit (blue line) by store name and client name.

When you toggle on **Group X-Axis**:

* The detailed view automatically consolidates into four main store name groups
* Both quantity sold and profit values are aggregated within each group
* The result is a clearer visualization showing consolidated performance by store

<Frame>
  <img src="https://mintcdn.com/databrainlabs-bef6850a/FXACK5bS1yJQ_mT1/images/guides/group-xaxis.gif?s=a6fccd55faad56fdf790bdf620f51b26" alt="Grouping x-axis values to consolidate chart data for clearer comparison" width="1632" height="918" data-path="images/guides/group-xaxis.gif" />
</Frame>

### 5. **Sort on Metric Card**

Sort the data directly on the metric card for better insights.

* Turn on the **Sort on Metric Card** Toggle and save the metric to Dashboard.
* Right Click on the chart to sort the data in either ascending or descending order.

<Frame>
  <img src="https://mintcdn.com/databrainlabs-bef6850a/vtT_Z5XodY0y5xKu/images/guides/sort-on-metric-card.gif?s=5e3ccc43f6b1d07383811828580c8e7f" alt="Sorting chart data directly from the metric card using right-click options" width="1629" height="920" data-path="images/guides/sort-on-metric-card.gif" />
</Frame>

### 6. **Switch X axis, Switch Y axis**

You can add Metric Filters for each card just like "Dashboard Filters". For an in-depth guide on adding metric filters, refer to the below link.

<Card title="Switch X axis and Switch Y axis" href="https://docs.usedatabrain.com/guides/metric/switch-x-axis-and-switch-y-axis">
  Learn how to toggle between axis dimensions to change your chart's view dynamically.
</Card>

### 7. **End user measures & dimensions**

To configure dimensions and measures for charts and adjust them as needed, enhancing interactive data exploration capabilities.

**Use Case:**

Let us take a line chart with multiple metrics – quantity sold, unit price, and profit across stores.

When you toggle ON **"End user measures & dimensions"** and select:

* **Dimension**: store name
* **Measure**: quantity sold

The chart immediately simplifies to show only quantity sold across stores, making it easier to analyze this specific metric.

<Frame>
  <img src="https://mintcdn.com/databrainlabs-bef6850a/FXACK5bS1yJQ_mT1/images/guides/end-user-measures-dimensions.png?fit=max&auto=format&n=FXACK5bS1yJQ_mT1&q=85&s=c6ebcc8e9c2ef91c6e9d3a8052154ae9" alt="Configuring end user measures and dimensions to refine chart data" width="2940" height="1658" data-path="images/guides/end-user-measures-dimensions.png" />
</Frame>

### 8. **Drill Down**

* For charts with multiple dimensions, toggle the **Drill down** option.
* **Cross Dashboard Drill-down**: Adjust the entire dashboard based on your selected dimensions.

<Frame>
  <img src="https://mintcdn.com/databrainlabs-bef6850a/FXACK5bS1yJQ_mT1/images/guides/drill-down.png?fit=max&auto=format&n=FXACK5bS1yJQ_mT1&q=85&s=cff30b33d8d90364c5c27bf4491c79a2" alt="Enabling drill down functionality within charts for deeper exploration" width="2934" height="1648" data-path="images/guides/drill-down.png" />
</Frame>

For more details, kindly refer the below links:

<Card title="Drill Down" href="https://docs.usedatabrain.com/guides/visualizations-actions-and-appearance/chart-actions/drill-down">
  Learn how to enable and use drill-down functionality on metric cards.
</Card>

<Card title="Cross Dashboard Drill Down" href="https://docs.usedatabrain.com/guides/visualizations-actions-and-appearance/chart-actions/cross-dashboard-drill-down">
  Configure and apply cross-filters across dashboards using drill-down context.
</Card>

### 9. **Forecasting**

Enable or disable forecasting to predict future trends.

**Use Case:**\
Let us take a line chart showing quantity over time (2022–2024). When you toggle ON **"Forecast"** and configure:

* **Time Grain**: Choose the relevant time intervals
* **ARIMA Model Options**: Choose from linear, constant, or constant + linear
* **Prophet Model Options**: Select linear or flat trends
* **Adjust Hyperparameters**: Fine-tune your forecasting models

<Frame>
  <img src="https://mintcdn.com/databrainlabs-bef6850a/FXACK5bS1yJQ_mT1/images/guides/forecasting.png?fit=max&auto=format&n=FXACK5bS1yJQ_mT1&q=85&s=d04a2e8a0088fbc787c6283e4e803cb1" alt="Configuring forecasting models such as ARIMA and Prophet for future trend prediction" width="2940" height="1656" data-path="images/guides/forecasting.png" />
</Frame>

### 10. **Hide Coloumns Using Custom Underlying Data Dropdown or Security Actions Dropdown**

* **Hide Columns by SQL Query**: Write the corresponding SQL query to hide required columns from Underlying Data.

<Frame>
  <img src="https://mintcdn.com/databrainlabs-bef6850a/FXACK5bS1yJQ_mT1/images/guides/custom-underying-data.gif?s=e202f1adfeaed6ca7692d7846bce6743" alt="Hiding underlying data columns using custom SQL query" width="1631" height="919" data-path="images/guides/custom-underying-data.gif" />
</Frame>

* **Hide Columns**: Conceal specific columns from view.
* **Hide Columns from CSV data**: Prevent certain columns from being included in CSV exports.

<Frame>
  <img src="https://mintlify.s3.us-west-1.amazonaws.com/databrainlabs-bef6850a/images/guides/security-actions.gif" alt="Using security action settings to hide columns from charts and exports" />
</Frame>

These options may vary depending on the **"Chart Type"** chosen. Some options may not be available for certain chart types.

**By tailoring these chart actions, you can ensure a customized and secure data visualization experience in Databrain.**

### 11. **Alerts & Signals**

For Single Value Cards, you can configure and set alerts to trigger notifications when data exceeds or falls below a specified threshold.

<Frame>
  <img src="https://mintcdn.com/databrainlabs-bef6850a/w40i74o67wVB_OZm/images/guides/alerts-signals.gif?s=91ac5550382634604cd7ef0eff88d17c" alt="Setting up alerts and signals on single value cards to track threshold conditions" width="1633" height="918" data-path="images/guides/alerts-signals.gif" />
</Frame>

<Check>
  You’ve successfully explored all major Chart Actions!\
  Your dashboards can now deliver richer interactivity, smarter navigation, better forecasting, and secure data handling for every user.
</Check>
