Hi Community,
My visualization should look like below
ID
| Measure Name | Code
| Measure Value |
|---|
| 1 | # of Accounts | 28 | |
| 2 | Total Inventory | 54 | |
| 3 | Total Bill | 13 | |
| 4 | Daily Inventory | 9 | |
| 5 | Daily Bill | 35 | |
In this, Measure Names are calculated fields each having some logic. I have to add ID which will be a sequential number and Code which will be some identifier for the fields.
Measure Value is the result of each measure name.
Both ID and Code are not present in the datasource, which is a SQL table. I don't have rights to add anything in SQL table.
Could you please suggest how can i add both these fields to my datasource.
Thanks,
Grishma
