topic Re: Divide DataX(Month) by DataY(Previous Month) in a Monthly Line chart in App Development

Divide DataX(Month) by DataY(Previous Month) in a Monthly Line chart

bertrand01 — Tue, 21 Jan 2020 11:20:38 GMT

Hi everybody,

I have to make a Monthly Line chart.
Basically, I want to divide DataX(Month) by DataY(Previous Month) in a Monthly Line chart.

I have tried this kind of set analysis :

=Date={"=AddMonths(Date,-1)

But I get the same value as the current month ?

Any idea what I can try ? I would not like to make this in the load script.

Re: Divide DataX(Month) by DataY(Previous Month) in a Monthly Line chart

Kashyap_R — Tue, 21 Jan 2020 11:26:26 GMT

Try this

Current

Sum({<[Date]={">=$(=MonthStart(max([Date])))<=$(=Date(Max([Date])))"}>}Value)

Sum({<[Date]={">=$(=MonthStart(Addmonths(max([Date]),-1)))<=$(=(Addmonths(max([Date]),-1)))"}>}Value)

Thanks

Re: Divide DataX(Month) by DataY(Previous Month) in a Monthly Line chart

bertrand01 — Tue, 21 Jan 2020 16:35:36 GMT

Thanks, but this can only work for max month, not for every month as it is based on the max date.
I want it to work in a line chart for every month, month being the X axis.

Re: Divide DataX(Month) by DataY(Previous Month) in a Monthly Line chart

Kashyap_R — Tue, 21 Jan 2020 16:54:40 GMT

try this

Sum(Value)

Above(Sum(Value))

Sort according to month

Thanks