Why is my data duplicated?
Data rows can be "Inflated," duplicating some data and returning results that do not seem correct.Some common reasons for this duplication are:
- Using an "Or" statement in a Query improperly. For Example: A query retrieves information for all participants who were: Active in a program between dates X and Y,ORTook TouchPoint Z. This query would retrieve any participant who was in an active program between the 2 specified dates, AND any participants who have ever taken TouchPoint Z. If you are trying to report in participants who were active between dates X and Y who have also TouchPoint Z, change the above statement from OR to AND.
- Results are Inflated due to value expansion: Program Name in Result Objects will return more lines of data connected to every Program Name a participant has been enrolled in. So if a Participant has been enrolled in more than one program, TouchPoint data may be multiplied for each program enrollment, even if the program name is not included in a table, or if the TouchPoint was only taken in 1 program or the other. Possible fixes include:Use “ForEach” [Program name] with formulas in a tableRemove [Program Name] from Result Objects if not necessary in the report.For stand-alone formula, need to use In context specified to the exact need of the formula (Participant ID, Response ID)
- There are TouchPoint responses appearing in reports that are not wanted.The [Program Name] object appears in many universes and do different things:In the Enrollment folder, this is connected to Participant enrollment. Filtering on a specific [Program Name] will limit data to Participant enrollment in that program, but without other filters this will retrieve all TP responses taken in any program by the participant.The [Program Name] in the Standard TouchPoint Universe NEW or in each TouchPoint folder (in flattened universes) will limit data to TouchPoints taken in that program, it is not affected by a Participant's enrollment.