For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
Hi all, My name is Mayank. I am a newbie when it comes to oracle apex. Kindly forgive me if this is a silly question. But, I am trying to create a time chart in apex, that has the date on x-axis and time on y-axis. I am able to create an interactive report for the same. But whenever i am trying to create a line chart, the graph shows no data found error. i have already tried enabling the time axis type, and the format of x and y axis is also in date and time format. I tried using the format mask for x axis and y axis. And I also tried using the sql query instead of selecting the table . Still the chart shows no data found. One more thing that I noticed is that when I am trying to create the chart directly using the create page>charts>line chart option. On selecting the table, the select value column remains blank and doesn't get auto-populated. I am not sure what am I doing wrong. Please find below the sample data, table schema, and the GUI error. Thanks, in advance. Apex version- 20.2 Table name - M Table schema: Sample Data: The error/issue in creating graph via the GUI( the value column drop down is empty): Graph error: