i originally set the date filter as “Relative Dates”, but my end user sometimes would specify date range in this filter. Then the setup would link to normal “Date and Range” filter type which has an default setup “Include end date” unchecked. So i checked it under “Date and Range” type and save the filter, but this setup will not work if i switch filter type between “Relative Dates” and “Date and Range” as an end user. so they get an wrong summary without the record of the end date.
How can i keep “Include end date” checked?
Hi @fanniew - I believe we need to highlight this to QuickSight team so that the end date should be checked by default like the start date. I am tagging some experts who can analyze this and if it needs QS product team attention, they will raise a request.
The end date unchecked is currently an option and you include it if required, the other way around would to be exclude the start date ( Adding date filters - Amazon QuickSight ) .
I tested the filter switch by enabling ( Include end date ) in the analysis > click apply > publish the dashboard .
The values for a month based on Relative dates or using Date & time range remained the same.
i think i figure out what happen to my issue. i selected wrong granularity when I set “include end date”.
i got the correct summary after correct granularity to Day.
