Create a flag dimension based on Group by of another dimension

[rohit_shoppertr]

Hi team,

We have two columns Column1 and Column2 , We need to count column1 and apply group by on Column2 . If count result is greater or equal than 3, then set flag = 1 other wise 0. This flag will be new dimension. We are trying to do it at backend not on front end. 

Column1	Column2	Flag	Logic
3034032f4405f28019ed9f13	wEypp3W	1	if (count(Column1) group by Column2)>3, 1 0)
3034032f4405f28019ed9fd2	wEypp3W	1	if (count(Column1) group by Column2)>3, 1 0)
3034032f4405f28019ed9fd3	wEypp3W	1	if (count(Column1) group by Column2)>3, 1 0)
3034032f4405f28019ed9fd4	n9Wxxm2	0
3034032f4405f28019ed9fd6	n9Wxxm2	0
3034032f4405f28019ed9fd1	K789wX	0
3034032f4405f28019ed9fd7	J2dggXr	0
3034032f4405f28019ed9fd8	75Ckg4A	0