Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I attempting to count how many people clicked on a particular link more than once. Currently, I have data that shows if they did or did not click the link (yes and no).
I am able to count the total number of people that has greater than 1 clicks, but not able to count just the people that clicked yes? Here is what I have for a total count of clicks greater than 1.
Count({<email={"=Count(Clicklink)>=2"} >} distinct email)
I have tried multiple combinations of adding Clicklink = 'Yes', but have not had any luck. The only way I am able to do it is buy using a filter, which will not work in this situation.
Any help would be greatly appreciated.
May be this
Count({<email = {"=Count({<Clicklink = {'Yes'}>} Clicklink) >= 2"}>} DISTINCT email)
May be this
Count({<email = {"=Count({<Clicklink = {'Yes'}>} Clicklink) >= 2"}>} DISTINCT email)
Worked like a charm! Thank you very much!