I have a table which holds department scores for multiple departments over the 12 months of the year.
I am trying to create a line chart with Months as the X-axes and multiple Y-axes for up to 5 different Department scores.
If I filter my table to nly contains 1 department , I have no issue. The dept scores for each month are shown correctly over the months on the chart.
As soon as I include another department in the table, only the first month's data appears to be shown for both departments.
What am I doing wrong?