Hi there, I am creating a report with the targeting and filtering dimensions set to Delivery, aiming to obtain the counts of successful emails, opens, and clicks from indicators However, I specifically want to see the opens and clicks for data where the rec_create_date from another table is within t...

Hi @LakshmiPravallika , Thank you for looking into it. I found the issue; it appears there were duplicates causing the incorrect count. I have made the necessary changes in the deduplication activity, and it is now working fine.  

Hi @LakshmiPravallika , please find the below the conditions I am using and also checked the Generate compliment.  

Hi @Sukrity_Wadhwa , I was able to sort this out by using the below expression: <node expr="ToInteger((Percent([indicators/@estimatedRecipientOpen],[indicators/@successWithoutSeeds]))*1000)/10" alias="@OpenRate"/> <node expr="ToInteger((Percent([indicators/@recipientClick], [indicators/@estimated...

Hi there, I've observed that when using a split condition, 1308 records were initially sent into the split. After configuring multiple conditions within the split, including checking the "generate complement" option, I now receive 1303 records. Upon manual inspection, I tested the missing 5 records ...

Hi there,    I have several JavaScript activities that retrieve the total record count based on split conditions. Now, I've added another JavaScript activity to extract the segment code from the split activity. Additionally, I'm attempting to access the instance.vars variable within this new JavaScr...

Hi @vraghav , Thank you for looking in to this. I have a column named segment_code containing values like scen3_IS_DELETED, scen3_IS_EMAIL_OPT_IN, and scen4_IS_DELETED.My goal is to extract the substring before the first underscore and display it in one column. Additionally, I want to count the occu...

Hi there,  Is there a method to compare two columns (feature_purchased_date and email_sent_date) belonging to different tables? I want to retrieve records where feature_purchased_date from the "feature" table is greater than email_sent_date from the "recipient delivery logs" table.  Thank you in adv...

Hi there,  I'm currently working on creating a report that includes counts for various scenarios where data is incomplete or conditions are not met. I've managed to generate a report, but I'm aiming for a format similar to the screenshot below for the final version.   var fquery = xtk.queryDef.creat...

Hi there,  I have an enrichment activity that divides the feature column into 4 parts. Now, I need to calculate how many features purchased, knowing that a customer can purchase one or more features. I am implementing this using a JavaScript function. Please advise on how to accomplish this.vars.rec...