Filter Default to Max Numeric Value

Q&A
, , ,
1

I have a table with a dropdown multiselect filter control for a numeric value. This control should hold all the numeric values of that field, but I want the default selection to be the maximum number from that field. How do I do this?

Field: Year

Example values: 2026, 2025, 2024, 2023, etc.

I want it to default to 2026, and the user can select others. When its 2027, i want it to default to 2027 and so forth.

2

Hi @C_B,

Hope everything is well! With how the native behavior for date filtering works, it is currently not possible to set a year default on a filter control. Although not an ideal solution, I would just recommend to update the date filter as each year passes for your use case.

Thank you and hope this helps!

3

Thanks! The field means a year, but it is a numeric value, and quicksight treats it as a numeric field. It could be 1-1,000,000, money, percentage, anything numeric. The max number could change at any time when the dataset is updated.

I want for the filter to default to the highest number in that field. Is there a way to do this?

But yes, this is all a rough workaround for filtering dates. The user is filtering by month and year. I had to make a field for year and month from a date field. We can’t use the native date filter on this date field because

  1. we want results for the whole month, and
  2. all the dates are the first of the month, so if the user doesn’t click on the first from the date picker, there are no results. It would be great if we could set the date granularity in a filter the same way we can in the visual formatting. Natively, quicksight let’s us truncate a date value to second, minute, hour, day, week, month, quarter, year. It would be great if the filter could do that too.