how is your bar chart populated?
if it ´s with a sql Querrie then just add a Where ":P_ITEM_VALUE IS NOT NULL.
Thanks for getting back to me, well I know I can remove them from sql but I put the zeros in the sql so the time axis can generate the chart properly. I want to know if it is an option in the chart that some how it doesn't render the bars that have value of zero@
when asking Question about Chart, you should give more details about what Version of APEX do you use, Do you use Oracle JEt chart or Anychart?
That Question help us to help you.
I think you can still have your data points without having zeroes, with a NULLIF
with dts as (select dt, name from ( select trunc(date '2018-03-31')-rownum+1 dt from dual connect by level <= 31) cross join (select distinct name from jet_demo)) select d.dt dy ,nullif(count(s.rowid),0) c ,to_char(d.dt,'DD Mon') dt_fmt ,d.name from jet_demo s right outer join dts d on d.dt = trunc(s.dt) and d.name = s.name where d.dt >= date '2018-03-01' group by d.dt ,d.name order by d.dt
From my dilemma here
Thank Alli, I am using APEX 5.1 and Jet Chart.
The specific patch level has relevant here