How can i set the default value of a parameter to the maximum value available? (e.g. the default week is always the highest week available?)
Hi @Dmacca
as far as i know that is not possible.
BR
Hello @Dmacca , welcome to the Quicksight community!
Can you provide more detail on your use case or what you would like to achieve? When you say “highest week” do you mean most recent or current week or the oldest week in your dataset?
It has been a few days since we have heard from you but would still like to help find a solution. If we do not hear from you in 3 days this post will be archived.
Hello,
I mean the most recent week.
This parameter contains weeks from 1 to 52 and with data getting populated throughout the year. So if I am in week 40, this parameter will have values raging from 1 to 40. If I am in week 48, this parameter will have values raging from 1 to 48.
I want the default value of the parameter to be the most recent (if the week is expressed in date) or highest (if the week is expressed in integer) and this value need to change every weeks as the dataset gets updated.
thanks,
Davide
Hello @Dmacca !
Like @ErikG mentioned, that specifically can’t be applied to a date time parameter. That being said if the objective is to have the the values from sales from from week 1 to week 40, for example, you could use a calculated field such as periodToDateSum:
I will mark this as a feature request for the Quicksight team!