2 Replies Latest reply: Apr 25, 2016 4:00 PM by Randall Porter RSS

    Conditional Dimension

    Randall Porter

      Hello,

       

      I am working on building the following chart.

       

      Capture.PNG

       

      Everything is fine with this chart except that all the dates that don't have any data are showing as 0. I would like this graph to only show data for dates that have data. I update this chart on a Period basis, so there is no need to have all these excess dates that don't yet have data.

       

      Current Dimensions:

       

      Dimensions.PNG

       

      Current Measure:

       

      Measure.PNG

       

      Can anyone provide any insight on how I might do this?

       

      Thanks!

      Randall