Drill down to another dashboard filter not working

Stimulsoft Dashboards.WEB discussion
Post Reply
AndrewF
Posts: 6
Joined: Sat Jan 15, 2022 11:29 am

Drill down to another dashboard filter not working

Post 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 1475 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 1475 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 1475 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 1475 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
Last edited by AndrewF on Sat Jan 15, 2022 7:21 pm, edited 2 times in total.
Andrew
Posts: 4104
Joined: Fri Jun 09, 2006 3:58 am

Re: Drill down to another dashboard filter not working

Post by Andrew »

Hello Andrew,

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

Thank you.
AndrewF
Posts: 6
Joined: Sat Jan 15, 2022 11:29 am

Re: Drill down to another dashboard filter not working

Post by AndrewF »

Hi Andrew,

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

Thanks
Andrew
Lech Kulikowski
Posts: 6197
Joined: Tue Mar 20, 2018 5:34 am

Re: Drill down to another dashboard filter not working

Post by Lech Kulikowski »

Hello Andrew,

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

Thank you.
AndrewF
Posts: 6
Joined: Sat Jan 15, 2022 11:29 am

Re: Drill down to another dashboard filter not working

Post by AndrewF »

Hi Lech,

Does the attached give you what you need?
TransactionOverviewCustomer.txt
(77.97 KiB) Downloaded 117 times
Thanks
Andrew
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: Drill down to another dashboard filter not working

Post 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.
AndrewF
Posts: 6
Joined: Sat Jan 15, 2022 11:29 am

Re: Drill down to another dashboard filter not working

Post by AndrewF »

Hi,

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

Thanks
Andrew
Lech Kulikowski
Posts: 6197
Joined: Tue Mar 20, 2018 5:34 am

Re: Drill down to another dashboard filter not working

Post by Lech Kulikowski »

Hello Andrew,

You are welcome.
Post Reply