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.