Fetch single data value from the field (@type) in the expression without "Group-By"

I am working on custom report and fetching all required fields from deliveries schema, but when i try to fetch value from one of the field but i'm not. Since it is a field which stores multiple values(open,clicks,opt-out etc) in the single field.

1) Is it possible to fetch count of single value (type = open) from the expression itself along with other fields?
2) If i used GROUP-BY with @14236791 only field without any other fields i can able to get the values, otherwise i can't get the result.

Can anyone help?