OAC - Visualization change/toggle between Yearly and Monthly graphs

Question

Hii Community,Hope you're doing well.

In oracle analytics canvas ,we have two datasets :1)Yearly_dataset :having revenue values,sales values in  yearwise manner  2)Monthly_dataset :having revenue values,sales values in montwise manner .Using these we have created two different charts on a canvas of Yearly Revenue and Monthly revenue . But we want to create just one chart with the option to choose/toggle Yearly or Monthly on it.Pls advise how to do this .

Thank you in advance.

Wayne Van Sluys · Answer

You could also use the following to switch views

https://www.youtube.com/watch?v=0ibczIOKKOY

Jamie Anderson-Oracle · Answer

Can you potentially leverage Parameter functionality for this?

Since you have two separate datasets, you may need to take this a step further by joining the datasets initially.

https://www.youtube.com/watch?v=Wz-kI3tvm2E