When create a report string_value is only available as an "Additional group by" not in "Group by"

[Tina24]

We have created a database view to joins table asmt_assessment_instance and asmt_metric_result.

So in database view , we set some different columns of "string_value".

When create a report for it, why "string_value" is only available as an "Additional group by" not in "Group by"?

Is it something we can correct/change?

We need set the "string_value" in "Group by" as default. Thanks!

[Community Alums · Accepted solution]

Hi @Tina24 ,

In ServiceNow reports, the availability of fields for grouping (Group By) and additional grouping (Additional Group By) depends on the data type and the way the tables are structured in the database view.

The "Group By" - is typically available for fields that are considered aggregate or numerical in nature, such as numbers, dates, and references to other tables.
The "Additional Group By" - is often provided for fields that are considered non-aggregate, such as strings or text fields.

If the "string_value" field in your database view is only available as an "Additional Group By", it suggests that ServiceNow recognizes this field as a non-aggregate field, possibly due to its data type or the way it's configured in the database view. To change this behaviour and make "string_value" available for regular grouping (Group By), you may need to adjust the configuration of the database view or the field itself. 

If my response proves useful, please indicate its helpfulness by selecting "Accept as Solution" and " Helpful."