Hi, I am looking for help in calculating correct attainment % in cell F8 in the attached screenshot. Currently, my sumover calc looks something like this and attainment shows 180% but it should be 160% since values for c & d are same. Attainment % = sumOver(distinct_count(kpi),[manager, employ…

Hi @mansiish , It seems to be a very similar use case to my blog post here: [image] Calculated fields, level-aware aggregations, and evaluation order in Amazon... Amazon QuickSight is a fast, cloud-native, serverless, business intelligence service that makes it easy to deliver insights t…

Sum of Distinct Count (ID)

Question & Answer

yingliao422 March 17, 2023, 7:41pm 7

Hi @mansiish,

It seems to be a very similar use case to my blog post here:

Hope it helps!
Thanks,
Ian

1 Like