I would like to create a dashboard report showing counts of incidents, tasks and requests in one bar graph, and when a column is selected drill down into data specific from that table.

[drew_plastridge]

I would like to create a dashboard report showing counts of incidents, tasks and requests in one bar graph, and when a column is selected drill down into data specific from that table.   I was able to do this using data sets, but its displaying the data oddly with extra empty bars.   I'd like to get rid of the extra empty bars.   Any suggestions?   See screenshot below...

I was able to get the graph to look the way I want to by just using the task table, with no data sets.   However, then when you drill down on the data you get the task fields which aren't relevant for all 3 task types.   For example, in incidents I want to see the caller, but for requests I want to see the Requested for field instead.

[Brian Lancaster]

Can you show us your report configuration?

[drew_plastridge]

Certainly, is this what you were looking for?

The main report:

One of the data sets:

[Brian Lancaster]

Prateek is correct you need to run the report off the task table.

[Prateek kumar]

Hello Drew

Can something like would be helpful for you?