Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Live Chat, June 29th 10AM ET. Bring your Qik Sense Enterprise, Client Managed questions! REGISTER
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
Partner

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))