Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am looking to calculate an expression that takes the average sum of Spend for (fieldname) [Expense Type] = {'Airfare'} by quarter aggregated by Employee Name. Right now I have what is shown below, but I am not sure where to incorporate quarter field.
Avg(aggr(Sum({<[Expense Type] = {'Airfare'}>} AmountSpend),[Employee Name]))
try this
Avg(aggr(Sum({<[Expense Type] = {'Airfare'}>} AmountSpend),[Employee Name], Quarter))
and let me know
If you are using Quarter as your dimension, I don't really see why you would quarter in the expression. Have you tried this with Quarter as your dimension? Is it not giving you the expected output?
This document might help.
It is within a straight table
Thanks Alessandro, I want to say this worked but I am doing some QC checks first.