Forum Discussion

mamuewue's avatar
mamuewue
Cloud Apps
04-03-2023
Solved

Weighted Average Challenge

Hi Community, I'm trying to resolve a weighted average challenge, but i can't get to it. Hoping there is help out there. My table has data as follows: In a pivot a present the two months s...
dashboards & reporting
  • Angelina_QBeeQ's avatar
    Angelina_QBeeQ
    04-03-2023

    In this case you need  multi-pass aggregation.
    You manually set the "Customer" group in the formula and summarize the results.

    Sum( [Customer],

[Total MRC] -
((
  ([Total MRC], PREV([Months in Revenue_Date],1))
/
([Total Devices], PREV([Months in Revenue_Date],1))
)

* [Total Devices]
)

)

    Try this option please.

    Kind regards,
    Angelina

mamuewue's avatar
mamuewue
Cloud Apps
04-03-2023

Hi Angelina, 

this is very helpful as a first step. I can can compute the number now in the table where I have all customers listed (picture marker 2). However, is there also any way to make the formular "Weighted Average" in the above pivot (picture marker 1), where no customers are listed (and just the sum)? 

 

 

Angelina_QBeeQ's avatar
Angelina_QBeeQ
ETL
04-03-2023

In this case you need  multi-pass aggregation.
You manually set the "Customer" group in the formula and summarize the results.

Sum( [Customer],

[Total MRC] -
((
  ([Total MRC], PREV([Months in Revenue_Date],1))
/
([Total Devices], PREV([Months in Revenue_Date],1))
)

* [Total Devices]
)

)

Try this option please.

Kind regards,
Angelina