2 Replies Latest reply on Jul 20, 2016 12:44 AM by Tim Lang

    Creating a comparison to a previous time period

    Tim Lang

      I am creating a dashboard that shows the last three months of activity, and shows the same three months last year via a reference line:

      This works fine by using LOOKUP() and applying a bit of a hack on the date filter, however when I try to apply a dimension to the chart in order to colour the bars according to whether the month exceeded target, the previous year reference line disappears for one of the months:

      What am I doing wrong!?

       

      Many thanks