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
Hi Grishma,
You would have to Pivot your measures and then create different fields for ID and Code in the style of CASE [measure name] WHEN "abcde" then "1".
Hope this makes sense.
Best,
Diego
Become a Viz Whiz on the Forums! Support the Community and master Tableau.