1 Reply Latest reply: Dec 4, 2012 1:45 PM by mayilvahanan ramasamy RSS

    How to show all months on chart, even for months without data

      Customer wants a chart with all 12 months of the fiscal year, even if one or more months does not have data for the selections.

      In the attached example, March is not shown because no data exists for March in the two fiscal years displayed in the chart. 

       

       

      I'm not sure if this can be handled within the chart, or something needs to happen in scripting / data load to ensure data values at each possible selection.  I'm looking for your suggestions and examples. 

       

      In the attached example, month is about the only selection criteria, but eventually three or four selection criteria will be used.

       

      Thank you,

      Steve