CA Service Management

Dear All

     I would like to create service desk weekly report on Web Intelligence.

I will to count the tickets on weekly to report.

detail of column

'Date Number' is =DayNumberofMonth([Open Date])

'count of incident is' =Count([Incident Number])

I will count day to weekly.

Week                                       count of tickets

Week1(date 1-7)                    6

Week2(date 8-14)                  5

Week3(date 15-21)                77

Week3(date 22-28)                8

Week4(date 22-28)                8

Week5(date 29+)                  0

Can you advice me to do this?

Thank you,

Yutthachai

HI Yutthachai

I did documented how a report showing the number of Incidents in a week can be created. Have a look at the document I did attach.

Regards

   Baerbel

Hi Baerbel,

    Thank you for your share idea, the 'week of the open date' is weekly open in calender?

If i run report on January 2016,  In week1 i have 2 days on report is correct?

-Friday and Saturday.

I will to count day1 to day 7.

Now, I can do it.

'Week per month' on 'Dimension' Formula is

=If([Day]Between(1;7)) Then "Day1-7"
ElseIf([Day]Between(8;15)) Then "Day8-15"
ElseIf([Day]Between(16;21)) Then "Day16-21"
ElseIf([Day]Between(22;28)) Then "Day22-28"
Else "Day29+"

to count days.

'Type Symbol' to count Incidents, Requests

'count of ticket' on 'Measure' Formula is

=Count([Ticket Number])

to count all days.

Best Regards,

Yutthachai