Report: how to group by a variable

[Catherine Morri]

Hello!   We have a report and have columns with service catalog variables.   We have a need to group by variables and cannot find a way to do this (variables do not appear in the group by drop down list).   Can anyone show me how to group by variables?

Thanks!

[shloke04]

Hi,

You can do a Reporting on the Variable Ownership table(sc_item_option_mtom) instead of Requested Item table and Group by "Parent item" with fields added to the Report to fetch the variable values as shown below:

In the screen shot above, Column "Question" refer to the Variable Name and the field "Value" refers to the the value contained in that variable for the item ordered.

Even you can group the Report based on Item also by dot walking in the Group column as "Parent Item-->Requested Item fields and then select Item and run your filter as shown below:

Hope this helps. Mark the answer as correct/helpful based on impact.

Regards,

Shloke

[Catherine Morri]

No this still isn't quite what I am looking for.   Our catalog item 'Change Management Service Request' has a variable 'Request Type'.   This is a variable and isn't a field on the RITM.

[Steven Parker]

Catherine,

Did you ever figure out how to do this?   I don't see a way to Group By a variable.   I noticed if you sort the variable column in the report from A to Z or Z to A and then try and do a Bar Chart (which initially is greyed out)...it will error out saying you can't group by that field.

[Netjunkie]

The above gentleman's information is correct.

The most important part is to search against the correct table.
In most cases the variables from your catalog item will be in the Request Item, this is why you can only see +Variable when viewing the Data of Table ( sc_req_item )


Thank you Schloke