How to make breakdown count to percentage

[konijetisumanth]

Hi Community 

I have a requirement where i need to show a report, automated ci's and manual CIs in CMDB.

we depend on Discovery source.

so created the indicator with discovery sources and classes.

created a breakdown with discovery source and now when i run my report i could see only count of ci with respective discovery sources, but ineed to show them in %.

example: -if i have 50 ci,s then it should show as 100 %

     breakdown should show the % of diff discovery sources.

note:- i have taken all automated indicators, breakdown

[Tai Vu]

Hi @konijetisumanth 

Let's try the below configuration.

Enjoy the result. Sample below

In the other hand, you can define Formula Indicator to calculate the percentage specifically.

Let me know if it works for you.

Cheers,

Tai Vu

[konijetisumanth]

Thanks you so much for wonderful solution 

But i have one issue whre i have only data for ServiceNow, intune, import set but i getting 0 count also getting displayes can you tell to how to restrict not show if the count of discovery source is 0

[Tai Vu]

Hi @konijetisumanth 

From your Indicator, just leave this field Value when nil as blank. Then will be empty instead of 0.

Value when nil
The value that is inserted as the score when no value is collected. This value is inserted whether or not breakdowns are applied.
This value is not used to calculate formulas or aggregates, such as an average.

Also make sure the below checkbox is unchecked in the PA Widget.

Cheers,

Tai Vu

[Tai Vu]

Hi @konijetisumanth 

Please mark my comment as solution so it may help other people having the same concern. 🤙

Cheers,

Tai Vu