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...

Hi there,I tried using the script below in the JS activity, but I encountered the error: 'it is not contained in either aggregate function or GROUP BY clause.' I am now attempting to use a subquery and will update you on the progress. Please can you let me know if it can be achievable without using ...

Hi @ParthaSarathy I tried using the script below in the JS activity, but I encountered the error: 'it is not contained in either aggregate function or GROUP BY clause.' I am now attempting to use a subquery and will update you on the progress. var fquery = xtk.queryDef.create ( <queryDef schema = {v...

 Thank you @ParthaSarathy Is there a method to group them by the initial characters of the segment code? For example, if the segment code is "scen3_IS_DELETED," this value should be placed under the row labeled "Scen3," with a column named "IS_DELETED" set to 1 that gets the data frominstance.vars.c...

Thank you @ParthaSarathy This helped. Now, I need to select a few columns and send an alert email that includes the total number of customers based on each scenario.For example:My segment codes include:Scenario2a_OptOutScenario2a_IS_DELETEDI am unsure how to break this down further and include the t...

Hi @LakshmiPravallika , Thank you. It worked, but for one delivery, the decimal is still not rounding off to two decimal places. Please advise.   

Hi there,  I have a scenario where I need to share data about unpicked customers during a workflow execution that runs on a scheduler.I have multiple scenarios, each with different filters. To handle these, I have added query activities and split activities to filter and separate records with incomp...

Hi team,  Is there a way to round the decimal points for the function below:(percent([indicators/@estimatedRecipientOpen],[indicators/@successWithoutSeeds]))*100 I tried adding round:round((percent([indicators/@estimatedRecipientOpen],[indicators/@successWithoutSeeds]))*100, 2)but it throws an error...