Skip to Content
0

Tickets opened in the Previous week

Apr 11, 2017 at 09:33 AM

38

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Jyothirmayee A Apr 11, 2017 at 05:59 PM
0

Hi,

Current Week

=Week([CurrentDate])

Now use [Previous Week] to get your count.

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

Thanks,

Jothi

Share
10 |10000 characters needed characters left characters exceeded