My visualization should look like below
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.
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.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...