Plotting multiple years by month for a measure.

[AbuHaneefah]

Hi,
For some reason I can't seen to remember how to do this really simple thing.

I want to plot Month Name as the X axis against a measure on the Y axis.
I want each year to show as a separate line on a graph.

I am sure I have done this before, I can't seem to do it on either the legacy charts or on the new visualisations.

Can anyone help me out?

thanks in advance

[MFGF]

Hi,
For some reason I can't seen to remember how to do this really simple thing.

I want to plot Month Name as the X axis against a measure on the Y axis.
I want each year to show as a separate line on a graph.

I am sure I have done this before, I can't seem to do it on either the legacy charts or on the new visualisations.

Can anyone help me out?

thanks in advance

Hi,

Do you have an item that contains just the month name (without the year being part of it)? This would go in the X-axis, the measure in the Y axis and the Year in the lines.

Here's an example using the GO Sales (Query) sample package (attached).

Cheers!

MF.