Skip to Content

Tickets opened in the Previous week

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • 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

    Add comment
    10|10000 characters needed characters exceeded