Hi all,
I am using this formula
=Count([IAM Interaction ID])
to calculate the amount of tickets.
I am looking for a way to calculate the amount of tickets opened in the previous week.
There are timestamps available in the field [IAM Open Time].
Can you help?
TIA,
Henning
Apr 11, 2017 at 05:59 PM
Hi,
Current Week
=Week([CurrentDate])
Now use [Previous Week] to get your count.
=Count([IAM Interaction ID]) Where ([Current Week] -1)
Thanks,
Jothi