Clarity Service Management

Expand all | Collapse all

BOXI Report

Jump to Best Answer
  • 1.  BOXI Report

    Posted 07-25-2016 10:56 AM

    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.



  • 2.  Re: BOXI Report
    Best Answer

    Posted 08-05-2016 07:21 PM

    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.