Year over Year / Month over Month comparison in a chart

AnalyticsDev — Tue, 23 May 2023 22:30:34 GMT

Hi,

I have a need to do a year over year, month over month comparison in a bar/line combo chart. The bar measure would display the difference in 'sales' numerically, and the line would show the percent change.

Example data for Year over Year:

Mar-2022 10000

Apr-2022 10000

Mar-2023 11000

Apr-2023 15000

In the bar/line combo chart, I would show the months across the bottom as the dimension. For March, the bar would show 1000 and April would show 5000 (the difference in march 2022 vs march 2023 and april 2022 vs april 2023). The percent line would be the percent change (March would be 10% and april would be 50%).

Example Data for Month over Month:

Mar-2023 11000

Apr-2023 15000

The bar for April would show 4000, the difference in growth between the two months, the percent would be 36%.

A lot of searching the forums shows me how to calculate one individual month comparison but it doesnt work in a chart with all 12 months.

Thanks in advance.

topic Year over Year / Month over Month comparison in a chart in App Development

Year over Year / Month over Month comparison in a chart