BOXI Report

[rkalidh87]

Hi,

 

I need to design a report which will shows the ticket numbers count( incident/request/problem) with respect to that CI.

 

EX:           incident count    request count  problem count

CI name    122                   45                    12

 

and the filters should be open date between two dates.

 

pls help on how to create variable where reference to be taken from other object.

 

kindly help to design this report.

[Legacy User]

Hello,

 

This Report can do with 2 dimensión and Add the Filter Open_date from Request Detail folder

 

Affected_resource

Type

 

Create 3 variables type indicator with follow formula:

=SUM(IF([type] = 'R';1;0))

=SUM(IF([type] = 'P';1;0))

=SUM(IF([type] = 'I';1;0))

 

Add this 3 variables and affected resource to a vertical block.