Need report to display %of Control compliance count on Y-axis.

[HamantT]

Hello,

Check screenshot for my report that I am trying to create, could you please help me with displaying Control count Percentage on Y-axis. Currently I can only show Control count on Y-axis.

Percentage count= Control compliance count/ Total Control.

[M Iftikhar]

Hi @HamantT ,

To display the % of Control Compliance on the Y-axis, you’ll need to use a formula field instead of the raw control count. Create a formula like:

(Control Compliance Count / Total Control Count) * 100

and then set this formula as the Y-axis value in your report configuration. This will ensure the chart reflects percentages instead of absolute counts.

Thanks & Regards,
Muhammad Iftikhar
If my response helped, please mark it as the accepted solution so others can benefit as well.

[HamantT]

Thanks for the response @M Iftikhar , can you please tell which formula field you are referring to? I am not using PA.

[M Iftikhar]

Since you’re not using PA, there isn’t a direct “formula field” option in standard reporting. A common workaround is to create a calculated field on the table (via Dictionary → Calculated Value) that stores:

(Control Compliance Count / Total Control Count) * 100

You can then use this field in your report to display the percentage on the Y-axis.

[Bhuvan]

@HamantT 

Follow steps I explained in below article for creating formula indicators,

https://www.servicenow.com/community/platform-analytics-forum/how-to-obtain-the-number-of-computers-...

Create two automated indicators, one to track total control and another for control compliance count. Create a formula indicator to calculate % Count

Add the indicator to dashboard and share it with users/groups.

If this helped to guide you or answer your query, please mark it helpful & accept the solution. 

Thanks,

Bhuvan