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.

[drew_plastridge]

Thanks, I've built a similar report.   The issue with that method, is drilling down into the report will give you the task fields, not the ones specific to that task type. For example, for incidents I want to see the caller, but for requests I want to see the Requested for field instead.

[Kishor kumar]

Hi Drew,

Your requirement is not possible on the servicenow reports.

It is possible in service portal high chart, Because we have to create new chart.

If you want this requirement just do it in service portal and map the url where ever you want.

Thanks,

Kishor

[Kishor kumar1]

Hi drew,

This is not possible in service now reports, But it's possible in service portal custom reports.

If you want this requirement create a custom HIGHCHART in new widget and page, and map the result-en url where ever you want.

Thanks,

Kishor