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

Filter Based on Time

Received Response
161
Views
6
Comments
User_F6761
User_F6761 Rank 2 - Community Beginner
edited August 2024 in Oracle Analytics Cloud and Server

Hi Team,

How to filter out lead records that are auto-created during non-office hours?

Like I need to show lead which is assigned  after 5 pm till 8:59 Am next day in OBIEE report

It's a daily report.

Only Friday is a holiday.

Office hours are from 9 am to 5 pm.

Thanks

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    I'm not really sure what you expect as answer ...

    What about adding a filter to your analysis on your datetime column?

    By the way: double, triple (and more) posting is against the rules of the community.

    OBIEE Report

    OBIEE Report - Filter Based On TIME

  • User_F6761
    User_F6761 Rank 2 - Community Beginner

    Hi Gianni,

    I need to show leads that are automatically assigned on non-working hours.

    Lead Creation date is Datetime type. So how can I filter Leads that created between 5 pm & 8:59 am for daily report ?

    Thanks,

  • Gianni Ceresa
    Gianni Ceresa Mod

    I'm not really sure what you expect as answer ...

    What about adding a filter to your analysis on your datetime column?

    Sounds like we are in a circular conversation!

    Keep in mind one thing: OBIEE is an empty product. Nobody here see your screen. You talk about "Lead Creation", this is a column only you see, it isn't part of the out of the box OBIEE.

    You can filter columns in OBIEE, add a filter with the required values using the "is between" operator. Or turn the filter into (L)SQL and write the filter using functions or variables or a mix of both to make it dynamic day by day.

  • User_F6761
    User_F6761 Rank 2 - Community Beginner

    Hi

    I had tried to add filter on datetime column after extracting the time just hh:mm:ss than I used " is between" operator on the column.

    for values 5 pm between 11:59 pm getting the excepted results.

    But when I try to filter like 5 pm between 8:59 am, i don't get any results.

    pm to am is not working, i think next day data is not recognised.

    Thanks

  • Gianni Ceresa
    Gianni Ceresa Mod

    A day finish at midnight, it doesn't continue the day after (that's what "tomorrow" is for).

    Your filter must be on date AND time, not just time. Only on time a filter between 5pm and 8:59am makes no sense. At the best you could express it as between 5pm and midnight OR midnight and 8:59am, but this isn't what you said as it's on different days.

    You must use date AND time...

  • User_F6761
    User_F6761 Rank 2 - Community Beginner

    Thank You Gianni

    I will check on it again.