Pass Previous Year Variable to Expression

[Anonymous]

I am trying to compare this month to same month last year with a rolling 12 month period for

'Average Daily Contracts Received for Processing per month'

Here is my expression for current year. It aggregates the daily averages for the timespan selected, which is usually fiscal year to date:

=Avg(Aggr($(eNewInBusUnit),Month, Date))

What would be the expression to get previous year's data?

[dplr-rn]

put something like below in your set analysis

Year={'$(=Year(Max(DATE))-1)'}

[Anonymous]

I'm assuming you mean like this in replacement of 'Month, Date'? However, I am getting the infamous red line under the 1st bracket. Do you know the exact syntax in conjunction with the expression given?

=(Avg(Aggr(($(eNewInBusUnit)),Year={'$(=Year(Max(DATE))-1)'

[dplr-rn]

No. I mean repeat same logic as current year with the new set analysis

Let me put it this way whats the expression within eNewInBusUnit

[Anonymous]

eNewInBusUnit=count({<DateType={'SLAQueueStart'}>}BusinessUnit)