5 Replies Latest reply: Oct 1, 2014 3:55 PM by Cassandra Baqir RSS

    Display Future Months

    Cassandra Baqir

      I am building a dashboard that shows a straight table of roles with a negative FTE Variance. I have two dimensions: MonthYear and Role. FTE Variance is an expression that looks at the total of hours of resource capacity/possible working hours minue the total of hours allocated/possible working hours.

       

      It only shows records where the FTE Variance is less than 1 by using the Dimension Limits->Show only values that are Less Than -1 exact amount.

       

      I want this table to only show the records in the future months (to allow the user to identify resource gaps). I was trying to get it to show by using Dimension Limits->Show only values that are Greater than today() on the MonthYear field, but it isn't working.

       

      Help!