Drill down to another dashboard filter not working
Drill down to another dashboard filter not working
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:
I then setup a second dashboard (although I've stripped it back now for testing purposes to be really simple as below):
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:
I have then set up the 2nd dashboard to have a filter that has the expression of this["Status"] which I believe is correct.
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
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:
I then setup a second dashboard (although I've stripped it back now for testing purposes to be really simple as below):
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:
I have then set up the 2nd dashboard to have a filter that has the expression of this["Status"] which I believe is correct.
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.
Re: Drill down to another dashboard filter not working
Hello Andrew,
Could you upload the images, looks like they were missed.
Thank you.
Could you upload the images, looks like they were missed.
Thank you.
Re: Drill down to another dashboard filter not working
Hi Andrew,
Sorry I hadn't spotted that. I've changed them now.
Thanks
Andrew
Sorry I hadn't spotted that. I've changed them now.
Thanks
Andrew
-
- Posts: 6365
- Joined: Tue Mar 20, 2018 5:34 am
Re: Drill down to another dashboard filter not working
Hello Andrew,
Please send us a sample report with test data that reproduces the issue for analysis.
Thank you.
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
Hi Lech,
Does the attached give you what you need?
Thanks
Andrew
Does the attached give you what you need?
Thanks
Andrew
Re: Drill down to another dashboard filter not working
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.
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
Hi,
You've sorted it, that's what it was, thanks for your help, much appreciated!
Thanks
Andrew
You've sorted it, that's what it was, thanks for your help, much appreciated!
Thanks
Andrew
-
- Posts: 6365
- Joined: Tue Mar 20, 2018 5:34 am
Re: Drill down to another dashboard filter not working
Hello Andrew,
You are welcome.
You are welcome.