Need help with Performance Analytics

[Lisa Conn]

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?

[AndersBGS]

Hi @Lisa Conn ,

jt looks like it’s your widget configuration. Your widget only shows nov and dec, where the scores in the widget matches your scores.

if you remove 6th month running sum, and ensures that widget show last 12 month, what do you then see as result?

if my answer helped towards a resolution, please mark answer as correct.

Best regards

Anders

[Lisa Conn]

Hi @AndersBGS 

Thank you for the quick response. I changed the Time series to 12m running SUM and changed the Period under the Date Settings tab to 1y and now the widget shows the months in the X axis, but the chart is still blank. The legend reads "Type = unmatched" so i wonder if the problem is in the breakdown configuration?

Any ideas?

Thanks!

[AndersBGS]

Hi @Lisa Conn ,

agree - if your type shows as unmatched then the breakdown is not configured properly. Go through the breakdown and breakdown source to review the configuration. Also ensure it’s the right type chosen, as type exist for several tables with different purpose.

if my answer helped towards a resolution, please mark answer as correct.

Best regards

Anders

[Lisa Conn]

Hi @AndersBGS 

Actually, I think the breakdown configuration is correct because the values are showing on the scoresheet. On the widget configuration, I selected a value for the Element and the chart showed data for that selected element. This is progress, but I was hoping that I could display all of the elements in stacked bars (like my example). Is this not possible? Do I need to made a separate widget for each element?

thanks!