How to Display Max Value in a Control Linked to a Dataset

Q&A
, , ,
1

I have a column in a dataset that represents the period of a transaction in YYYYMM of type integer. I need the maximum value (which will be the most recent month) to display in the control. I’ve linked the control to this column in the dataset but so far I’ve only been able to declare a static value which causes the user to have to deselect and select the current period every time. Is there a way around this?

2

Hi @dspringer

Thanks for your question!

You can automate the process of selecting the most recent month by using a calculated field or parameter or filter in Amazon Quick Sight.

Example:

  • Create a calculated field in your dataset - maxOver({TransactionPeriod}, [ ], PRE_AGG) (Syntax may vary)
  • Create a parameter and Set the default value to the previous calculated field.
1 Like
3

Thank you for your response but I still need all the values of the dataset field to show when the user clicks on the control though. Other values correspond with other months and need to be available. Any ideas? In other words I need to display the most recent max value but all values must be selectable. Using your formula only displays the 1.

4

@Xclipse Please clarify if possible thank you.

5

Hi @dspringer

Can you please try with Quick Sight parameter and the default value to dynamically change and apply this with filters.

image
image606×710 25.9 KB

1 Like
6

Hi @dspringer,
It’s been awhile since we last heard from you. Did you have any additional questions regarding your initial topic?

If we do not hear back within the next 3 business days, I’ll go ahead and close out this topic.

Thank you!

7

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!