Could I use Level of Detail Expressions with this to calculate the delta year-over-year?
1 of 1 people found this helpful
You could or you could use calculated fields
If cy/py = 'Current year' then Visits per hour
if cy/py='Prior Year' then visits per hour
a third calculation one subtracted from the other
I get the error message:
Cannot mix aggregate and non-aggregate comparisons or results in 'IF' expressions
IF [CY/PY]='Current Year'
THEN [Vists Per Hour]
Could you please mark any replies you find helpful as helpful and the question answered when you reach the desired result.
Let me know if there is anything else you would like help with
sorry to jump in here after all this time, but I'm having problems to reproduce the very last step of this process and I'm hoping someone can help.
I was able to get to the point where I have the two columns `Current Year` and `Prior Year`.
But I can't figure out how to show this as %change. Ideally I would like to have one column with:
(`Current Year` - `Prior Year`)/`Current Year`
Can anyone please help out with that!
I've actually been able to solve this issue, using "Add Table Calculation" menu, then Calculation Type "Percent Difference From", computing using "Table (across)" and finally relative to "Next"