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.
This Report can do with 2 dimensión and Add the Filter Open_date from Request Detail folder
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.