Page 1 of 1

Drill down to another dashboard filter not working

Posted: Sat Jan 15, 2022 11:46 am
by AndrewF
Hi,

I've setup a new dashboard and using the video below I've tried to setup a drill down to another dashboard using a filter from data selected in the first dashboard.

https://www.youtube.com/watch?v=SxatnisIvHU

I have setup a dashboard which includes a chart that I want to drill down into another dashboard, the setup of the chart is as follows:
Dashboard-Setup-1.png
Dashboard-Setup-1.png (195.25 KiB) Viewed 1904 times
I then setup a second dashboard (although I've stripped it back now for testing purposes to be really simple as below):
Dashboard-Setup-2.png
Dashboard-Setup-2.png (116.24 KiB) Viewed 1904 times
From the main dashboard, I then linked to the second dashboard and setup a parameter for the Status to be available in the 2nd dashboard as below:
Dashboard-Setup-3.png
Dashboard-Setup-3.png (213.86 KiB) Viewed 1904 times
I have then set up the 2nd dashboard to have a filter that has the expression of this["Status"] which I believe is correct.
Dashboard-Setup-4.png
Dashboard-Setup-4.png (110.24 KiB) Viewed 1904 times
The issue is when I preview and click through from the main dashboard to drill down on the specific chart, the value on the second dashboard is just 0 when it should be whatever the value was on the bar chart that I clicked through from. I've done some research and other than an issue in an older version in 2019, I can't seem to find what I'm doing wrong. Any help would be appreciated.

I'm on version 2021.3.2 - although at the moment we are just doing some initial setup so are still trailing the software before we buy the licence (just in case that has any relevance as to why it's not working).

Thanks

Re: Drill down to another dashboard filter not working

Posted: Sat Jan 15, 2022 12:08 pm
by Andrew
Hello Andrew,

Could you upload the images, looks like they were missed.

Thank you.

Re: Drill down to another dashboard filter not working

Posted: Sat Jan 15, 2022 7:15 pm
by AndrewF
Hi Andrew,

Sorry I hadn't spotted that. I've changed them now.

Thanks
Andrew

Re: Drill down to another dashboard filter not working

Posted: Mon Jan 17, 2022 8:42 am
by Lech Kulikowski
Hello Andrew,

Please send us a sample report with test data that reproduces the issue for analysis.

Thank you.

Re: Drill down to another dashboard filter not working

Posted: Mon Jan 17, 2022 11:03 am
by AndrewF
Hi Lech,

Does the attached give you what you need?
TransactionOverviewCustomer.txt
(77.97 KiB) Downloaded 125 times
Thanks
Andrew

Re: Drill down to another dashboard filter not working

Posted: Mon Jan 17, 2022 1:40 pm
by HighAley
Hello,

In the Drill-down parameter you pass a Value that contains a number.
then you compare it with Status that is string.

Maybe you should use the Series in the Parameter?

Thank you.

Re: Drill down to another dashboard filter not working

Posted: Tue Jan 18, 2022 8:34 am
by AndrewF
Hi,

You've sorted it, that's what it was, thanks for your help, much appreciated!

Thanks
Andrew

Re: Drill down to another dashboard filter not working

Posted: Tue Jan 18, 2022 10:02 pm
by Lech Kulikowski
Hello Andrew,

You are welcome.