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

[Ankit Balapure]

Hi @Ankur Bawiskar and @Saiganeshraja ,

So, is there any workaround for this issue?

Thanks,

Ankit

[Saiganeshraja]

If the string field has limited values then change it to choices but make sure you update the relevant maps as well for the same.

[Saiganeshraja]

else If you have PA license, create a Breakdown source based on the string field.

[Ankur Bawiskar]

@Ankit Balapure 

Not possible with String field.

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.