Card Analyzer - Date Filter Options

buzz_boom · 2022-09-01T13:44:47+00:00

There was an error rendering this rich post.

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.

Find more posts tagged with

In Review

Status: In Review

Comments

ST_Superman

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

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

Maybe an "include / exclude current_date" option.

kkestler

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.