Delta across different subseta

[aus94]

Hello, I am limiting data using subsets, as shown in the following link: https://www.bigmountainanalytics.com/part-6-data-limiting-with-subsets/

Considering the figure below, I would like to plot the delta between red and each blue bar for each month. I don't want do add calculated columns and I would like to do it within the visualization.

Is it possible?

 

Thanks!

[David Boot-Olazabal]

Hi,

You can try to add another y-axis variable, that calculates the difference. In the example I used, this is the formula I used:
Sum([Class Sales Year 1]) THEN [Value] - First([Value]) OVER (NavigatePeriod([Axis.Color],0,-1))

The analysis file looks like this (with an overview of the settings I used for the above formula):

I have used Marking as the input for my subset (hence the yellow highlighted States in the US) and calculated the difference over the color axis (rather than the default category axis).

Kind regards,

David

[aus94]

30 minutes ago, David Boot-Olazabal said:

Hi,

You can try to add another y-axis variable, that calculates the difference. In the example I used, this is the formula I used:
Sum([Class Sales Year 1]) THEN [Value] - First([Value]) OVER (NavigatePeriod([Axis.Color],0,-1))

The analysis file looks like this (with an overview of the settings I used for the above formula):

I have used Marking as the input for my subset (hence the yellow highlighted States in the US) and calculated the difference over the color axis (rather than the default category axis).

Kind regards,

David

Thank you very much, this really helped me!