I am trying to create a stacked bar chart that shows a count of configuration items over a period of time that looks something like this:
From what I understand, this cannot be done with reporting tools and must be done with Performance Analytics.
I have created an Indicator Source with the facts table using a table extended from cmdb_ci, using standard calendar, valid for frequency as Monthly, with conditions based on owned by group and Created on This month
I have created an automated indicator using this indicator source with Unit of “#”, aggregate = count, additional condition of “Status is not Retired”
I have created a Breakdown source based on the CI type
I have created an automated Breakdown linked to the breakdown source and mapped to the automated indicator
I have created a Data collector job to collect historical with relative start 4 months ago linked to the automated indicator
When I execute the job, it runs without errors
When I check the Scoresheet, it shows what I assume is the expected data
I have created a widget to visualize the data as type “time series” on a column chart
But when I add the widget to a dashboard, it comes up blank
Can anyone tell where I went wrong in the configuration?
Hi @Lisa Conn ,
According to your requirement, you need to create a widget for every type mentioned to create the stacked bar chart. If you see your below widget configuration:
Which actually refers that, Breakdown type = Unmatched doo to you have not selected anything in the breakdown element.
So to resolve your requirement, main widget should contain breakdown by type with element = item1(Your first type). Rest of the configurations should be done as Widget Indicators and not separate widgets.
if my answer helped towards a resolution, please mark answer as correct.
Best regards
Anders
Hi @Lisa Conn ,
According to your requirement, you need to create a widget for every type mentioned to create the stacked bar chart. If you see your below widget configuration:
Which actually refers that, Breakdown type = Unmatched doo to you have not selected anything in the breakdown element.
So to resolve your requirement, main widget should contain breakdown by type with element = item1(Your first type). Rest of the configurations should be done as Widget Indicators and not separate widgets.
if my answer helped towards a resolution, please mark answer as correct.
Best regards
Anders
Hi @Lisa Conn1 ,
thank you so much for the information. According to ServiceNow docs:https://docs.servicenow.com/en-US/bundle/tokyo-customer-service-management/page/product/customer-com...
there should be an “mark as correct answer button” .isn’t that visible?
