You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to pass one output column as a filter in another report using custom script

edited Oct 13, 2017 7:25AM in Reporting & Analytics for B2C Service 3 comments

Content

HI All,

I am very new to custom scripts and can we able to do the below requirement using the custom script.

For example : 

In contacts level, we have a bank id as a unique value but due to some reasons it wrongly uploaded in the system. Currently we have Lakhs of contacts in the system and we need to delete the duplicate contacts based on some conditions.

1. .I have created a report with the group filter as count(bankid) > 1 and the columns as "Number of bank accounts"Count(bankid) , BankID .

2. I need to pass that BankID(which has been created as a first report output columns) as a filter in the second report and I have to show all the contact details as ID,FirstName,Lastname,Emailaddress.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!