Redirect from pivot table to another analysis with filter applied

Q&A
, , , , , ,
1

Hi everyone,

I’m working with a pivot table in Amazon QuickSight and wondering if the following is possible:

Is there a way to make a cell in the pivot table clickable, such that when a user clicks on a product (or any dimension), it redirects them to a different analysis — and automatically applies a filter based on the selected product from the first analysis?

In other words, I’d like to create a drillthrough or link action that takes users to another analysis/dashboard and dynamically filters by the value they clicked on.

Has anyone implemented something like this or knows if it’s supported?

Thanks in advance!

2

Hello Uripablo,

I think its possible , please refer old post here specially the video - Download Granular Data - Action Filter to link Aggregated Pivot Table with Detail Tables

Hope this helps.

cheers,
Deep

3

Hi @uripablo,
It’s been awhile since we last heard from you on this thread, did you have any additional questions regarding your post or were you able to find a work around?

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

Thank you

4

Hi @Brett ,

Unfortunately, I haven’t been able to filter while navigating to another analysis with a single click. I would appreciate any further advice.

Thank you very much!!

5

Hi @uripablo,

If you’re looking to accomplish this from a standpoint of embedding dashboards, take a look at this post that handles a similar request:

If you’re looking to utilize links to other dashboards within QuickSight (so your users can jump from one dashboard to another within the system); you’ll most likely need to add a field to your dataset that contains links to the other dashboards (and if you want to set a parameter, you can include the parameter value in your address):

Then you can add that field to your table so that users can click on the respective links.

Let me know if one of these options could help in your case or if you have any additional questions

6

Hello!

Since I could not achieve the filter and naviagtion action at the same time from one analysis to other, I ended up doing it in the same analysis but from one sheet to another. In this link it is explained how to do it in the 4th exercise. Workshop Studio

Thanks!