10 Replies Latest reply on Dec 19, 2016 5:20 PM by Eliza James

    How to stop a line in a graph where there is a running total

    Eliza James

      Hi,

       

      The below graph is showing bed nights with last year, this year and the target.  To show a cumulative view, I've used the quick table calculation "running total".

       

      There is no discrete or continuous option on the measure values and I need the blue "This Year" line to stop when before December (as there's no data yet).

       

      If you know how, your help would be appreciated!

       

      Thanks.