Forum Discussion
kenyaherring93
Helper I
Helper IHelp in creating a clusted column chart with dates - open, closed, new
Hello --
I need help creating a column chart visual from data stored in a table shown below:
The chart should show the number of closed open and new incidents (Status) for each month like below:
Hi
First, normalize your table by 'Unpivot Other Columns' for 'Status' column.
so that your table looks as in below pic
In your Clustered Column chart visual, place 'Status' in the Legend.
2 Replies
- MasonMA
Super User
Hi
First, normalize your table by 'Unpivot Other Columns' for 'Status' column.
so that your table looks as in below pic
In your Clustered Column chart visual, place 'Status' in the Legend.
kenyaherring93Thank you! This works!