Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a measure master item called as 'on target' based on 4 different dimensions for my product. This 'on target' field is % with missing data. I would like first to display the products with 'on target' calculated and a KPI for average % of 'on target' field.
It works perfectly on table chart to calculate average however it doesnt work with KPI. I used Avg(Aggr([On target], [Product])) to calculate KPI and on table chart I used Qliksense average to display. Any clue why it returns two different values? How can I make it average to show 83% as table shows rather 7% from KPI chart?
Many thanks,
Min
Avg(Aggr(Avg([On target]), [Product]))
Thanks Annat. It didnt work as Qliksense couldn't find my [On target] field as a measure in purple colour?
Avg([On target])
This should work, a view of measures on each table side panel is required to tell with additional context.