I am scratching my head over the following questions for a couple of days and was wondering if anyone could please help me:
1- What should I do that when I click on a graph on a dashboard all or the other graphs that I am interested in or any other tables on the same dashboard changes?
For example, if I click on the closed part in the pie chart, the graph that shows time at the bottom of it, should show the number of tickets that have been closed for that particular time!
2- When the dashboard loads, users can see the number of tickets that are open as well as the ones that are closed, however, on the table although they can see both statuses, those are separate! Meaning, for example:
1- lists the number of closed tickets and below that
2- there is a row that lists the total number of closed tickets
3- shows the rows for open tickets and below that
4- there is a row at that shows the total count for this
I really appreciate your help!
Did you try to use Element Linking from your Pie Chart? If all the elements (table, other charts) have a status as filed, use the element linking from the Pie Chart. In the Design mode, from the Pie chart, choose Linking, create a link using status. Under dependencies, select the other reports elements you want to link so that when you select an area of the chart, the corresponding data can be displayed in the other report elements(tables and other charts).