3 Replies Latest reply on Oct 30, 2017 12:15 PM by Matt Schutz

    Filter dates without affecting % difference table calc

    Matt Schutz

      I have a simple line chart with data Jan-Dec.  The measure is a table calc % difference over previous value.  When viewing ALL data, there is no value for January, and I get it - there's nothing in the previous month to compute a % difference from.  However, if I filter the data to July-Dec I would like for July to have a value because June does exist in the data, it's just not shown.  Is there any way to force the visualization to show the % difference value for the first month of the visualization if the data truly exists like this?

       

      I've created two sheets in the attached file.  One "makes sense", the other "does not" as I've explained above.

       

      Thanks!