How to draw 'X axis' of chart by Hour (actual data is Min and value)

Question

I gurus,

I have a difficulty in drawing chart.

Below is sample data.

Hour     Minute     Value

-------     ----------     ---------

16          20          15

16          36          20

16          55          22

17          2           25

17          11         35

17          22          33

18          5          31

18          10          40

...

As you know, the records has 1440 (24Hour X 60Mins) and I would like to draw X axis chart only show 'Hour' not by Minute. Is it possible draw X axis based on Hour but chart value is minute?

How to modify data set or configure chart properties in OBIEE chart?

40  |                        *

|             *

30  |              *

|        *  *

20 |     *

| *

10  |

|                    *

------------------------------------------------------------------------>

16     17     18     19     20     21     22     23    (Hour)

RichardChan · Answer

How do you want the hours to be rounded i.e.

should 2 hours 45 minutes be in the 2 or 3 hour column

should 2 hours 15 minutes be in the 2 or 3 hour column

e.g.

CAST(FLOOR(<minute column>/60 ) AS VARCHAR(4)) will give you the lowest full hour, replacing with ceiling will give you the next full hour

truncate(121/60,0 ) will also give you the lowest hour

Richard Chan

Neodata Australia