Help -- Temporary Work Table Limit by Percent of Total

Avatar

Avatar
Boost 1
Level 1
wpomeroy
Level 1

Like

1 like

Total Posts

18 posts

Correct reply

0 solutions
Top badges earned
Boost 1
Validate 1
View profile

Avatar
Boost 1
Level 1
wpomeroy
Level 1

Like

1 like

Total Posts

18 posts

Correct reply

0 solutions
Top badges earned
Boost 1
Validate 1
View profile
wpomeroy
Level 1

28-08-2020

I have a workflow that is grouped by a numeric indicator (Sponsor External ID) and zip code.  I then count the customers by zip code and display in relation to the total customers associated with the indicator.  My next step, which is tripping me up, is that i'm trying to sort descending by count of customers (count of CONTACT_ID) and then calculate a rolling percentage so that any zip codes that fall after 85% of the total are removed (i.e. i'm trying to capture the zip codes that have the most customers and make up 85% of the base).  Is there a way to do achieve this within the workflow?

 

Hopefully my explanation is clear.  If not please let me know and i'll provide additional info.

wpomeroy_0-1598665167576.png

 

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Contributor
MVP
Milan_Vucetic
MVP

Likes

166 likes

Total Posts

386 posts

Correct reply

135 solutions
Top badges earned
Contributor
Springboard
Shape 1
Validate 25
Validate 10
View profile

Avatar
Contributor
MVP
Milan_Vucetic
MVP

Likes

166 likes

Total Posts

386 posts

Correct reply

135 solutions
Top badges earned
Contributor
Springboard
Shape 1
Validate 25
Validate 10
View profile
Milan_Vucetic
MVP

31-08-2020

Hi @wpomeroy

if understood correctly, you may add one Enrichment node after node (you provided screenshoot) and calculate percent with following formula:
(count of CONTACT_ID * 100) / total_base_count - to get percentage per Zip code

Finaly, add one Split node and query percent column (percent which are above 85).

Regards,
Milan

Answers (2)

Answers (2)

Avatar

Avatar
Validate 1
Level 2
SheetalAgrawalSoni
Level 2

Like

1 like

Total Posts

22 posts

Correct reply

2 solutions
Top badges earned
Validate 1
Give Back 3
Give Back
Boost 1
Affirm 1
View profile

Avatar
Validate 1
Level 2
SheetalAgrawalSoni
Level 2

Like

1 like

Total Posts

22 posts

Correct reply

2 solutions
Top badges earned
Validate 1
Give Back 3
Give Back
Boost 1
Affirm 1
View profile
SheetalAgrawalSoni
Level 2

09-09-2020

I am looking at your problem. I need your data in excel file form. I am not able to under stand on the image ,so could you send me excel file.

Avatar

Avatar
Give Back 50
Employee
Sukrity_Wadhwa
Employee

Likes

168 likes

Total Posts

928 posts

Correct reply

35 solutions
Top badges earned
Give Back 50
Validate 1000
Validate 500
Validate 250
Validate 100
View profile

Avatar
Give Back 50
Employee
Sukrity_Wadhwa
Employee

Likes

168 likes

Total Posts

928 posts

Correct reply

35 solutions
Top badges earned
Give Back 50
Validate 1000
Validate 500
Validate 250
Validate 100
View profile
Sukrity_Wadhwa
Employee

09-09-2020

Hi @wpomeroy,

Were you able to resolve this query with the given solution? Do let us know.

Thanks!