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

Dashboard Filter

In this page we will explain you how you can create filters for the dashboard metrics.

PreviousScheduled Reports for End UserNextMetric Filter

Last updated 5 months ago

Creating a Dashboard Filter in DataBrain

To add a dashboard filter, click on the "+" sign located below the dashboard's name. Start by selecting the datatype for the filter, which will influence the available filter option typesβ€”auto, manual, or custom. Note that the option type may vary based on the selected datatype.

Customizations Based on Datatype:

  • Filter Variant: Choose between single select, multi-select, or search options for how users can interact with the filter.

  • Select Default Value: Automatically select a default value or allow users to choose one. This setting depends on the datatype.

  • Scope to Client: Filter options will be tailored based on the client. This ensures that filter choices are relevant to a specific client's data context.

  • Label Column Setup: Configure a label column that displays descriptive labels for the values being filtered. This enhances readability and user understanding of what each filter value represents.

  • Dependent Filters: Establish dependencies between filters, such as making a 'State' filter dependent on a 'Country' filter. This ensures that filter options are contextually relevant.

Applying the Filter:

Once the filter settings are configured, decide where to apply these filters within the dashboard:

  • Direct Apply: Immediately apply the filter to the dashboard elements.

  • Variable for Custom SQL: Obtain a variable that can be used in your custom SQL queries, allowing for more tailored data interactions.

    For a detailed guide on Variable Apply On, kindly refer the below link:

  • Custom SQL: Directly write the left-hand side (LHS) equals the right-hand side (RHS) condition in the WHERE clause of your SQL query.

After setting up the filters and their application, click 'Save' to finalize and activate them on the dashboard. This process enhances data interaction, making your dashboard more dynamic and suited to specific analytical needs.

πŸ”
Dashboard Filter - Variable Apply On