Can't groupby Value in metrics View

[giuseppem]

I All

I have problem with database view and data visualization.

In CSM I create ad databaseviews OOTB incident_metrics. 

Database view work fine. I can use query view and select as Data Source in Data Visualization or report, but I can't GroupBy on Value field. Field isn' t available

In PDI I can group by "Value"

In Customer instance Value is missing

Regards 

[J Siva · Accepted solution]

Hi @giuseppem 
Try adding the ‘Can group’ attribute to that particular field dictionary record.

Steps:

1. Navigate to System Definition > Dictionary and access the record name you wish to edit
2. Open the record and click on Advanced View under Related Links.
3. In the Attributes field, add 'can_group=true' as the value of the Attributes field (without quotes) and save.

Ref artcile: https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0634531

Regards,
Siva

[giuseppem]

Many thanks J Siva. 

[J Siva]

@giuseppem Glad it helped.