Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
mparker123
Contributor

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

Re: avg expression

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