Single Score Report Sum Aggregation

saranravikumar1
Tera Contributor

‎07-02-2024 12:28 AM - edited ‎07-02-2024 12:56 AM

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 

saranravikumar1_0-1719905224759.png

 

0 Helpfuls
  • 352 Views
2 REPLIES 2

Yashsvi
Kilo Sage

‎07-02-2024 01:22 AM

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

0 Helpfuls

Sid_Takali
Kilo Patron
Kilo Patron

‎07-02-2024 01:24 AM

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

0 Helpfuls