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.

13
Up
13 votes

In Review · Last Updated

Thanks for sharing your idea! We're currently reviewing it for future enhancements. Stay tuned for updates! 👍

Comments

  • ST_Superman
    ST_Superman Domo Employee

    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.

  • MichelleH
    MichelleH Coach

    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.

  • jaeW_at_Onyx
    jaeW_at_Onyx Coach

    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"
  • kkestler
    kkestler Member
    edited April 24

    Would love it if the options in the Date range selector were all calculated relative to the most recent date in the chosen Date range field.

    Screenshot 2025-04-24 at 3.34.50 PM.png

Categories