Multiple aggregation calculations are showing errors when using with Lag Function

Q&A
, , ,
4

Hi @DylanM , These are the calculations that i am using
1.Active headcount= ifelse(isNull({Lag for prior}),sum({active_head_count}),{Lag for prior})
2.Lag for prior= lag(sum({Expected Ending Headcount}),[date ASC],1)
3.Hires=(hires)${AddHires}
4.Terms= terms+${AddTerms}
5. Expected Ending head count= {Active headcount}+Hires+Terms

Please find the link to Quicksight Arena created for this:
Multiple Aggregation Calculation Eg

1 Like