ETO Results 4.2

ETO Results: Simple Filter Issues

#simplefilters #bouprade #etoresults

Written by Smith Ann Jones
Updated over a week ago

Participant Site ID, Client ID, and other ID's in reporting

Written by Bekah K.
Updated over a week ago

ETO Results | Table of Contents

BO Platform 4.2

Written by Smith Ann Jones
Updated over a week ago

ETO Results | Min, Max, First, Last

The differences between Min(), Max(), First(), Last()

Written by Smith Ann Jones
Updated over a week ago

Results | Web Intelligence Applet

Java virtual machine instruction when loading Results

Written by Smith Ann Jones
Updated over a week ago

ETO Results: Inflated/Duplicated Data

Explanations of Cartesian product in Results

Written by Smith Ann Jones
Updated over a week ago

ETO Results | Was Dismissed & Is/Was Active Objects

This covers the functionality of the objects: Was Dismissed, Is Active, and Was Active

Written by Smith Ann Jones
Updated over a week ago

Publications

Written by Bekah K.
Updated over a week ago

ETO Results | Getting Started

Written by Bekah K.
Updated over a week ago

ETO Results: Creating Geographic Charts

Using regions and sub-regions in geographic reporting charts #Results

Written by Smith Ann Jones
Updated over a week ago

ETO Results | How to Export a Report to Excel

#Results #Excel #Save #Download #Microsoft

Written by Colby Fore
Updated over a week ago

ETO Results | Flattened and Unflattened TouchPoint / Participant Data Access

S

Written by Strickland Bonner
Updated over a week ago

Add Link to Enroll Participant in Report

#ETOResults #Link #EnrollParticipant

Written by Starla
Updated over a week ago

Data Access

Features you can find under the Data Access tab in ETO Results #Results #DataAccess

Written by Starla
Updated over a week ago

ETO Results | Sorting

#Results #Sort

Written by Starla
Updated over a week ago

Repeat Column Headers/Footers on Multiple Pages in ETO Results

#Results #Formatting #ColumnHeaders #Repeat

Written by Starla
Updated over a week ago

Add Hyperlink to Edit Subform TouchPoint Response - Flattened Data

#Results #Subforms #Variable

Written by Starla
Updated over a week ago

Run a Report Using Common Date Objects

How to use date Objects from Universe Dimension in report Prompts #Results #UniverseDimensions #Requery

Written by Starla
Updated over a week ago

ETO Results | Finding More Information on Functions

This article will show you how to access articles for each function in ETO Results.

Written by Daniel Hanna
Updated over a week ago

Report Taking a Long Time to Load/Timing Out

#results #troubleshooting

Written by Taylor Roderick
Updated over a week ago

Changing the Date Format based on Country in ETO Results

#results

Written by Kristen Farnsworth
Updated over a week ago

ETO Results: Scheduling Reports

#Results

Written by Kristen Farnsworth
Updated over a week ago

Changing Program Name Doesn't Reflect in Results

#results #reporting #troubleshooting

Written by Kristen Farnsworth
Updated over a week ago

ETO Results Best Practices: Improving Report Performance

Helpful tips and tricks to improve report performance. #Results #bestpractice #performance

Written by Izzy
Updated over a week ago

Duplicated Data in Reports

#reporting #troubleshooting #results

Written by Taylor Roderick
Updated over a week ago

ETO Results Refresh Schedule

#Results

Written by Taylor Roderick
Updated over a week ago

Formulas: Commonly Used Links to Pages in ETO

#results

Written by Kristen Farnsworth
Updated over a week ago

Create a Flag

#results

Written by Starla
Updated over a week ago

Calculating Duration of a Start/End Time TouchPoint Question

#results

Written by Starla
Updated over a week ago

Understanding Functions in ETO Results

Outlining the method of understanding the many available functions in ETO Results #results

Written by Bekah K.
Updated over a week ago

Common Functions and Operators

A list of functions and operators that are used in ETO Results #results

Written by Izzy
Updated over a week ago

Display Null Values as "Unanswered" or "Unknown" Formula

#results

Written by Taylor Roderick
Updated over a week ago

Reporting Errors Overview

Common reporting errors #ETOResults

Written by Bekah K.
Updated over a week ago

ETO Results Best Practices: Maximizing Query Performance

#ETOResults

Written by Andre Harness
Updated over a week ago

BO 4.2: General Preferences

#Results

Written by Kristen Farnsworth
Updated over a week ago

Manage ETO Results Reports

#results

Written by Kristen Farnsworth
Updated over a week ago

Printing Reports

#results

Written by Kristen Farnsworth
Updated over a week ago

Delete Custom ETO Results Reports

#results

Written by Taylor Roderick
Updated over a week ago

Variable Qualifications

#Results #Variables #Qualification

Written by Starla
Updated over a week ago

ETO Results: Conditional Formatting

Highlight data when certain conditions are met

Written by Sarah Smith
Updated over a week ago

What is the difference between Flattened and Unflattened Data in ETO Results?

#Results

Written by Bekah K.
Updated over a week ago

ETO Results: Phone Format Formula

#ETOResults

Written by Taylor Roderick
Updated over a week ago

SQL Error when Running Report

#Results #Errors

Written by Taylor Roderick
Updated over a week ago

Aggregate TouchPoint Report

#Results

Written by Bekah K.
Updated over a week ago

ETO Results: SSN Formula

This article provides the formula for the SSN demographic. #ETOResults

Written by Bekah K.
Updated over a week ago

Creating a Variable From a Formula

#Results #Variables #Formulas #VariableEditor

Written by Starla
Updated over a week ago

Formatting Reports for Printing in ETO Results

Formatting reports to avoid page breaks, run off columns, and layout issues. #Results #Printing

Written by Bekah K.
Updated over a week ago

BO 4.2 Upgrade: You do not have access to one or more data providers

#Results #Errors

Written by Kristen Farnsworth
Updated over a week ago

Standard TouchPoint Universe (NEW)

Description of Results Objects in the Standard TouchPoint Universe New #results

Written by Izzy
Updated over a week ago

Caseload Filters in ETO Results

Answers the Question: What do the Caseload filters in Reports do? #results

Written by Izzy
Updated over a week ago

ETO Results | Manual Active Filter

#results

Written by Izzy
Updated over a week ago

Combined Queries

#results

Written by Bekah K.
Updated over a week ago

Separate TouchPoint Values for Non-Exclusive Choice Elements on to Separate Lines

#Results #FlattenedData

Written by Izzy
Updated over a week ago

Adding Date Prompts to Appear on Report

#results

Written by Bekah K.
Updated over a week ago

Add Filter to Reports

Users can refine the data set returned within a report by using the Filter tools within the Design View. #results #InputControls

Written by Izzy
Updated over a week ago

Creating Formulas

#results

Written by Starla
Updated over a week ago

Incorrect Totals/Aggregates

Troubleshooting Aggregates in ETO Results #results

Written by Izzy
Updated over a week ago

How to Set Input Controls

#results

Written by Taylor Roderick
Updated over a week ago

ETO Results | Averages are Incorrect

#results

Written by Izzy
Updated over a week ago

ETO Results | Active Filter vs "Is Active" Object

#results

Written by Kristen Farnsworth
Updated over a week ago

What is Subject Identifier and How Do I Utilize It?

#results #subject ID

Written by Taylor Roderick
Updated over a week ago

Change Report Name

#results

Written by Taylor Roderick
Updated over a week ago

Hyperlink to a Participant's Dashboard

#results

Written by Taylor Roderick
Updated over a week ago

Standard Calculations

#Results

Written by Kristen Farnsworth
Updated over a week ago

Edit Query Properties

This article gives the instructions for editing the Query Properties in BO 4.2. #results

Written by Izzy
Updated over a week ago

Alerters and Conditional Formatting

#results

Written by Izzy
Updated over a week ago

Reporting Terms

#results

Written by Taylor Roderick
Updated over a week ago

Complex Query Filters

#results

Written by Taylor Roderick
Updated over a week ago

Universes | ETO Results | Main Page

#Results #Universe

Written by Starla
Updated over a week ago

Linking TouchPoints to Enrollment

#Results #Flag #Enrollment #TouchPoints

Written by Starla
Updated over a week ago

Becoming Familiar with the Query Editor Interface

#results

Written by Kristen Farnsworth
Updated over a week ago

Saving Reports as Custom Reports

#results

Written by Kristen Farnsworth
Updated over a week ago

Basic Formatting: Cell/Table Color, Width, Orientation

#results

Written by Kristen Farnsworth
Updated over a week ago

Editing a Query

#results

Written by Kristen Farnsworth
Updated over a week ago

Page Setup Tab

#Results

Written by Kristen Farnsworth
Updated over a week ago

Copy a Table Between Reports

Using shared elements #results

Written by Kristen Farnsworth
Updated over a week ago

Auto-Save Feature

#results

Written by Kristen Farnsworth
Updated over a week ago

Data Objects in Audit Trail Folder

Audit, Identifier, Demographic #results

Written by Kristen Farnsworth
Updated over a week ago

Data Objects in the Identity Folder

Identifier, Family, Count #results

Written by Kristen Farnsworth
Updated over a week ago

Reference Cells

#results

Written by Andre Harness
Updated over a week ago

Running a Query Status Report

#results #QueryStatus #query

Written by Taylor Roderick
Updated over a week ago

Building Reports with an Excel Document

#results

Written by Kristen Farnsworth
Updated over a week ago

Report Looks Different when in Edit Mode

#results

Written by Taylor Roderick
Updated over a week ago

Basic Formatting: Sorting & Summing

#results

Written by Kristen Farnsworth
Updated over a week ago

Viewing and Editing Reports in ETO Results

#results

Written by Kristen Farnsworth
Updated over a week ago

Creating Sections in a Report

#results

Written by Kristen Farnsworth
Updated over a week ago

Basic Formatting: Background Image

#results

Written by Kristen Farnsworth
Updated over a week ago

Adding a Second Query

#results

Written by Kristen Farnsworth
Updated over a week ago

Nested Query Filters

#results

Written by Dakota Crespo
Updated over a week ago

How to Reorder Query Prompts

#results

Written by Kristen Farnsworth
Updated over a week ago

Accessing the ETO Results Online Guides

#results

Written by Kristen Farnsworth
Updated over a week ago

How to Lock/Unlock Report Queries

#results

Written by Bekah K.
Updated over a week ago

Hyperlink to a TouchPoint Attachment Upload

Make a link to a document that was uploaded to a TouchPoint response in ETO Results. #results

Written by Bekah K.
Updated over a week ago

Links to Features within ETO in Reports

Link, Feature, Report #results

Written by Kristen Farnsworth
Updated over a week ago

Simple Filters

#results

Written by Kristen Farnsworth
Updated over a week ago

Creating Variables

#Results #Variables #VariableEditor

Written by Starla
Updated over a week ago

Formatting Numbers and Dates in Reports

#results

Written by Kristen Farnsworth
Updated over a week ago

Free Standing Cells/Pre-Defined Cells

#results

Written by Kristen Farnsworth
Updated over a week ago

Creating Charts

#results

Written by Kristen Farnsworth
Updated over a week ago

Adding Tables

#results

Written by Kristen Farnsworth
Updated over a week ago

Editing Tables/Legends

#results

Written by Kristen Farnsworth
Updated over a week ago

Adding Reports (Tabs)

#results

Written by Kristen Farnsworth
Updated over a week ago

Creating a Report

#Results

Written by Bekah K.
Updated over a week ago

Fiscal Year Quarter Formula for TouchPoint Date Taken

#Results

Written by Starla
Updated over a week ago

Missing Demographics in Reports

#Results

Written by Starla
Updated over a week ago

Re-Query for Program Name

Adding a Re-Query for Program Name might be implemented to filter out program names on a Staff Report. #Results #Requery

Written by Bekah K.
Updated over a week ago

Creating Links to Demographic Attachments

Creating URLs and images to demographic attachments in ETO Results #Results

Written by Bekah K.
Updated over a week ago

Pre-Defined TouchPoint Filters

These filters exist in custom Universes with flattened TouchPoint data. #Results

Written by Starla
Updated over a week ago

Relative Positioning

You can use relative position to format the position of tables to prevent an overlapping of data #Results

Written by Starla
Updated over a week ago

Strip the Pipe Character (|) Out of a Value

In non-exlusive choice questions, you might see the "pipe" or | character in a text string. You can create a variable to remove it. #Results

Written by Starla
Updated over a week ago

Create a Count of Participants "Waiting" using the Any Date object

#Results #Formulas #Examples

Written by Starla
Updated over a week ago

Re-query for Assessment Name

This article describes how to re-query for Assessment Name, as a workaround for [PUR-176]. #Results #Workaround

Written by Starla
Updated over a week ago

Create a Custom Universe

#Results #Universe

Written by Andre Harness
Updated over a week ago

ETO Results | Flattened Data

Flattened Data in ETO Results and how to manually flatten objects. #Results #FlattenedData

Written by Starla
Updated over a week ago

Popular Formulas

This article reviews commonly used formulas in ETO Results #results

Written by Starla
Updated over a week ago

Context

What is context and how is it used in ETO Results? #Results #Context

Written by Starla
Updated over a week ago

How to Create a Hyperlink to View, Edit, or Add New TouchPoint Response in ETO Results

This article describes how to create a variable that will provide a hyperlink to a touchpoint response. #Results

Written by Starla
Updated over a week ago

First and Last Name from Subject Name

Create a First Name detail and a Last Name detail in ETO Results #Results

Written by Starla
Updated over a week ago

Query Filters Do Not Apply to Report

This article describes best practices for adding an object to the query filter in a report. #Results #Troubleshooting

Written by Starla
Updated over a week ago

Report Not Loading in Google Chrome

#Results #Troubleshooting

Written by Tania
Updated over a week ago

Merged Dimensions and Details

To be used when using multiple queries and needing to relate common data points. #Results #MergedDimensions #DetailVariable

Written by Starla
Updated over a week ago

Finding the Nth Response for a TouchPoint

How to find the 1st. 2nd, 3rd, 4th, etc. most recent TouchPoint response for a Participant in an ETO Results report #Results

Written by Starla
Updated over a week ago

ETO Alerts | Reporting on Alerts in ETO Results

This article describes general reporting tips for Alerts in ETO Results #Results #Alerts

Written by Starla
Updated over a week ago

Active, Enrolled, and Dismissed Participants in ETO Reports

#Results

Written by Starla
Updated over a week ago

‎ETO Results Custom Report Building: ‎ Building & Running a Query

#Results

Written by Starla
Updated over a week ago

Finding the Most Recent Response to a TouchPoint

Instructions on how to find the most recent response to a TouchPoint using different types of data. #Results

Written by Izzy
Updated over a week ago

Program Name in TouchPoint Responses

Troubleshooting Program name responses within ETO Results. #Results

Written by Starla
Updated over a week ago

ETO Results | Changing the Date Format Using the FormatDate function

Written by Daniel Hanna
Updated over a week ago

ETO Results: Rounding Down or Up using the Floor and Ceil functions

Written by Daniel Hanna
Updated over a week ago

ETO Results: Reporting on GIS Coordinates

Written by Smith Ann Jones
Updated over a week ago

Create Links Between Reports

Linking Reports, Links in Reports, Hyperlink reports, OpenDoc Links

Written by Bekah K.
Updated over a week ago

Custom Entity Universes | ETO Results

Written by Bekah K.
Updated over a week ago

How to Flatten Demographics/Touchpoint Answers Using Custom Variables

How to manually flatten objects in an unflattened Universe. #Results

Written by Starla
Updated over a week ago

Touchpoint Settings Universe | Touchpoint Security Report

These universes and reports show form settings, securities, and conditional rules for Touchpoint forms.

Written by Bekah K.
Updated over a week ago

Custom Universes: Find What Reports are Using a Universe

#Universe #Report #List #ReportList

Written by Franz Prowant
Updated over a week ago

TouchPoint Date Objects | Universe

Written by Bekah K.
Updated over a week ago

Standard Participant Universe

Written by Bekah K.
Updated over a week ago

Remapping a Report to a Different Universe

#Results

Written by Izzy
Updated over a week ago

ETO Results: Filtering Programs for TouchPoint Responses

How to filter for what programs a TouchPoint response was recorded in

Written by Smith Ann Jones
Updated over a week ago

ETO Results | Family Active Filter

Written by Bekah K.
Updated over a week ago

Saving and modifying scheduled reports from the scheduled report folder

Written by Bekah K.
Updated over a week ago

Opening Ports in Windows Firewall

Written by Bekah K.
Updated over a week ago