How can i do weighted average function so that I got over two columns
Assuming you have two columns named value
and weight
, then you could calculate the weighted average as follows:
sum( value * weight)
/
sum(weight)
Hi,
I want to calculate a weigthed average with correct time aggregation, and i try this, but doesn’t work (i have a error in quicksight).
Someone have already calculate a weighted average in Quicksight ? with correct aggregation ? Quicksight have few aggregate function :
Thx,
Sylvain
Ok,
I have find the answer.
There is 2 type of “calculated field” (Dataset and analysis), the solution work with “analysis calculated field”.
Thx,
Sylvain