Can't see "hardware_os_version" field in Stack by option in the report.

[Ankit Balapure]

I'm trying to create a report on the 'ip_firewall' table and want to group the data by the 'manufacturer' field. Additionally, I would like to use 'hardware_os_version' in the Stack by option, but I’m unable to find this field there.

Do you know how I can locate or configure it to appear in the Stack by option?

The highlighted field is of string type.

In the below screenshot see the highlighted options the field which I want is missing.

Thanks,

Ankit Balapure

[Saiganeshraja]

"Stackby" is not available for the string fields. That's you are not able to find that field. 

Another Example of String Field is "Name".

Mark correct and helpful.

[Saiganeshraja]

If you are looking for : "Why I can't you stack by string field"-- String fields have too many unique values,making it ineffecient for grouping.

[Ankur Bawiskar]

@Ankit Balapure 

Stack by works on fields which store definite values such as Choice etc

not available for string field, date/time, integer, list fields

Unable to add certain additional group by fields in 'Stacked by' list in reports 

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Ankur Bawiskar]

@Ankit Balapure 

Thank you for marking my response as helpful.

If my response helped please mark it correct and close the thread so that it benefits future readers.