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
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

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

DeepankumarD
Level 1
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
anishs2303
Correct answer by
Level 2
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
anishs2303
Correct answer by
Level 2
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

DeepankumarD
Level 1
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