Guides
Visit our websiteDeveloper Docs
  • Getting Started with Databrain
    • What is Databrain?
  • ❄️Onboarding & Configuration
    • 📝Sign-Up
    • ✍️Sign-In
    • ✏️Google Sign In Setup for Self-hosted app
    • 🤔Forgot password? Recover your Databrain Account
    • 🌟Onboarding
    • 💾Add a Data Source
    • 🧑Configure Tenants
    • 🆕Create a Workspace
    • 🔓Create a Private Workspace
    • 🆕Create a Dashboard
    • 💠Create a Metric
      • Create Custom Columns
      • Create a Metric using Chat Mode
      • Create a Metric using Custom SQL
    • Workspace Settings
      • General Settings
      • Access Control Settings
      • Cache Settings
      • Download Settings
    • 🗄️Explore Data
  • 🛢️Datasources
    • Connecting Data Sources to Databrain
      • Amazon Redshift
      • Snowflake
      • BigQuery
      • MySQL
      • Postgres
      • MongoDB
      • ElasticSearch
      • DataBricks
      • ClickHouse
      • MSSQL
      • Amazon S3
      • CSV
      • Firebolt
      • SingleStore
      • Athena
    • Allow Access to our IP
    • Add a Data Source
    • Configure Tenants
    • How to Sync a Data Source
    • Edit Tenancy
    • Create a Datamart
    • Semantic Layer
    • Create a Data App
    • Creating a Custom Dataset/View in a Multi-Datasource Environment
  • Workspace
    • Multi Datasource Workspace
  • 🔍DASHBOARDS
    • Edit a Dashboard
    • Share Dashboard
    • Dashboard Settings
    • Create/Modify Dashboard Filter
      • Dashboard Filter - Variable Apply On
      • Add LHS and RHS custom sql support for dashboard filter
    • Customize Layout
    • Adding Elements to Dashboard
    • Import/Export Dashboard
    • Report Scheduler
  • 📉METRIC
    • Edit a Metric
    • Joins , Filter, Sort, Group By
    • Complex Filter
    • Apply Metric Filter
      • Metric Filter - Variable
      • Metric Filter - Custom
    • Switch X axis and Switch Y axis
    • Group By
    • Footnote and Long Description
    • Dynamic Property
    • Archive/Unarchive Metric Card
    • Download Metric Card
    • Download Underlying Data
    • Metric Summary
    • Metric Expression for Single Value Card
    • AI Summary
    • Merge Metrics
    • Section Filters
    • View Unpublished Metrics
  • 📊VISUALIZATIONS - ACTIONS & APPEARANCE
    • Chart Actions
      • Chart Click Action
      • Chart Click Action with Metric
      • Card Click Action
      • Drill Down
      • Cross Dashboard Drill Down
    • Chart Appearance
      • Chart-Specific Appearance Options
  • 🛢️PREVIEW OF DASHBOARDS
    • Email Settings for Scheduled Reports
    • Scheduled Reports for End User
  • 🔍FILTERS
    • Dashboard Filter
    • Metric Filter
    • App filter
  • 💡Features
    • Python Editor Console
    • Custom SQL Console
    • Custom SQL Query Guidelines
  • 🏢Integrating Plugin
    • ✳️Get an auth token
    • 🙏Get a guest token
  • 🛃THEMEING & CUSTOMIZATION
    • 🎨Creating a theme
    • 🖼️View the theme in action
    • ⚙️Reset a saved theme
  • 📊Metric Component (upto version v0.11.15)
    • ✨Quick start
  • 🕸️Web Components
    • ✨Quick start
    • ⚛️Framework Specific Guide
  • 🚀Product Changelog
  • 🤳Self Hosted Changelog
Powered by GitBook
On this page
  1. Onboarding & Configuration

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.

PreviousCreate a DashboardNextCreate Custom Columns

Last updated 15 days ago

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:

❄️
💠
Dynamic Property
Footnote and Long Description
View Unpublished Metrics