Oracle Fusion AI Data Platform Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Fusion AI Data Platform Forum

Categories

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

Comparing two snapshot dates

Accepted answer
42
Views
2
Comments
JobDeLuna
JobDeLuna Rank 5 - Community Champion
edited Aug 13, 2024 7:41PM in Oracle Fusion AI Data Platform Forum

Hi,

I need help with Oracle Analytics to calculate the delta between two snapshot dates.

The next step is to figure out how to incorporate a parameter into the formula, so instead of hardcoding the date, we can use the parameter value between the two selected dates.

I would appreciate your assistance.

faw2.PNG faw.png


Thank you!

Tagged:

Best Answer

  • Raghavendra Raghunath-Oracle
    Raghavendra Raghunath-Oracle Mod
    Answer ✓

    Hi @JobDeLuna this requirement is possible with slight changes. You should use two date parameters to pass the two different dates instead of using a single column. I have worked out an example where the headcount is displayed for the two dates selected and also provides the delta between the two.

    Import the attached dv and test.

    Raghu

    Screenshot 2023-10-18 at 12.18.43 PM.png
    delta headcount.dva


Answers