AnsweredAssumed Answered

Fill in a chart with a zero (0) value if a record does not exist for every date

Question asked by DSKatSCL on Jul 15, 2014
Latest reply on Feb 18, 2016 by DSKatSCL

Title

Fill in a chart with a zero (0) value if a record does not exist for every date

Post

     I have a table that has a date of an event, type of event (up to 100+ different types) , and summary count of each event type. On a chart I need to have every day since the first of the year shown across the X axis, and the count of events on the Y axis. This is not a big issue, however, I DON'T have a record for each date for each type of event and I need to chart a zero value for each event type if there is no corresponding record for that event type.

     Without creating a script to add records for each date and event type that would have a zero value, is there a way t fill in the dates on a chart so that it would show every date (YTD) and a zero value if there is no related record with a count?  So I need to show Jan 1, 2014 - July 14, 2014 on each chart.  See the result I currently have in the attached screen shot.

     Thanks!

Zero_for_every_Date.png

Outcomes