Can I have a breakdown that works on two tables?

veronica_malmo · ‎03-14-2017

I have a Breakdown dashboard with several Scores widgets, some on the incident tabel and some on the SLA incident tabel. But I can't get all the widgets to follow the same Breakdown, because there is one on Incident Company and one for SLA Incident Company, is there a way to merge these together, or is this the reason why all the OOTB Dashboards are divided between SLA and Incidents, and never put together..?

Arnoud Kooi · ‎03-15-2017

I wasnt aware you had different breakdown sources, but you are right, the dashboard breakdown uses the breakdown source.

But you can delete the Incident SLA Company breakdown source as well, if you have followed the steps I have mentioned.

If you compare them, the criteria of the 2 breakdown sources are exactly the same.

Are you on PA since the Eureka release?

The concept of breakdown mapping is introduced in Fuji, while upgrading it was converted 1 on 1,

so the breakdown mapping is not used to combine breakdowns.

View solution in original post

Arnoud Kooi · ‎03-14-2017

In your breakdown you can add a breakdown mapping, you only need one Company breakdown and can map it to all the tables.

Be aware that you will loose historic data for the involved breakdown, if you decide to merge your breakdowns.

veronica_malmo · ‎03-15-2017

Thanks, that is usefull on scorecards, but I'm trying to get it to work on a breakdown Dashboard by putting it on the top, to do that you define the Breakdown source and then I'm in trouble..

Arnoud Kooi · ‎03-15-2017

That should be covered, but it takes a few steps.

You would need to follow these steps:

Rename Incident Company to Company
Add the breakdownmapping from Incident SLA Company to the (renamed) Company breakdown.
Add the Company breakdown to all the Indicators that have Incident SLA Company breakdown
Update all references from Incident SLA Company to Company breakdown, for example widget breakdown field
Delete the Incident SLA Company breakdown
Do a historic data collection for the changed indicators

veronica_malmo · ‎03-15-2017

Not sure I'm following you here.

When I go and manage my Dashboard I have two Breakdown Sources there now, after renaming the Incident Company to just Company:

Breakdown Source

Breakdown:

The problem as I see it, is that when putting the breakdown on the top of the Dashboard, it use the Breakdown Source directly and not the Breakdown like it does on the scorecards, or am I totally off now?