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?