percent calculation

Avatar

Avatar
Validate 1
Level 1
michaelr8873103
Level 1

Likes

3 likes

Total Posts

5 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
View profile

Avatar
Validate 1
Level 1
michaelr8873103
Level 1

Likes

3 likes

Total Posts

5 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
View profile
michaelr8873103
Level 1

05-12-2019

Hi i want to build a query on people who have opened more than 30% of deliveries sent.

I tried this expression:

Percent(Countdistinct([trackingLog/@id]), Countdistinct([broadLog/@id])) greater than 0.3

But it's not working, can anyone help?

Thanks

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Boost 50
MVP
Jyoti_Y
MVP

Likes

89 likes

Total Posts

123 posts

Correct reply

55 solutions
Top badges earned
Boost 50
Shape 1
Boost 5
Give Back 5
Give Back 3
View profile

Avatar
Boost 50
MVP
Jyoti_Y
MVP

Likes

89 likes

Total Posts

123 posts

Correct reply

55 solutions
Top badges earned
Boost 50
Shape 1
Boost 5
Give Back 5
Give Back 3
View profile
Jyoti_Y
MVP

06-12-2019

Hi,

You need to design a workflow which will fetch data from BroadLogRcp and TrackingLogRcp table.

1) Design query on broadLogRcp with delivery id greater than one and delivery status equal to sent. Then perform Group by on recipient Id and have one column to get count of those recipient id.

2)  Design query on trackingLogRcp with delivery id greater than one and email open equal to yes. Then perform Group by on recipient Id and have one column to get count of those recipient id.

3) Perform intersection on both the queries using recipient id as identification parameter. You will get both recipients who has received mail and their open rate.

4) Now use your formula: Percent(Count of tracking log recipient Id/Count of broad log recipient id) greater than 0.3

Thanks.

Answers (1)

Answers (1)

Avatar

Avatar
Validate 1
Level 1
michaelr8873103
Level 1

Likes

3 likes

Total Posts

5 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
View profile

Avatar
Validate 1
Level 1
michaelr8873103
Level 1

Likes

3 likes

Total Posts

5 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
View profile
michaelr8873103
Level 1

06-12-2019

That works, thank you!