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

[DeepankumarD]

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?

[anishs2303 · Accepted solution]

Hi Deepan,

Please see the screenshot below to know how we derive this information.

Thanks!

[DeepankumarD]

Hi,

Thanks for the update, will check

[DeepankumarD]

  Hi,

  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.

 Thanks