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
Hi,
Current Week
=Week([CurrentDate])
Now use [Previous Week] to get your count.
=Count([IAM Interaction ID]) Where ([Current Week] -1)
Thanks,
Jothi
You already have an active moderator alert for this content.
Add comment