I have created a chart that shows the number of tickets opened by an individual for a period of time. I have created a hierarchy from the individual to include the ticket no., and used this hierarchy in my chart.
What I want to be able to do is drill down into my chart, and see a table listing the ticket numbers, and ideally the status of each ticket (status is a known field).
My chart looks like this;
The vertical axis is ticket count. When I drill down on a column I want to be able to list the tickets and their status in a table like ths;
Can you do this kind of drill down from one view to another?
If you click on the Drill tab on the top, you should be able to see a button named "See Records". This would show you an overview of the data you want to see. But i'm not sure if it's working with this type of visual - give it a shot :-)
Thanks david2. I am not sure if I did quite what you meant, but I right clicked on the chart and chose 'See Data' that shows me the data for that chart. Not what I wanted, but now I think that I am trying to do this the wrong way.
I think another way of expressing what I want is this;
When you drill down on a column, I want a new view(table) filtered by that column. The new table shows different data.
Put a table below your graph that has the fields you want to show and categorize it by your x-axis. When you then click on one of the columns in the graph, your table will filter to show only those records linked to that column.