HI I have a requirement for a dashboard to show closed incidents + closed tasks in one dashboard by assigned group/assigned to broken down by month. I am able to get the query to include past 12 months but can it be broken down according to month? Also is there a way to report on both tasks and incidents within the same dashboard?
I did create a dashboard with 12 months. I do not know how to break it by month.
You can use the Drill-Down method to create a dashboard drilldown, Put the Months in a table column and in total sum, put that in the graph.You can define a report drilldown to enable reporting users to view subsets of the report data. When you define a report drilldown, it applies only to the report for which you define it. Procedure
The user can drill down from the top-level report to the specified drilldown report visualizations. Can follow the link - ServiceNow Docs