1 Reply Latest reply on Jul 23, 2018 7:17 AM by raoul.tller

    Measure changing over time, using data (valid from - valid to)

    raoul.tller

      Hi,

       

      I currently have a blended measure that works with a valid from and valid to date:

      limit overview.png

       

      Currently in my graph it will SUM both of them and show that as measure:

      code.png

       

       

      I want the limit  measure to use the valid from and valid to date, so when I would select a date in the 1-1-2018 - 16-2-2018 range for abcd I want to see 500, but when I select a date after 17-2-2018 I want to see the 100.

       

      Currently I just extract the most actual limits using a filter on the data source:

      DATE([validto]) = #1-1-9999#

       

      But it would be nice to implement something as described above, any ideas?