Create a Metric
Metrics offer detailed insights and visualization of your data within a dashboard. This guide provides a step-by-step process to create a Metric in Databrain.
Last updated
Metrics offer detailed insights and visualization of your data within a dashboard. This guide provides a step-by-step process to create a Metric in Databrain.
Last updated
What is a Metric in Databrain?
A metric is a configurable analytical component that enables you to visualize and analyze your data through various chart types. It serves as a building block for dashboards, allowing you to create comprehensive data visualizations by combining multiple metrics.
Navigate to Dashboard and Initiate Metric Creation:
Select the dashboard where you intend to add the metric.
For the first metric, click the "+ Metric" button
Metric Configuration:
Inside the metric creation page, select the desired table from the schemas of your added database.
"Drag and Drop" the columns you wish to set as dimensions and metrics.
Choose one of the following aggregation options for Measure: COUNT ROW, AVERAGE, SUM, COUNT, COUNT DISTINCT, MAX, MIN, or Original Value.
Choose your preferred visualization from the "Charts" Icon.
Enhance your metric by applying "Joins", "Group by", "Filters", "Sort", and "Dynamic Property" other functionalities available in the icon list.
Customize your graph using the options available in the "Settings" icon.
For detailed guide on Dynamic Property, kindly refer the below link:
Finalize & Save:
After creating your metric, follow these steps to save it to your dashboard or as a draft.
Once satisfied with your chart, click "Save to Dashboard" on the top right.
Choose the dashboard in which you want to save the metric.
Then, fill in the "Metric Name", "Metric ID", and provide a "Description".
If necessary, add a long description and footnote for the metric, and enable end users to archive metrics
Finally, click on "Save" to save the metric to your dashboard.
For detailed guide on long description and footnote, kindly refer the below link:
Choose your preferred saving option:
Add Metric to Dashboard: Select a dashboard name from the dropdown menu and click "Save" to integrate your metric into the chosen dashboard. Your metric will appear in the selected dashboard!
Save Metric as Draft: Leave the dashboard selection empty and click "Save" to create an unpublished metric. Draft metrics can be added to dashboards at a later time.
For more details on saving a metric as a Draft, kindly refer the below link:
