This is a migrated thread and some comments may be shown as answers.

Drill Down graph is unusable when drilled down

2 Answers 10 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Matthew
Top achievements
Rank 1
Matthew asked on 24 Feb 2017, 06:29 PM

I have made a bar graph that drills down to graphs with many labels.

A picture of the graph is attached.

 

As you can see, the main categories don't fit when drilled down. Also, the subcategories' labels are too long and there doesn't seem to be a way to make them multiline.

This is really a make or break for us as this graph represents pretty much the whole reason we put together this tool in the first place.

Is there anything we can do to format the graph properly? 

 

As a workaround, is there a way to detect which bar on a graph is clicked and load another report based on the "value" associated with that particular bar?

 

Thanks.

2 Answers, 1 is accepted

Sort by
0
Matthew
Top achievements
Rank 1
answered on 24 Feb 2017, 06:56 PM

I have managed to make the graph more presentable by increasing the rotation and changing the layout to landscape. However one problem remains.

 

When drilled down, the main "categories" (the ones along the bottom of the graph with the +/- signs) are squished. In our particular case, we don't need to see the other bars when drilled down. Is there a way to drill down and view only the data in a given "category". For example, using the attached picture, is there a way to click the "+" next to "Plant" and have all of the others ("process, people, etc) disappear until we click on the "-" sign?

 

Thanks.

0
Katia
Telerik team
answered on 27 Feb 2017, 04:05 PM
Hi Matthew,

You can create a  showing the child categories on the chart and use it as a  report that is opened when clicking on the Graph's categories in the main report. 
Check Drillthrough Report Action help article for more detailed information.

When you set a report link on a report item, set a value for the parameter of the target report as well. When the user clicks the link in the summary report, the target detail report opens and displays the information for that specific value.

This approach is demonstrated in the attached report. It can be opened with Standalone Designer R1 2017.

I hope this will help.


Regards,
Katia
Telerik by Progress
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Tags
General Discussions
Asked by
Matthew
Top achievements
Rank 1
Answers by
Matthew
Top achievements
Rank 1
Katia
Telerik team
Share this question
or