Avatar

Level 1

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 @TyPe only field without any other fields i can able to get the values, otherwise i can't get the result.

Can anyone help?

 

DeepankumarD_0-1627981696424.png

 

DeepankumarD_1-1627981768246.png