Group By string value in report on Metric Result Table

[rajmasurkar]

Hello,

I want to create a bar type report on Metric Result Table (asmt_metirc_result) and need to Group the data by String Value. However, I cannot find 'String Value' field in 'Group by' field on the report. Please refer below snapshot for reference.

Any suggestions?

Raj

[Brian Lancaster]

What field are you trying to group by?  Why would you want to group by a string field?  They are not consistent so you may get bad results.

[rajmasurkar]

Hi Brian,

'String Value'

I can add that field using '+' beside 'Group by' field, however; if I save the report the bar chart does not show 'String Value'.

Regards,

Raj  

[Brian Lancaster]

For me when I look at string value in a list layout it is majorly inconsistent with many different things.  They have something built in to prevent grouping by this field as your report would give you good information.  I cannot group by this field either.

[cnavr_work]

Hi Raj,

I encountered same issue :-).

you have to group by MetricDefinition.DisplayName

This should work

Ctirad