Forum Discussion

davidi4524's avatar
davidi4524
Icon for Helper III rankHelper III
8 years ago

Previous Day Value comparing

hi. i have a table that show a number of service call that perform per technician i created a calculated column that show me the average number of the serice calls that each technician made today (...
Need Help
Floriankx's avatar
Floriankx
Icon for Solution Sage rankSolution Sage
8 years ago

How do you Calculate your average column?

 

I a Measure it would be

PreviousDay:=CALCULATE([Average],DATEADD(DateColumn,-1,days)

 

What also could work is using the same formula you used for average and wrap your day by PREVIOUSDAY.