Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Qlik Community,
I hope this finds you well. I am using the following expression in a KPI to calculate the average earnings of an embroiderer:
avg(aggr(avg({< DateType = {'Date Returned'}>}[Fees paid to embroiderer]), [I.D. #],DateType= 'Date Returned'))
This expression is giving correct results when in a KPI visualisation (The [I.D. #] field represents the worker ID and 'DateType' when they return a product to the company and get paid).
However when I put that expression in a bar chart with 'month' as a dimension the results are incorrect. The strange thing though is when I click on a certain month the average in the bar chart changes and becomes correct (e.g. if i click on December the bar for December suddenly matches he KPI result...but December on its own, before pressing the filter shows an incorrect result).
I can't seem to figure out why he bar chart shows incorrect results until I filter for a specific month. Any help would be much appreciated
Thank you for your support.
Best,
Mohammed
hi
aggr function is disregarding chart dimenision
so you need to add the month to the function
avg(aggr(avg({< DateType = {'Date Returned'}>}[Fees paid to embroiderer]), [I.D. #],DateType= 'Date Returned',month))
hi
aggr function is disregarding chart dimenision
so you need to add the month to the function
avg(aggr(avg({< DateType = {'Date Returned'}>}[Fees paid to embroiderer]), [I.D. #],DateType= 'Date Returned',month))
Thank you Liron!