Report on variable values with group by value

[Biddaum]

I have a variable set that is being used to identify specific streams of work for a number of catalog items.

I have been able to create a report that will display the value of the variables in the variable set for example in a list view. However in order display the total number of requests for each stream I need to find a way to collate the values and display those totals for each value type.

The values are all for a single select box question, with the exact same set of values each time it is ansered.

EG:

What stream is selected?

- Stream 1

- Stream 2

- Stream 3

- Stream 4

I then want to show the total number in a single report where each stream total is shown, eg a pie graph

I thought it would be as easy as group by value, but it isn't an option.

I have tried this on a number of tables without success:

sc_item_option_mtom

sc_item_option

item_option_new

sc_task

sc_req_item

[Biddaum]

@Tanushree Maiti whilst that information is helpful, it still doesn't allow me to "group by" the value, which is the ultimate goal here.

[Tanushree Maiti]

Hi @Biddaum 

Check this article:

Add custom choices in "Max number of groups"

https://www.servicenow.com/community/platform-analytics-forum/in-a-pie-chart-report-how-to-group-sec...