1 Reply Latest reply on May 18, 2016 9:21 AM by Alexis Jasinski

    Display measures IF below threshold in current month

    Alexis Jasinski

      Please see the workbook attached using 8.2. I am trying to create a view that displays only measures that trigger = 'warning' for the current month. For the measures that the results cause for a 'warning', I want to see all the past data points as well regardless if trigger ='warning' or trigger='no warning'

       

      I assume this calls for a max(date) calc but I haven't been able to figure it out. Help, please!!