Hey @ARAVINDA11
In Performance Analytics, you can create a percentage report showing how many records have a populated field versus total records.
For your example:
- Total AIX Server records = 1000
- Records where Field1 is empty = 1
- Records where Field1 is populated = 999
Percentage populated:
9991000×100=99.9%\frac{999}{1000} \times 100 = 99.9\%1000999×100=99.9%
(or 99% if rounded down)
Option 1: PA Formula Indicator (Recommended)
Create two indicators:
Indicator 1: Total AIX Server Records
Table: Your table
Aggregate: Count
Filter: Display Name = AIX Server
Indicator 2: Empty Field1 Records
Table: Your table
Aggregate: Count
Filter:
Display Name = AIX Server
Field1 is Empty
Then create a Formula Indicator:
((Total Records - Empty Field1 Records) / Total Records) * 100
This will return the completion percentage.
Option 2: Database View / Report
If you only need a report and not historical trending:
- Create a report on the table.
- Use Count aggregation.
- Group by Display Name.
- Add conditions for empty and non-empty values.
- Use a PA Formula Indicator or Scorecard to calculate:
(Non Empty Count / Total Count) * 100
Option 3: Breakdown by Display Name
If you have multiple display names such as:
Display Name | Total | Empty | Completion % |
AIX Server | 1000 | 1 | 99.9% |
Linux Server | 500 | 10 | 98% |
Windows Server | 200 | 0 | 100% |
Create:
- Indicator = Count Records
- Breakdown = Display Name
- Formula Indicator =
((Total Count - Empty Count) / Total Count) * 100
This will show the percentage for each server type automatically.
************************************************************************************************************************************
If this response helps, please mark it as Accept as Solution and Helpful.
Doing so helps others in the community and encourages me to keep contributing.
Regards
Vaishali Singh
Servicenow Developer
Linkedin - https://www.linkedin.com/in/vaishali-singh-2273361bb
