Is it possible to create a line graph showing 2 dimensions over time, as shown in the pic below?
In my data I have several shops in an Area. I want to see how a certain shop is performing measured against the Area it is in.
Would you be able to share some raw data behind this sort of output?
Have you tried using the reference line for your Area?
use month as dimension and 2 expression each one with defined dimension via set analysis
Depending on how you data is organized, you can either have 2 Dimensions (Month, Shop) with a measure of sales or as Robin indicates, 1 Dimension and 2 measures, one for each shop.
The first method would automatically acccomodate a 3rd shop....
Retrieving data ...