QuickSight Change Time Aggregate Automatically for User

Essentially what I am trying to do is the following. I want to have a list that gives the user the option to look at particular time aggregates by Month, Day, Year, Hour, Minute.

As you can see we have the option when we click on the bottom arrow and we can change the aggregate. At the moment it is by Day. But how would I do this dynamically in which the user could select they want Month, Day, Year, Hour, or Minute?

Hello @Morgan_Weiss - Thank you for posting your query. Based on your problem statment, I believe there’s an existing article on the same topic. Please go throgh this article post and you should get the implementation roadmap on how to go about this. Please let me know if this helps! Thank you!

hi @Morgan_Weiss,

you may use trancDate() in calc field to switch the aggregation depending on the choice you provide, which you create as parameter. The example of the dashboard is [here]
https://democentral.learnquicksight.online/#Dashboard-TipsAndTricks-Calculation-Switch-Date-Aggregation

Let us know if this is resolved. And if it is, please help the community by marking his answer as a “Solution.”