2 Replies Latest reply: Apr 28, 2016 12:04 AM by Lee Maverick RSS

    Charts showing missing data (with test qvw)

    Lee Maverick

      Hi Community,

       

      I am now doing a dashboard that shows the actual, plan and forecast data. Users are required to select a Year and a Quarter. The bar chart will then present the figures of:

      1. Prior Year Actual

      2. Current Year Actual till the Quarter being selected

      3. Current Year Forecast after the Quarter being selected

      4.Current Year Plan for the Quarter being selected

       

       

      I have encountered a problem when there is missing records from the data source, the corresponding bars will also be missing. What I want is showing 0 by leaving a vacant space for those missing data. How can I achieve this?

       

      Expected Result:

      Capture1.JPG

      Result With Missing Data:

      Capture2.JPG

      Thanks,

      Maverick