Hi,
I have a database like this:
I need to calcolate in tableau a weigted average based on the field sales and the result of the discount should be 0.6733, how can I do it in tableau for having a table like
category: a sales 150 discount 0.6733
Thanks
3 answers
Good morning @Giada Togliatti
weighted averages can be calculated with table calculations or lods - I always recommend the LODs - see the the last couple of examples here https://jimdehner.com/2020/05/12/faq-series-weighted-averages/