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

Question

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

User_RS68A · Answer

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

Gianni Ceresa · Answer

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 · Answer

* @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 ?