Want to create %usage report based on field value

Community Alums · ‎06-02-2024

Dear Community,

I have some field containing the number values like and I want to make %age report based on the number field values, for example in Linux Server record I have field called Ram and I want to calculate the total usage in %age, need your help with this.

Please let me know if you need any more information on this.

Dr Atul G- LNG · ‎06-03-2024

Hi @Community Alums

If I understood, to get %age we need 2 figures like total and the respective one. from here we can get the 234 but what is base value to get %age. Also it is not that straight forward in standard reporting. You can check the function in Reports but i again doubtful.

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

Community Alums · ‎06-03-2024

Hi Atul,

Thanks for your valuable response, consider base value to something let say 1000, and I have four type of server let say Server 1, 2, 3, 4. I want to to make report on the %age usage of these four type of server in a line chart..

Thanks,
Shivam.

Community Alums · ‎06-03-2024

Hi Atul,

Thankyou for your valuable response, for the base value let say it is 1000 and I have for servers 1,2,3,4 containing different RAM value.. I want to make a line chart showing %age usage of different Servers.

Please let me know if you need any more information.

Thanks,
Shivam.