This question was closed May 04 at 05:25 PM by Denis Konovalov for the following reason: The question is answered, right answer was accepted
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
Best Answer
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