Changing Aggregate Formula from Week to Month?
HI Guys,
I came across the following code to bring back a weeks worth of data.
1. Display number of tickets received on last week
Countif(Ispreviousweek("Request"."Created Time") = 1)
2. Display number of tickets CLOSED on last week (tickets were received on last week as well)
Countif(Ispreviousweek("Request"."Created Time")=1 and Ispreviousweek("Request"."Completed Time")=1)
3. Display number of tickets received on last week, but not yet CLOSE
Countif(Ispreviousweek("Request"."Created Time")=1 and"Request"."Request Pending Status"='Yes')
4. Display number of tickets CLOSED on last week and that ticket was received before last week
Countif(Ispreviousweek("Request"."Completed Time")=1 and Ispreviousweek("Request"."Created Time")=0 and Iscurrentweek("Request"."Created Time")=0)
How would I change this, so it reported on the previous month? I did try and change previousweek to previousmonth.
Thank You
Topic Participants
David Egan
Tamilarasan A
New to M365 Manager Plus?
New to M365 Manager Plus?
New to RecoveryManager Plus?
New to RecoveryManager Plus?
New to Exchange Reporter Plus?
New to Exchange Reporter Plus?
New to SharePoint Manager Plus?
New to SharePoint Manager Plus?
New to ADManager Plus?