Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

How to calculate Business Hours in a Report

Received Response
1
Views
1
Comments
User_DBCL0
User_DBCL0 Rank 4 - Community Specialist
edited Aug 13, 2024 5:34PM in Oracle Analytics Cloud and Server

Hello All,

I have a create_date column which is in date format. I need to calculate the SLA timings based on create_date column.

I must exclude saturday and sunday and consider business hours like 8 am to 6 pm.

I dont have time dimension and dont have rpd access to . I should do it report only.

please help

Answers

  • asim cholas
    asim cholas Rank 6 - Analytics Lead

    Hello,

    Try below formula for finding SLA period. Also you can use dayofweek function if you need.

    CASE  WHEN (Hour(create_date )+cast(MINUTE(create_date ) as double)/60 BETWEEN 8 AND 18) AND DAYNAME(create_date ) IN ('Fri', 'Mon', 'Thu', 'Tue', 'Wed') then 'SLA Window' else 'Non SLA Window' END

    Thanks

    Aj