Flex tables – “The Pen-Pen-Ultimate Value”

A Trouble statement: How to exclude months and months from the Flex Desk card that are not but total so buyers don’t believe the time period over period quantities are soft?

A Resolution Assertion: This top secret sauce permits for a legitimate 7 days more than 7 days or thirty day period over thirty day period comparison by excluding the existing week or thirty day period that has not yet concluded.

Demo: Use a beast method to dynamically restrict your facts to exclude the present-day 7 days or month from the Flex Desk card.  Proficiently this will modify Penultimate Value to “Two months ago” and Final Benefit to “Last week” as an alternative of “Last week” and “Current week”.

My “Secret Sauce”: Make a beast method named “Week Filter” or “Month Filter” with the adhering to method.

Take note: WEEKOFYEAR() functionality can be substituted with Month() and `ACTIVITY_DATE` is your date information industry in your dataset.

This will give the present-day time period a worth of ‘0’ that you can then filter in your card to be “Not In” ‘0’. Your “Last Value” in your Flex desk turns into past 7 days in its place of existing 7 days and your “Penultimate Value” gets to be two weeks in the past. Be sure to adjust your column names to be obvious in the Basic segment of the Chart Qualities segment of your card!