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 show results within the past 30 days

Received Response
153
Views
4
Comments
JHaden3
JHaden3 Rank 3 - Community Apprentice
edited Aug 13, 2024 5:20PM in Oracle Analytics Cloud and Server

I'm  new to OTBI.  I have an analyses where I want to return data for all employees termed within the past 30 days.  I want it show terminations 30 days ago, 29 day ago, 28 days ago down to 1 day ago.  How can I apply a filter or formula that will do this?  The field is "Worker"."Termination Date".

Answers

  • Jerry Casey
    Jerry Casey Rank 6 - Analytics Lead

    You could make a column using TIMESTAMPDIFF(SQL_TSI_DAY,"Worker"."Termination Date",CURRENT_DATE).  This will create a "Days Ago" column for termination date.

  • JHaden3
    JHaden3 Rank 3 - Community Apprentice

    Good idea and thank you!  However, that returned only the date of the termination instead of a day count.

  • Jerry Casey
    Jerry Casey Rank 6 - Analytics Lead

    If functioning correctly, that function would just return the number of days between each term. date and the current date.

    Something's amiss.

  • JHaden3
    JHaden3 Rank 3 - Community Apprentice

    Thank you, I got it to work.