A Drawback assertion: The right way to exclude weeks and months from the Flex Desk card that aren’t but full so customers don’t suppose the interval over interval numbers are mushy? A Answer Assertion: This secret sauce permits for a real week over week or month over month comparability by excluding the present week or month that hasn’t but accomplished. Demo: Use a beast mode to dynamically restrict your knowledge to exclude the present week or month from the Flex Desk card. Successfully this can change Penultimate Worth to “Two weeks in the past” and Final Worth to “Final week” as a substitute of “Final week” and “Present week”. My “Secret Sauce”: Create a beast mode named “Week Filter” or “Month Filter” with the next formulation. NOTE: WEEKOFYEAR() operate might be substituted with MONTH() and `ACTIVITY_DATE` is your date knowledge area in your dataset. This can give the present interval a worth of ‘0’ which you can then filter in your card to be “Not In” ‘0’. Your “Final Worth” in your Flex desk turns into final week as a substitute of present week and your “Penultimate Worth” turns into two weeks in the past. Make sure you change your column names to be clear within the Normal part of the Chart Properties part of your card!
