Multiple questions related to same chat:
vCurrentMonth = Month(Date(Today()))
I have a dashboard with Key metircs and a common Fiscal Calendar selection for all the graphs.
I have a Pivot Table that shows Role and FiscalMonthYear as Dimensions.
There is an expression that shows The numeric value of the difference of FTE Capacity and Demand.
I want the chart to ALWAYS show the next 6 months. For example, it should now show the data from Oct-March. Do I edit the time dimension expression? If so, to what?
Lastly, I have a user requirement that there be a User Input an option for the user to have the option to select either all Roles or only those that have less than -1 FTE Variance in any of the next 6 months. No idea where to start with this one.
Any help would be appricated!