Date filter controls based on max and min date in dataset

Question & Answer
, , ,
1

Hi :slight_smile:
I was wondering if there is a way of setting default values for a date between filters based on MAX and MIN values in the DATE dataset column.
Date is the column containing the date of my data in the format YYYY/MM/DD

Thanks a lot in advance :smiley:
Michael

2

Hey Michael!
What do you mean by setting default values?
If you are trying to create a date filter to apply onto your visualization here is how you can achieve it:

  1. Click on your visual
  2. Click on the filter icon
  3. Click on the +ADD
  4. Select your Date column
  5. Define the filter by defining
  • Filter type
  • Condition
  • Time granularity
  • Start date
  • End date

In case you need help in how to define such settings please visit the official documentation page available at this link Adding date filters - Amazon QuickSight

I hope this helps :slight_smile:

3

Hey @mzerilli :smiley: thanks for the answer!

What I’m trying to achieve is that I have a column of dates:

date
2023/08/01
2023/08/02
2023/08/03
…
2023/09/15

I want the filter to take as default: Start and End dates automatically based on the max and min of this column.
So when I load the board (not modified) what I get is automatically the full range
(In my example above default start date = 2023/08/01, default end date = 2023/09/15)

Thanks :smiley:

4

Hey Michael!

Thanks for the clarification!
In order to have the full range of dates comprehended in your date column you should not apply any filters to the date variable.

Quicksight’s default behavior is display all the available data, which in your case would be all the dates comprehended in your date column, from start to end. Isn’t this your case?

I should have mentioned that it is important that the Date variable is set with type date (you can understand it from the analysis section by checking the calendar icon next to your variable name)
image
Quicksight allows you to sort, aggregate and modify the format of variables of type date in order to visualize your data in your preferred way.

Please let me know if this helped you or if you have further concerns.

Thanks :slight_smile:

5

Hi :slight_smile:
Yes but I want to have the filter so that whoever is looking at the table can change the range of dates shown on the board, but by default have them all. That is why I want to create a filter.

Michael

6

Oh I see!

Unfortunately changing the parameters of this control (start and end date) in the Analysis section does not allow to have default values.

What you could do is to publish this analysis as a dashboard, making sure to expand the Advanced publish options and tick the Enable ad hoc filtering as in the picture below
image

In this way changing the values of start and end date will only temporarily affect the visuals and by refreshing the page you can get back the default values set in the filter definition of the analysis.

I hope this helps :slight_smile:

7

Hi @michaeldessena,
It’s been awhile since we last heard from you. Did you have any additional questions regarding your initial topic or was the solution provided above help with what you needed?

If we do not hear back within the next 3 business days, I’ll go ahead and mark the solution.

Thank you!

8

Hi @Brett,
It’s not exactly what I was looking for. I’m looking for a method to set all filters to the maximum and minimum values based on the data. For example, if I have a column salary similar to:

salary
1000
1200
800
1250
1500
2100

And I want to create a slider. I cannot set the slider limits to the minimum and maximum values (in this case, 800 and 2100). The only thing I can do is manually investigate the maximum and minimum values and add them as limits for the slider.

If I understood correctly, this feature is currently missing in QuickSight.

Thanks,
Michael

9

Hi @michaeldessena,
Yes, unfortunately this is currently a limitation with QuickSight. I agree that being able to set filters based on calculated fields would be a nice addition so I’ll mark this as a feature request for the QuickSight team to view!

1 Like