Hi -
We're continuing our pre-purchase evaluation using more real-world scenarios. We've connected our test SQL database and created a dashboard with a donut chart and some filters. The donut chart has a count indicator enabled. When we filter the chart however, the indicator value drops to "0" and never comes back unless "reset filters" is performed.
I tested the same on a different dashboard that is using an uploaded CSV rather than a SQL connection and filtering works fine both in the chart and the indicator, so it seems it has something to do with it being connected to SQL versus a stored dataset.
Donut Chart Indicator going to "0" after filter
-
- Posts: 6358
- Joined: Tue Mar 20, 2018 5:34 am
Re: Donut Chart Indicator going to "0" after filter
Hello,
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: Donut Chart Indicator going to "0" after filter
Thanks Lech. If I send you the report with embedded data, it will work fine. When I run the same on my end with Excel as the data source, the issue doesn't occur. Only with SQL. I wouldn't be able to effectively send that to you with the live connection due to firewall rules. If you'd like to see the behavior live, I am happy to demonstrate it and walk you through the build over a call / screenshare. Or if you have a SQL connection you can use for testing on your end, the build in the screenshot is simply a donut chart against a count of items with filter slicers (which cause the behavior). The SQL table contains 24,998 items in total. Thanks.
-
- Posts: 6358
- Joined: Tue Mar 20, 2018 5:34 am
Re: Donut Chart Indicator going to "0" after filter
Hello,
Could you send scripts for creating table and inserting several test rows?
Thank you.
Could you send scripts for creating table and inserting several test rows?
Thank you.
Re: Donut Chart Indicator going to "0" after filter
Thanks Lech - this turned out to be an error on my part in the query string. Sorry for your trouble!
-
- Posts: 6358
- Joined: Tue Mar 20, 2018 5:34 am
Re: Donut Chart Indicator going to "0" after filter
Hello,
Thank you for the information.
Thank you for the information.