Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, everyone.
I have this table view :
The contents from status field on 20180612 table are Email Sent, Email Opened, Clicked Link, Submitted Data.
I need to make a join table with fields are : Date, CountofEmailSent, CountofEmailOpened, CountofClickedLink, and CountofSubmittedData
with the example of expression from CountofClickedLink = sum of Clicked Link + sum of Submitted Data from status field on original table.
How can I do that ?
Thank you
-Kevin
Hi Kevin,
Your issue is not clear by the statement : with the example of expression from CountofClickedLink = sum of Clicked Link + sum of Submitted Data from status field on original table.
It is better if you can attach a sample qvw.
HTH
sushil
Here I attach the simulation of the datas.
-Kevin
Hi Kevin ,
Can you provide your expected result?
Best Regards,
Ashok
Here's the table what I expected :