Oracle Analytics Cloud and Server

Products Banner

Chart count orders Create date vs Closed date in the same chart - ODV Oracle Data Visualization

Received Response


I have been able to create the information only in 2 different chart one to Counting Creation date and other to Close date


I need to create one chart with the information of how many orders have been created vs how many was closed in one month. and would be perfect to have a third line with the gap on every month (the diference of every line).

Im able to do that only in to different charts, there is no option to make the count on those 2 option at the same chart (image attached).

This need to be a new feature or some one have a solution?


Screen Shot 2018-10-03 at 06.25.06.png



  • RichardChan
    RichardChan ✭✭✭✭

    Have you tried creating a calculated field in the criteria with the difference between the two dates, you should then be able to plot this measure



  • I do not know how I could create this with the difference between this two dates? unfortunately i have been able to have count considering the open and close month of the same Graphic. How I could create the criteria and make the count one considering the  column of create and the other close?