Single Score Report Sum Aggregation

[saranravikumar1]

Hi All,

         I am trying to create a Single score of aggregation type sum on particular table I am not able to see all the fields

in that table Is there anything special needs to be enabled for field to be user in single score sum . 

Note : that field is having indexing also

Any thoughts. Much appreciate any help 

[Yashsvi]

Hi @saranravikumar1,

please check below link:

https://www.servicenow.com/community/performance-analytics-forum/calculating-total-sum-between-two-f...

Thank you, please make helpful if you accept the solution

[Sid_Takali]

Hi @saranravikumar1 

To create a Single Score widget with an aggregation type of "Sum" and ensure that all fields in the target table are available for selection, you might need to consider several factors:

Not all field types are eligible for aggregation operations like "Sum". Ensure the field you want to aggregate is of a

numeric type, such as:

• Integer
• Decimal
• Float

Check if there are any access control rules (ACLs) or other permissions set on the field that might restrict its visibility:

• Field-level ACLs: Ensure there are no ACLs that restrict the visibility or accessibility of the field.
• Table-level ACLs: Ensure you have the necessary permissions to view and use the fields of the table for aggregation.

Please mark my response Correct/Helpful 

Regards,

Sid