Handling Multiple Currencies in a Table

If your dataset includes rows with different currencies (e.g., $100 USD in one row and $100 CAD in another), Explo currently does not support setting a different currency code per row in a component.

Current Behavior

You can pass a currency-code to the component configuration, but this applies globally to the entire table or chart, not per row.

Workaround

If you’re displaying a data table, we recommend:

• Add a separate currency column

  Include a Currency column in your dataset (e.g., USD, CAD, ZAR) so end users can identify which currency applies to each row.

• Format values as strings in your database

  If you’re primarily concerned with how the values are displayed (rather than using them for sorting or aggregation), consider formatting them as pre-formatted strings directly in your source data (e.g., 'USD 100', 'CAD 75').