I have a field of type integer that represents YYYYMM for example 202404 meaning April 2024. I’ve created a parameter using this field but want the max value to display in the control as a default not a static default. Is there a way to do this? Because we use this field as a date, i need the most recent month to display when the report is opened by the user.
This will not work because the data type is integer in my dataset and i need to maintain that. Otherwise when i create the control it forces me to use the date picker. I need the control to link to my dataset but show the max value as the default. Is there a way to do this?
Hi @dspringer,
Since you’re using an integer for this, unfortunately there’s not really a work around for this as QuickSight would have no way or sorting through that integer field like it’s a date.
I believe that using a date field would be the only way to achieve this outcome.
Thank you!
1 Like
Hi @dspringer,
Since we haven’t heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new topic in the community and link this discussion for any relevant information that may be needed.
Thank you!