Oracle Analytics and AI

Shripad Nadiger

Summary

Need help with calculations

Content

Hi Everyone,

I have just started using Oracle DVD and stuck on a couple of things.

1. How do i calculate last year date using the 'Date column' in the data. I could generally use something like Lookup([column_name],-12) in tableau which would give me data related to last year current month. I have not found the same functionality on DVD.

2. Also, how do you convert the data type. My date column is showing up in 'string' format and in need to change it in 'Date' format.

3. I need to understand if there are any ways i can create parameters or variables in DVD. for example.I have a scenario where i am trying to compare data related two different dates..something like sales current year Vs Sales Last year. How can i accomplish this on Oracle DVD.

Thanks and Regards,

Shripad

[Deleted User]

No not really but since you don't seem to understand my point and correct it, allow me. (​ this is the solution for your second point)

So imagine you have an Excel source with dates as text:

And now let's try to change the type at import:

So now we have this:

Let's run this:

Well oups. Back to the drawing board.

Let's try what Syed said:

Hmm nope

Let's try the other one:

$

Hmm nope.

Ok so let's read the documentation for a second: https://docs.oracle.com/middleware/bidv1221/desktop/DVDRN/GUID-3EC72AE5-A979-4E2D-AF43-BCC11828C0D7.htm#GUID-3EC72AE5-A9…

See it already?

Let's add to the Excel sheet and follow the doc:

Note that I leave it as text!

Now let's try the conversion function again:

Oh neat:

hey wait that means we may even do this at Import:

Result:

So no conversion function needed.

tl;dr - your dates must be in a PRECISE format. Just wanted to spell things out.