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 rows.
In the chart the X-axis is Month/Year, with Y-Axis being the different servers.
Example data:
Any help is appreciated.
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
2 Replies
- HotChilli
Community Champion
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