New Breakdown by Location for Performance Analytics reports

Taras1
Tera Contributor

I have a task to filter data in all PA Incident reports of the responsive dashboard. The data must be separated by the condition in the Location field of the incident Table which contains "Ontario". So the data in the reports illustrate the performance only of these incidents. All the articles I have read recommend adding a breakdown source in Dashboard Properties (https://docs.servicenow.com/en-US/bundle/tokyo-now-intelligence/page/use/performance-analytics/conce...

 

I have added a NEW source breakdown to the dashboard where I have applied a filtered all the locations by the keyword "Ontario". Now I need to configure all the widgets and indicators to follow that breakdown source and this is where I have challenges. According to the article:

  • An indicator on the widget uses a breakdown that is based on the selected breakdown source. For formula indicators, all the contributing indicators in the formula must use a breakdown based on this source.

I cannot add a new Breakdown I have created to the indicators in the widgets as it is not in the list. Here is the example from editing "Number of open incidents" indicator:

Taras1_0-1674158626167.png

I am not if I have chosen the right approach to modify that dashboard, but would like to hear any thoughts and ideas. 

Thanks!

 

5 REPLIES 5

Tsura Andreeva
Mega Sage

what happens if you add location?

I experimented with the standard Location field from the Incident table. But the data in the reports are blank when I apply the breakdown

Taras1_1-1674162951627.png

 

Atanda Kehinde
Tera Contributor

Hi, 

The location table you have your breakdown must be related to the table in which your Indicator is based.  

Also, you need to map the Indicator and the breakdown on the breakdpwn mapping tab in the related list of your breakdown.

Once this is done, the breakdown will appear on the list.

Indicator and Location based on the same tables. I am using ootb Location field from Incident table in this case:

Taras1_0-1674162557036.png

I have added all the necessary indicators from the reports but it still does not reflect the relevant data