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.
There is some discussion regarding this in this thread.
How to calculate business hours/minutes between... |Tableau Community