5 Replies Latest reply: Mar 13, 2013 3:31 PM by Howard (... in Training) RSS

    How do I deal with zero values in apex charts?

    bostonmacosx
      So I have a dynamic query where the chart is based on sums as usual
      SELECT NULL LINK,OPG,sum(decode(METHOD_TAKEN,' By Web Form','1',0))" By Web Form",
      sum(decode(METHOD_TAKEN,' In Person','1',0))" In Person",
      sum(decode(METHOD_TAKEN,'-------','1',0))"-------",
      sum(decode(METHOD_TAKEN,'By 3rd Party Person','1',0))"By 3rd Party Person",
      sum(decode(METHOD_TAKEN,'By 3rd Party Personweissj','1',0))"By 3rd Party Personweissj",
      sum(decode(METHOD_TAKEN,'By Contact Person','1',0))"By Contact Person",
      sum(decode(METHOD_TAKEN,'By E-Mail','1',0))"By E-Mail",
      sum(decode(METHOD_TAKEN,'By HelpDesk','1',0))"By HelpDesk",
      sum(decode(METHOD_TAKEN,'By Telephone','1',0))"By Telephone",
      sum(decode(METHOD_TAKEN,'By Web Form','1',0))"By Web Form",
      sum(decode(METHOD_TAKEN,'By Webform','1',0))"By Webform",
      sum(decode(METHOD_TAKEN,'In Person','1',0))"In Person",
      sum(decode(METHOD_TAKEN,'Walk-In','1',0))"Walk-In",
      sum(decode(METHOD_TAKEN,'actiIn Person','1',0))"actiIn Person",
      sum(decode(METHOD_TAKEN,'email','1',0))"email",
      sum(decode(METHOD_TAKEN,'networkBy Web Form','1',0))"networkBy Web Form",
      sum(decode(METHOD_TAKEN,'walk in','1',0))"walk in",
      sum(decode(METHOD_TAKEN,'walkin','1',0))"walkin",
      sum(decode(METHOD_TAKEN,'','1',0))"empty",
       from 
      (
      SELECT NULL LINK,to_char(open_time,'YYYY-MM') DATIME,METHOD_TAKEN,OPEN_GROUP OPG FROM SMINCREQ WHERE open_time between to_date('01-DEC-2012','DD-MON-YYYY') and to_date('01-FEB-2013','DD-MON-YYYY') 
      
      UNION ALL 
      
      SELECT NULL LINK,to_char(open_time,'YYYY-MM') DATIME,METHOD_TAKEN,PRIMARY_ASSIGNMENT_GROUP OPG FROM SMINTERACTIONS WHERE open_time between to_date('01-DEC-2012','DD-MON-YYYY') and to_date('01-FEB-2013','DD-MON-YYYY')
      
       )  where METHOD_TAKEN is not NULL and OPG like '%TC%' GROUP BY(OPG) ORDER BY OPG ASC