Thanks, but I need this for AC classic, and RowNum & PartitionBy don't work in Classsic

Trying to build a report table show Opens / Clicks using something similar to the recipient delivery log 'RowId'  Have built workflow using BroadLog, TrackingLog & Recipient tables, and complimentary data: RowId(GetDate([delivery/broadLogRcp/eventDate])).... but this generates the RowId of the Broad...

That works, thank you!

Hi i want to build a query on people who have opened more than 30% of deliveries sent. I tried this expression: Percent(Countdistinct([trackingLog/@id]), Countdistinct([broadLog/@id])) greater than 0.3But it's not working, can anyone help? Thanks

I have sent an email in waves, and instead of sending 10% every 10 minutes its sending 10 emails every 10 minutes... this is a problem as their is over 25k emails to send. Is there a way to force delivery all deliveries? Or do I have to cancel the delivery and send to those not delivered? Thanks