đŸ› ī¸
Developer docs
Start BuildingGuides
  • ✨Getting Started
  • đŸŽ›ī¸Self Hosted Config
  • âœī¸SSO Login
    • Saml Identity Provider (Idp)
    • Oidc Identity Provider (Idp)
  • đŸŽžī¸Framework Specific Guide
    • âš›ī¸Reactjs
    • âš›ī¸Nextjs
    • âš›ī¸Vuejs
    • âš›ī¸Angular
    • âš›ī¸Svelte
    • âš›ī¸Solid
    • âš›ī¸Vanilla JS
  • â„šī¸Token
  • đŸ›ī¸Multi-Tenant Access Control
  • Embed using iFrame
  • 🔑License Key Validation for Self-Hosted App
  • Test
  • 👩‍đŸ’ģHelpers
    • âœŗī¸Token Body
    • ✅Options
      • Custom Fiscal Year filter setup in DataBrain
    • đŸˆ‚ī¸Server Event
    • Embed Functions
    • Override Language
    • âœˆī¸Embedding Architecture
    • âœˆī¸LLM Architecture
    • ✨LLM Connectors
      • Open AI
      • Claude AI
      • Azure Open AI
      • Llama
      • Mixtral
    • 🆔Dashboard ID
    • 🆔Metric ID
    • 🆔API Token
    • 🆔End User Metric Creation
    • Embedding APIs
      • Sync Datasource
  • Metric App Filter
  • Dashboard App Filter
  • Chat Mode
    • Step 1: Create Datamart and Workspace
    • Step 2: Create Data App and Embed ID
  • ✨Solutions Alchemy
    • Dashboards for Client Groups
    • Dashboard for Multiple Clients
    • Embedding: Role based Dashboard Filtering
    • Localized Currency Symbols
    • Manage Metrics
Powered by GitBook
On this page
  • Use Case: Representing Revenue in Different Countries
  • 1. Access Dynamic Property:
  • 2. Configure Dynamic Property:
  • 3. Verify Property Creation
  • 4. Configure formatting options:
  • 5. Save metric to Dashboard
  • 6. Verify Dynamic Property Functionality
  1. Solutions Alchemy

Localized Currency Symbols

This guide provides a practical approach for utilizing Dynamic Property to dynamically display revenue in multiple currencies for different countries.

PreviousEmbedding: Role based Dashboard FilteringNextManage Metrics

Last updated 3 months ago

Use Case: Representing Revenue in Different Countries

An e-commerce business operating in multiple countries needs to represent revenue in different currencies. The finance team chooses to analyze revenue trends in localized formats by selecting different countries. Here are the steps to implement Dynamic Property for revenue tracking:

1. Access Dynamic Property:

  • In the metric creation page, click on "[X]" icon near the sort icon.

  • This will open the "Dynamic Property" panel on the right side of the screen.

  • Then, click on "+Property" to add a dynamic property to your metric.

2. Configure Dynamic Property:

  • Enter the Property Name and choose between the two Property Types:

    • "Auto"

      • Choose the dataset and the column you want to consider.

    • "Custom"

      • Enter your SQL query to choose your dynamic value and dependent columns, and select the column name.

  • In this example, we select the column containing currency codes or create a custom query and save it as [[Units]]

  • Then, select the dependencies: dashboard or metric filter type. (Optional)

  • Click "Create" to save the property.

3. Verify Property Creation

  • Check the property listed in the Dynamic Property panel.

  • Copy the property name format: [[Units]] and close the panel.

4. Configure formatting options:

  • In the Formatting Section, set the prefix as [[Units]]

  • This ensures that revenue values in the Y-axis display the correct currency code dynamically.

5. Save metric to Dashboard

  • Click the "Save to Dashboard" button.

  • Then, use [[Units]] in

    • Metric Title

    • Metric Description

    • Metric Long Description, and

    • Footnote

6. Verify Dynamic Property Functionality

Metric Filter Example:

The [[Units]] dynamic property updates the currency unit based on the selected country in the metric filter.

Dashboard Filter Example:

The [[Units]] dynamic property updates the currency unit based on the selected country in the dashboard filter.

Please refer the below link on how to create Dynamic Property:

✨
Dynamic PropertyThis guide explains the process of using dynamic properties in metric creation. These properties can fetch dynamic values directly from the database, with dependencies on dashboard or metric filters.