Tickets opened in the Previous week

[former_member318041]

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

[jyothirmayee_s · Accepted solution]

Hi,

Current Week

=Week([CurrentDate])

Now use [Previous Week] to get your count.

=Count([IAM Interaction ID]) Where ([Current Week] -1)

Thanks,

Jothi