Use a parameter as a calendar or x axis for dates fields

User_RS68A

Hello,

I am new in Oracle DV and Im practicing one exercise from oracle website. I want to use simplify my 2 graphes in 1 by using the parameter that i have created for Years to filter the two graphes. ( see attached screenshot). How can i do that ? Im trying to put the parameter Year on x axis but ODV does not allow me to do that.

Thanks for helping

Regards

Federico Venturin

Hi @User_RS68A ,

You can either:

• Create an expression filter on each visualization such as YourYearColumn = @parameter("Year")(2015)
• or, create a dashboard filter for YourYearColumn and bind it your parameter (this option is available only on OAC)

User_RS68A

• @Federico Venturin Thanks for you answer. However I dont understand what you mean here --> "Create an expression filter on each visualization such as YourYearColumn = @parameter("Year")(2015)"  How can i group the 2 graphes on one x date axis by doing that ? Do you have any kind of tutorial please ?

Gianni Ceresa

You have a data modelling issue for that...

You have 2 different dates, but want them to behave like they were the same date (that's how a single chart with a single time X axis could work).

If you have a time dimension that you connect once to your order date and once to your ship date, you can display amount of sales orders and amount of sales shipped next to each other, and also have the delta between the two.

User_RS68A

@Gianni Ceresa I dont have time dimension unfortunately. Any other solutions ? regards