Set Analysis (AVG Aggr)

[RK121]

Hello community,

Calculate YTD - Average:

I am trying to apply set analysis on the table to calculate the Average Count for different types of tickets by Users for the current year.

I also have Couple types of Ticket Action.

I am using this formula, but it doesn't calculate avg for current year per User, per Ticket Action.

=Avg(Aggr(count({$<Year={'=Year(Today())'} >}([Trouble Ticket ID])),[Ticket Action],User))
/
num(Month(now()))

[aschuchner_chicagoatlantic · Accepted solution]

It looks like you have a problem in your set analysis. It cannot evaluate a formula unless you do it with a $ expansion. Try this:

=Avg(Aggr(count({$<Year={'$(=Year(Today()))'} >}([Trouble Ticket ID])),[Ticket Action],User))

[RK121]

Works!Thank you!