Card Analyzer - Date Filter Options

buzz_boom
buzz_boom Contributor
edited December 2023 in Analyzer Ideas

When building charts, especially trend charts or period over period charts it would be helpful if we had the option to include the "Current" day. It is not a fair comparison (even for WKTD) looks if the current day is a partial day and the last week to day was a complete day. If the option for last completed day or penultimate day was available that would help build charts without needing a beast mode calculation.

7
7 votes

Active · Last Updated

Comments

  • I agree, this makes some of the date ranges on cards appear confusing. For example, to show the last "7 days" of sales data, we make a card titled "Sales: Last 7 Days" but have to select the date range for last 8 days and then write a filter that removes the current day. Calling out Last 7 Days in the title and then having the user see the date range on the card is set to "Last 8 Days" is confusing.


    “There is a superhero in all of us, we just need the courage to put on the cape.” -Superman
  • Agreed. It's also possible for a data consumer to come to an incorrect conclusion by changing the date range on a card from, say, "Month to Date" to "Last 7 Days" without knowing that the current day is one of the seven.

  • Maybe an "include / exclude current_date" option.

    Jae Wilson
    Check out my 🎥 Domo Training YouTube Channel 👨‍💻

    **Say "Thanks" by clicking the ❤️ in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"