Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
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))