Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Joosh
Contributor II
Contributor II

AVG(Count) nested aggregation

I'm trying to get a YTD average of a count of employees

I use this formula to count the employees

COUNT(Global Career Band) in a line chart, my date field is called MonthName, in format 'MMM-YY'

Joosh_1-1643646580067.png

How can i use this chart to show a YTD average, so on January it would show 27257, but on february it would take the average of february and january and so on.

 

Thanks

 

 

 

 

 

10 Replies
Joosh
Contributor II
Contributor II
Author

Joosh_0-1643741595173.png

 

I've updated it to use the {1} in the set analysis to ignore all selections. and it still is not liking it.

 

Josh