CODEWITHSUNDEEP
oracle-apexapex-codeapexcharts
Orabeco
Orabeco

Reputation: 13

Hour:Minute format on an APEX chart is not possible

I use Oracle APEX (v22.1) and on a page I created a (line) chart, but I have the following problem for the visualization of the graphic:

On the y-axis it is not possible to show the values in the format 'hh:mi' and I need a help for this.

Details for the axis:

So I have the following SQL query for the visualization of the series:

SELECT DISTINCT to_char(time2, 'YYYY-MM') AS YEAR_MONTH --x-axis, 
AVG(time2 - time1) AS AVERAGE_VALUE --y-axis
FROM users
GROUP BY to_char(time2, 'YYYY-MM')
ORDER BY to_char(time2, 'YYYY-MM')

I have another problem to solve it in another way: I am not familiar with JavaScript, if the solution is only possible in this way. Because I started new with APEX, but I have seen in different tutorials that you can use JS. So, when JS is the only solution, I would be happy to get a short description what I must do on the page. (I don't know if this point is important for this case: The values time1 and time2 are updated daily.)

So where is my mistake or is it more difficult to solve this?

Upvotes: 0

Views: 724

Answers (1)

ardai
ardai

Reputation: 58

ROUND(TRUNC(avg(time2 - time1)/60) + mod(avg(time2 - time1),60)/100, 2) AS Y

will get close to what you want, you can set Y Axis minimum 0 maximum 24

then 12.23 means 12 hour and 23 minutes.

Upvotes: 0

Related Questions