Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm trying to count how many emails with a number in the username are, and display it in a KPI.
I tried with this
count({1<email ={"$(= purgechar(email,'0123456789')"}>)}email)
but it's not working.
You might want to create a flag in script to make this easier.
if(email = purgechar(email,'0123456789'),1,0) as EmailNum,
Then the expression becomes:
count({1<EmailNum = {1}>)}email)
or may be this
Count({1<email = {"=Len(KeepChar(Only({1} email), '0123456789')) > 0"}>} email)