DX NetOps

 View Only
Back to discussions
Expand all | Collapse all

How we can calculate Business and Non Business Hrs in Jasper Studio 6.2

  • 1.  How we can calculate Business and Non Business Hrs in Jasper Studio 6.2

    Posted Mar 30, 2018 09:28 AM

    Hi,

     

    I am trying to calculate Network Availability Report in Jasper from CA Spectrum DB. And for that I created a Report where I am Calculating Total Downtime(duration_Second table) , Now divided Down time into Primary Business Hrs(08:00 AM to 20:00PM) and Non Business Hrs(00:00 AM to 8:00AM and 20:00 to 11:59:59 PM) and also calculating total Availability of devices  but I am unable to calculate the Availability Time for Primary Business Hrs and Non Business Hrs.. Can any one help me to calculate the Avalaibility Reports in both Primary Business and non Primary Business hrs.

    Here I am attaching a sample Report.

     

     

      



  • 2.  Re: How we can calculate Business and Non Business Hrs in Jasper Studio 6.2
    Best Answer

    Broadcom Employee
    Posted Jun 07, 2018 04:41 AM

    There is some discussion regarding this in this thread.

     

    How to calculate business hours/minutes between... |Tableau Community 

     

    best regards,

    Glenn