Flex tables – “The Pen-Pen-Ultimate Value”
A Difficulty assertion: How to exclude months and months from the Flex Table card that are not still comprehensive so users really do not imagine the period above interval quantities are soft? A Resolution Assertion: This magic formula sauce will allow for a real 7 days in excess of 7 days or month around thirty day period comparison by excluding the present week or thirty day period that has not nonetheless concluded. Demo: Use a beast manner to dynamically restrict your facts to exclude the current 7 days or month from the Flex Desk card. Efficiently this will improve Penultimate Benefit to “Two months ago” and Final Worth to “Last week” instead of “Last week” and “Current week”. My “Secret Sauce”: Build a beast method named “Week Filter” or “Month Filter” with the next method. Be aware: WEEKOFYEAR() function can be substituted with Month() and `ACTIVITY_DATE` is your day info subject in your dataset. This will give the existing period of time a benefit of ‘0’ that you can then filter in your card to be “Not In” ‘0’. Your “Last Value” in your Flex table gets to be final week in its place of recent week and your “Penultimate Value” will become two months in the past. Be guaranteed to modify your column names to be clear in the Basic part of the Chart Qualities section of your card!
