AnsweredAssumed Answered

How to count date to weekly in webi

Question asked by ENTIIS_TH on Jan 21, 2016
Latest reply on Jan 26, 2016 by ENTIIS_TH

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

Outcomes