Hi @MariBa ,Use it like this:Change eventDate with your custom date. 

Hi @rvnth ,You have to get it from Recipient Delivery logs table. Group by on the basis of Recipient ID and count the primary keys of delivery logs to get the no. of emails (status = sent) per recipient. It has link with recipients to use any other fields from linked recipient schema.You have to per...

Hi @MariBa ,Its working for me. Use function WeekDay(@Date) equal to 0, alongwith the date range you want to select.

Hi @Khanerat You can try this.For the past 7 days deliveries, create a link with Delivery table itself on Delivery Label. In the link properties pick the deliveries created before 7 days. In the next split you can check if the linked Delivery exists. If it isn't, (complement) that will give you deli...

Hi @bcollado ,Check the below option in second split, and it will concatenate the value of second segment code with first. You can add any separator too in your segment code. 

Hi @bcollado , you can group by on any field, and you can do it in the initial Query itself. Just check the "Group" option in the output column. If needed add another field where you can add an expression to perform any function (Sum,Count, etc) on any other field/id.You need to check below in Addit...

Hi @ayushhtiwari , yes you can.Use Replace(<string>, "'", " ")

Hi @PawanGu , you can use this function too, works for Concatenating multiple string values. CONCAT(<string1>,'<separator>',<string2>)

@ElenaMo In case of a single delivery you can only do this for a Filtering Typology rule.In the filter you can select the Targeting Dimension, and add different condition for Brand A and B. Use negative condition "not equal to", so the filtering rule will be applicable to other Brand. Or you can als...

Hi @ElenaMo ,You can add multiple Typology rules in the Typology, and add Nature or delivery code for specific brands in your Delivery. Then you can add application conditions (based on Nature or delivery code) in each rule for specific Brands.