Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

The 4th edition of the Campaign Community Lens newsletter is out now!
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!

2 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