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

avg expression

I am using the below formula to count the number of projects in a given month. I am trying to transform the below formula into "avg projects by Month". If anyone could help me determine the best way to avg the below i would appreciate it. 

 

Dimensions: MONTH

Expressions: Count({<Dept={"44840"},project_name-={"PMO Test","PMO IMS Pipeline"},epic_status-={"Not Required"},Distinct epic_summary)

 

Labels (1)
1 Reply
lironbaram
Partner - Master III
Partner - Master III

hi 

i order to get the avg by month use the aggr function 

something like 

avg(aggr(Count({<Dept={"44840"},project_name-={"PMO Test","PMO IMS Pipeline"},epic_status-={"Not Required"},Distinct epic_summary),MONTH))