Regarding the BOXI Reports

[shwetha gowda]

Hi Team,

This is regarding the BOXI reports that we need.

Based on the aging of the tickets as per the below format.

Request you to kindly help and let us know how to get the below tickets data format.

Main Category	(All)
Count of Incident Number	Incident Status
Aging	Acknowledged	Closed
>15	2	631
0-3		105
10-12		46
13-15	1	211
4-6		91
7-9	2	177
#N/A	1	4
(blank)
Grand Total	6	1265

 

 

Thanks

Shwetha

[Legacy User]

Hi shwetha.gowda,

 

To do the ranges you can create a variable and in it by if you define the sets.

 

For example:

IF ( [days] < 4 ) THEN "0-3" ELSE IF ([days] < 7 ) THEN ELSE "4-6" ELSE ">6"

 

Another variables has count with if.

 

Best Regards

Francisco

[shwetha gowda]

Hi favendano,

 

I have followed the below steps to add the variable.

But the variable is not able to save in the variable editor.

It says 0 doesn't  exist.

IF (  < 4 ) THEN "0-3" ELSE IF ( < 7 ) THEN ELSE "4-6" ELSE ">6"

Kindly help.

 

Thanks

Shwetha Gowda

CA Tools Admin

Tata Consultancy Services

Mailto: [e-mail]

Website: http://www.tcs.com

[Swarna.Kalidindi]

Issue got resolved over webex.

Created a variable editor for days: different between open date and Last modified date.

Now recreated the variable editor with "IF" statement given above and gave ">3" instead of "0-3" it worked.