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?
Solved! Go to Solution.
I have checked derivation works well but i can only able to use above derivation for single field with grouping of values.
Actually i need to use the same derivation with other fields as well and without grouping of field.