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