Hey everyone,
I have 2 dashboards: one with a summary of transactions and the other with transaction details.
I’ve set up a URL action on visualization to show the total transactions by transaction type and period. When a user clicks on specific data points like the month and type of transaction, the URL action should trigger and open a new table with those filters in the detail report.
I’ve already created parameters for date and transaction type in the detail report, but when the trend is shown at the month level, the URL takes the first date of the month and passes it as the filter value. I am required to apply the filter for the selected month in the detailed report.
I need assistance with this. Can anyone help me out?
URL :https://us-west-2.quicksight.aws.amazon.com/sn/dashboards/#p.ActivityType=<<activity_type>>&p.Start=<<activity_date>>&p.End=<<Activity_date>>
Generated URL :
https://us-west-2.quicksight.aws.amazon.com/sn/dashboards/#p.ActivityType=Accrual&p.Start=2022-01-01T00%3A00%3A00.000Z&p.End=2022-01-01T00%3A00%3A00.000Z
Detail report filters based on parameters.
Summary Report visualization with Action.