Just another rolling average challenge

SuwerenPL — Thu, 08 Feb 2024 18:36:50 GMT

Hello,

I'm stuck in an attempt to create a deviation from rolling average line chart (and a table as a byproduct).

The intended result would be:

The chart must be responsive to selections - max selected month excludes later data, other fields work normally.

So far I have tried the following:

=Sum(Aggr(RangeAvg(Above(Sum( {$<[Rok-Miesiąc]>} [Wprowadzone]), 0, 3)), [Rok-Miesiąc]))

=RangeAvg(Above(Sum({<[Rok-Miesiąc]= >}[Wprowadzone]), 0, 3))

=Sum({<[Rok-Miesiąc]=, [Data] = {">=$(=AddMonths(Max(Data),-3))<=$(=Max(Data))"}>} Wprowadzone)

[Wprowadzone] is just a counter field that after sum() corresponds to values in B column in the Excel example.

Nothing works as intended, averages are all over the place or just plain incorrect from my perspective. Any clue what I'm doing wrong would be much appreciated.

Re: Just another rolling average challenge

Lisa_P — Thu, 08 Feb 2024 23:12:45 GMT

I think you're making it too hard, try this:

RangeAvg(Below([Created in given month], 1, 3))

Re: Just another rolling average challenge

SuwerenPL — Fri, 09 Feb 2024 05:58:38 GMT

@Lisa_P That's what I was looking for 🙂 Thanks!

topic Just another rolling average challenge in App Development

Just another rolling average challenge

Re: Just another rolling average challenge

Re: Just another rolling average challenge