Comparing two snapshot dates

Question

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.

Thank you!

Raghavendra Raghunath-Oracle · Accepted 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

delta headcount.dva