Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

filtering

Hi. I have a table with 6 metrics which I want to visualize using bar charts. (say Metric1 - Metric6) Those columns have numeric values. Can I make a selection filter so that the user decides to...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    5 years ago
    Hi.
    Those 6 metrics are not in the same column.
    I was able to solve by using the unpivot option and creating 2 new columns, one stores the specific metric and the other its value. From there I could easily use it as a filter.

    I guess the switch function works as well but I haven't tried it out.
    Thank you