Solved: Weighted Average of three calculation totals in a ... - Page 2

alex_leonhard · 03-21-2023 07:24 AM

Hi,

I am stuck with a relatively simple issue. Nevertheless, I have the feeling that the solution might be quite complicated:

I have a Dashboard with three Looks. In every look there are Number of Orders, Revenue and costs. Additonally, there are two simple calculations for total margin and margin share. These three Looks are now sitting in my Dashboard and what I would love to have is one Number on top of the Dashboard that shows me the weighted average (based on number of orders) margin share of the 3 totals from the Looks.

What is the easiest way to achieve this?

jcdufault

Hello Alex,

If I understand correctly, you could achieve this through merged queries. Explore one of your Looks and in the look-creation UI click in the cogwheel in the upper right corner and select “Merge Results”. From there you will have to recreate the other 2 looks and merge by their common dimension. Once everything is in the same “Look” you can make a table calculation leveraging all 3 numbers. You might have to get creative with sums and pivots but it should be doable.

View solution in original post

Weighted Average of three calculation totals in a dashboard