Forum Discussion
Filter a cluster column chart on multiple columns
Hello everyone, I am trying to filter a cluster column chart to only show servers with less than 100% uptime. The data source populates the table with servers as columns and months as the row...
It's not going to be easy with the data in that format.
I think you should Unpivot all the columns except 'Month'. You'll have all the numeric uptime figures in one column and you can filter that from the filter pane on the clustered column chart
HotChilli
Community Champion
Community ChampionIt's not going to be easy with the data in that format.
I think you should Unpivot all the columns except 'Month'. You'll have all the numeric uptime figures in one column and you can filter that from the filter pane on the clustered column chart
I spent hours trying to work that out and got nowhere. That solution fixed it in seconds.
Thank you so much.