Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everyone,
I am trying to calculate average for below values shown in the bar chart.
i.e. Sum of Values shown on chart / no of days (i.e. 30)
Hi,
Should be just be something like
Current set analysis / Count(Days)
If you share a little information like current Set analysis and dimension names maybe able to suggestion a little more detailed answer
Thanks for your reply. here when we don't have a dimension and we calculate QlikSense calculates all distinct numbers and then divide by the count(Days).
(Count({$<Year=, Month=, Day=,Contact_Center={'121'},
Date={">=$(=date(monthstart(max(Date))))<=$(=date(max(Date)))"}>}
Distinct AgentID))
using above expression those value labels are calculated (as shown in the image - bar chart).
Expectation - sum of those numbers which are shown as labels / count (Days)
Is that really possible ?