Skip to Content
avatar image
Henning Deschka

Tickets opened in the Previous week

Apr 11, 2017 at 09:33 AM | 62 Views | Last edit May 04, 2018 at 05:24 PM 2 rev.

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

SAP BusinessObjects - Web Intelligence (WebI)
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Jyothirmayee A
    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