💠Create a Metric

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.

1. 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

1. 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:

1. 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:

1. 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: