Hi All,
I dont know if this is a reported bug, I cant find any references to it so heres a quick explanation.
Here is a really simple SQL - generates 8 rows all value 0 except row 7 which has value of 1.
SELECT to_char(trunc(sysdate - rownum),'DD/MM/YYYY') label
, nvl(decode(rownum,7,1,null),0) value
FROM dual
CONNECT BY LEVEL <= 8
Here is the resulting chart - the Y-Axis is repeating values? Only seems to occur with low integers where hardly any data
Y-Axis is set to Decimal, Decimal places 0
Anyone else encountered this or have a solution.
Many thanks in advance