Is it possible to display a single or multiple visuals based on the selected filter (year-month)?

Question & Answer
, , , , ,
1

Hi team,

Currently, I have a pivot table displaying three columns with three corresponding numbers. Additionally, there’s a filter for the YYYY-month (e.g., 2024-01, 2024-02), which is created by using the formula left(toString(datefield)),7) to manage the numbers.

Typically, selecting multiple YYYY-months would result in the numbers being added up in each column. However, I’ve received a request to prevent the numbers from being summed up. Instead, the request is to display the second visual when 2024-02 is selected and the third visual when 2024-03 is clicked.

Is there any way to achieve this? Any insights would be appreciated.

2

Hi @Tun-Yang_Chou ,

You can accomplish this with custom actions. With an action you can navigate to another tab in the dashboard based on the interaction in the pivot table. Actions are easy to set up and very useful in this scenario. See here and here for examples. There are also a number of videos if you search for Quicksight custom actions.

Hope that helps!

ws

1 Like