Hi,
Using Oracle 12c, APEX 5.0.2, ORDS 3.0.2.
I need to display the values of the q column on a curve (2D Line Chart) so that when I hover the mouse at a point (i.e. marker) on the curve, the value is displayed. I will have 3 series with data similar to the example shown below:
WITH dat AS
( SELECT 0 y , 0 x , 0 q FROM dual
UNION
SELECT 1 y , 1.1 x , 0 q FROM dual
UNION
SELECT 2 y , 2 x , 1 q FROM dual
UNION
SELECT 3 y , 2.3 x , 0 q FROM dual
UNION
SELECT 3.5 y , 2.5 x , 0 q FROM dual
UNION
SELECT 3.9 y , 3 x , 2 q FROM dual
UNION
SELECT 4 y , 4 x , 0 q FROM dual
UNION
SELECT 4.1 y , 5 x , 0 q FROM dual
UNION
SELECT 4.2 y , 7 x , 0 q FROM dual
UNION
SELECT 5 y , 8 x , 0 q FROM dual
)
SELECT *
FROM dat
;
I need the values of the y column displayed on the Y-Axis, x on the X-Axis and q on the markers on the curve.
I can plot the chart by doing: SELECT null link, x value, y value ... but I don't know how to make to display q.
Could anyone please advise how this can be achieved?
Thanks in advance
- H