topic Re: Trend graph calculation for rolling 12 months in App Development

Trend graph calculation for rolling 12 months

Binny3 — Sat, 16 Nov 2024 21:27:59 GMT

Hi ,

I just want to show rolling 12 months in graph when I select a particular month. It is working fine for all months except the latest month. When I select latest month my trend graph is showing rolling 11 months except latest month. But when I select any other month rolling 12 months are shown including selected month.

Example: If I have data Apr 2017 to Jan 2019 if I select Jan 2019 graph is showing Feb 2018-Dec 2018 but not till Jan 2019

when I select Dec 2018 it showing Jan 2018 to Dec 2018 which is correct. The following is the formula I am using:

{<MyDatecol={"<=$(=MyDatecol)>=$(=date(addmonths(max(MyDatecol),-11),'DD-MMM-YYYY'))"}

Re: Trend graph calculation for rolling 12 months

sunny_talwar — Tue, 05 Feb 2019 12:15:49 GMT

Can add this to a KPI object and see what this shows?

='>=' & Date(AddMonths(Max(MyDatecol), -11), 'DD-MMM-YYYY') & '<=' & Date(MyDatecol, 'DD-MMM-YYYY')

Re: Trend graph calculation for rolling 12 months

pradosh_thakur — Tue, 05 Feb 2019 12:16:26 GMT

{<MyDatecol={"<=$(=date(max(MyDatecol)))>=$(=date(addmonths(max(MyDatecol),-11),'DD-MMM-YYYY'))"}

Re: Trend graph calculation for rolling 12 months

Binny3 — Tue, 05 Feb 2019 12:27:44 GMT

I tried implementing the formula you posted but the issue now is it is working fine for latest month but not for the other months.

Re: Trend graph calculation for rolling 12 months

sunny_talwar — Tue, 05 Feb 2019 12:32:19 GMT

With date range do you see with this new expression?

Re: Trend graph calculation for rolling 12 months

Binny3 — Wed, 06 Feb 2019 05:01:10 GMT

Date range for?? Please explain it ...

Re: Trend graph calculation for rolling 12 months

sunny_talwar — Wed, 06 Feb 2019 12:22:14 GMT

In your response to Pradosh, you mentioned that this works for the latest month, but not for the other months. What date range do you see for other months? Why do you think it isn't working for other months?

Does that clarify my question?