Expand my Community achievements bar.

SOLVED

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

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

 

1 Accepted Solution

Avatar

Correct answer by
Level 2

Hi Deepan,

 

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

 

anishs2303_0-1627988638350.png

Thanks!

View solution in original post

3 Replies

Avatar

Correct answer by
Level 2

Hi Deepan,

 

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

 

anishs2303_0-1627988638350.png

Thanks!

Avatar

Level 1

  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