Hey guys, I am wondering if it is possible to make an advanced date picker like this on the dashboard. I want our users to be able to select today/yesterday/last week/1 week/1 month/3 months etc easily without manually going through 2 date selections each time. It slows down workflow. Often they want to change dates quickly during meetings
is this possible now? or something in the works? is there some workaround we can apply to make it possible?
Attaching images of how PowerBI does it for a sample
Hi. Thanks you for your question! Many of our community Experts and folks from our team are on holiday right now. I asked “My Assistant” (universal chat) in Quick Suite, and got this back. @Brett Could you review and validate the answer below on Monday after you return from holiday?
We’ve marked this question as a “feature request.”
From “My Assistant":
“Current Date Picker Capabilities
Quick Sight supports relative date filters with preset options including :
Today
Yesterday
Start of/End of this or previous time periods (year, quarter, month, week, day)
Last N days/weeks/months
How to Implement Quick Date Selection
You can set up quick date choices in two ways:
1. Using Rolling/Relative Date Filters
Create a filter with Filter type = “Date & time range”
Choose “Set a rolling date”
Select “Relative date” and pick from presets like Today, Yesterday, or specify conditions like “Start of this month” or “End of previous quarter”
2. Using Date Picker Controls
Quick Sight offers a date-picker control that allows users to choose dates from a calendar interface. You can customize the date format displayed in the control
Dashboard vs Analysis Parity
Dashboard filters should have full parity with analysis filters, meaning the relative date functionality works in both”
Another simple workaround is to add a calculated field in your SQL layer that converts common “relative date” choices (Today, Yesterday, Last Week, etc.) into actual date ranges.
CASE relative_date_choice
WHEN ‘TODAY’ THEN
CURRENT_DATE || ‘|’ || CURRENT_DATE
WHEN 'YESTERDAY' THEN
(CURRENT_DATE - 1) || '|' || (CURRENT_DATE - 1)
WHEN 'LAST_7_DAYS' THEN
(CURRENT_DATE - 7) || '|' || CURRENT_DATE
WHEN 'LAST_30_DAYS' THEN
(CURRENT_DATE - 30) || '|' || CURRENT_DATE
WHEN 'LAST_90_DAYS' THEN
(CURRENT_DATE - 90) || '|' || CURRENT_DATE
ELSE
NULL
Since we haven’t received any further updates from you, I’ll treat this inquiry as complete for now. If you have any additional questions, feel free to create a new post in the community and link this discussion for context.
Many of our community Experts and folks from our team are on holiday right now. I asked “My Assistant” (universal chat) in Quick Suite, and got this back.