I have a set of rows that I want to turn into a line chart with multiple lines like this:
- x-axis is dates (done)
- y-axis is values (done)
- there are 3 lines, one for each value of "subject id" (i can't do this)
Is there a way to pivot / melt this table in the explore menu so that subject ID becomes three columns, one for each distinct value, and the column holds the "value" column. I think I could do this by making a derived table where the entire subject ID column is pivoted out, but that seems like a hacky solution for a very simple function (adding color to a plot)
"value" column holds floating point numbers, redacted for privacy.
Solved! Go to Solution.
Try converting the value field into a measure and then pivot on Subject ID.
Try converting the value field into a measure and then pivot on Subject ID.
this worked. thank you