CA Service Management

 View Only
  • 1.  BOXI Report Assistence

    Posted Oct 18, 2016 08:23 AM

    Hi Everyone,

     

    I need to create a BOXI report for CA SDM tickets that were touched by an analyst between the hours of 2:00 am and 12:00 noon on a monthly basis.  My thought would be to create a variable something like this: =If [Format Date] Between("09-01-2016"; "09-30-2016") And [Format Time] Between("02:00:00 a"; "12:00:00 p") Then [Open Date]

    The variable Format Date is =FormatDate([Open Date]; "mm,dd,yyyy") and Format Time is =FormatDate([Open Date]; "hh:mm:ss a"), but this isn't giving me any results on the report.  What am I missing?

     

    Thanks,

     

    Joyce Lilie



  • 2.  Re: BOXI Report Assistence

    Posted Oct 21, 2016 04:55 PM

    create a dimension called "Filter-Open Date Time Range"  formula -> FormatDate([Open Date]; "HH")

    Then Count the HH

    Nightly Count -> =Count([Ref Num] Where([Filter-Open Date Time Range]="00" Or [Filter-Open Date Time Range]="01" Or [Filter-Open Date Time Range]="02" Or [Filter-Open Date Time Range]="03" Or [Filter-Open Date Time Range]="04" Or [Filter-Open Date Time Range]="05" Or [Filter-Open Date Time Range]="06" Or [Filter-Open Date Time Range]="19" Or [Filter-Open Date Time Range]="20" Or [Filter-Open Date Time Range]="21" Or [Filter-Open Date Time Range]="22" Or [Filter-Open Date Time Range]="23";[Filter-Open Date Time Range]);All)

     

    I am using that Nightly Count in the report and time range is 7pm - 7 am.

     

    below link tells you various ways of formatting a date field in CABI.

    https://bobjblog.wordpress.com/2012/03/05/web-intelligence-date-formats/



  • 3.  Re: BOXI Report Assistence

    Posted Oct 26, 2016 11:01 AM

    Thanks Sudip, I think that suggestion will get me started.  I will let you know if I have any further questions.

     

    Thanks,

     

    Joyce