31 Oct 2025 06:21 AM
I am currently adding a new SQL in our custom SQL query extension.
The SQL will return data like the following:
| Currency | Count |
| AUD | 10 |
| MYR | 6 |
| NZD | 12 |
What will be the behaviour when the data being ingested. Will each row being regarded as 3 individual metrics data with 2 dimensions, like:
Metrics 1 - AUD, 10
Metrics 2 - MYR, 6
Metrics 3 - NZD, 12
or it will include all rows into a single metrics?
04 Nov 2025 10:56 PM
Depends on how you configure it. If you configure the currency as dimension, you will get 1 metric with 3 dimensions in it.