topic last six months rolling window not working on month Selection in chart/filter. in App Development

last six months rolling window not working on month Selection in chart/filter.

mehek9074 — Sat, 16 Nov 2024 19:41:46 GMT

Hi Folks,

I am using this logic to calculate last six month rolling window average from last month to its last six months.
RangeAvg(Below(total avg({<MonthStart=>}Overall_Score),-1,6))
(where monthStart Is my field name having values in the form of Month-Year)

e.g: value in November 2019 will be the : average of values in (oct 2019,sept2019, aug 2019, Jul 2019, Jun 2019, May 2019)
The logic is working fine, however, when I am selecting any month in chart or from filter,It is not diplaying that last 6 month rolled up value.
I am getting the original value for that month.
Can anyone help me on this?

Re: last six months rolling window not working on month Selection in chart/filter.

Anil_Babu_Samineni — Tue, 12 Nov 2019 07:13:23 GMT

What is the purpose you are using "MonthStart" as ignore field?

Re: last six months rolling window not working on month Selection in chart/filter.

mehek9074 — Tue, 12 Nov 2019 07:39:24 GMT

Hi ,

I was using it to ignore the selections on monthstart field.Just for the try to freeze the values,so that it won't change if user makes anyselection.
If I remove it, then also I am not getting expected output on month selection.

Re: last six months rolling window not working on month Selection in chart/filter.

Anil_Babu_Samineni — Tue, 12 Nov 2019 09:34:31 GMT

If you are using Month as filter, This won't work since this expression will give the static way but dynamic If we are not selecting any? Perhaps this

If(GetSelectedCount(Month)>0, Sum({1<Month = {">=$(=AddMonths(Max(Month),-6))<=$(=Max(Month))"}>} Overall_Score),RangeAvg(Below(total avg({<MonthStart=>}Overall_Score),-1,6)))