Multi row conditional running average

[BosKev]

Hi,

I'm looking for a setup with the multi row tool that will be able to calculate the average based on Year/Month or more criteria.

Below sample I would like the multi row tool to calculate for "RunningAverage"

Thanks.

YEAR	MONTH	LINE_OF_BUSINESS_NAME	Job Type	Sum_Count	RunningAverage
2020	2020 / 01	GW	ABC	10656	10656
2020	2020 / 02	GW	ABC	10621	10639
2020	2020 / 03	GW	ABC	10555	10611
2020	2020 / 04	GW	ABC	10513	10586
2020	2020 / 05	GW	ABC	10437	10556
2020	2020 / 06	GW	ABC	10409	10532
2021	2021 / 01	GW	ABC	10636	10636
2021	2021 / 02	GW	ABC	10601	10619
2021	2021 / 03	GW	ABC	10535	10591
2021	2021 / 04	GW	ABC	10493	10566
2021	2021 / 05	GW	ABC	10417	10536
2021	2021 / 06	GW	ABC	10389	10512

[atcodedog05 · Accepted solution]

Hi @BosKev 

Here is how you can do it.

Workflow:

Hope this helps : )

[BosKev]

@atcodedog05 , thanks very simple!

[mmenth]

Hi @BosKev 

You can just bring on a record ID tool and use the running total tool on your metric you want to average. Then use a formula tool to divide the running total by the record iD:

Best,

mmenth

[atcodedog05]

Happy to help : ) @BosKev 

Cheers and have a nice day!