All Collections
Help Articles
Apricot Results Reporting (ARR)
Apricot Results Reporting (ARR)

How to report on data with Apricot Results

49 articles
Apricot Results | Scheduling Reports
FAQs | Automated Export from Results Reporting (Apricot to SFTP)An article intended to help customers who have enlisted, or are considering enlisting, Professional Services for help exporting through SFTP

Apricot Results: Building Reports with an Excel Document
Apricot Results: Using a Custom Report as a Data SourceHow to use another Results Report as a data source
Apricot Results: Adding a New Query
Apricot Results | How to Edit Query Properties
Apricot Results | Pre- and Re-queriesHow to filter a data set with another query
Apricot Results: How to set Input Controls
Apricot Results: Drill FiltersFilters
Filtering for Active Participants in a Date Range
Apricot Results | Resetting Default Style
Apricot Results | Adding a Background Image
Apricot Results: Adding TablesThis article will go over the different types of tables that can be added to a report.
Apricot Results | Adding Reports (Tabs)In Apricot Results, each tab of a document is called a "report." This article will go over how to add new reports to your document.
Apricot Results: Sorting in Apricot Results
Apricot Results: Conditional Formatting
Apricot Results | Editing Tables/Legends
Results Reporting | Understanding Blank Date Fields
Apricot Results | Free Standing Cells/Pre-Defined Cells
Apricot Results | Hyperlinks to Participant Folders and Forms#results
Apricot Results | Creating Geographic ChartsUsing the Address Lookup form field to create Geographic Charts in Results
Apricot Results | Relative PositioningYou can use relative position to format the position of tables to prevent an overlapping of data
Apricot Results | Formatting Numbers and Dates in ReportsAll numbers and dates can be formatted to override the default formatting that is returned by Apricot Results
Apricot Results | Formatting Reports for Printing in Apricot ResultsFormatting reports to avoid page breaks, run off columns, and layout issues

Apricot Results | How to Find More Information on Functions and Operators
Apricot Results | Creating VariablesThis article will go over adding a new variable to an Apricot Results Report using the Variable Editor.
Apricot Results | Creating a Variable From a FormulaThis article will go over how to turn a formula into a variable in Apricot Results.
Apricot Results | Popular FormulasThis article reviews commonly used formulas in Apricot Results Reporting
Apricot Results | How to Flatten DataThis article pertains to the Apricot feature called Apricot Results Reporting
Apricot Results: Min, Max, First, LastThe difference between Min(), Max(), First(), Last() in reports
Apricot Results | Merge DimensionsMerged dimensions create a "merged" object from the shared objects within the multiple queries.
Finding the Most Recent Answer for a Tier 2 Field
Apricot Results | Counting The Number of Tier 2 Records Associated to a Tier 1
Apricot Results | Concatenating Data
Apricot Results | Changing Capitalization using the Upper, Lower, Initcap and WordCap functions
Apricot Results | Using the "Left" and "Right" functions to trim text strings
Apricot Results | Rounding Down or Up using the Floor and Ceil functions
Apricot Results | How to Get the Month, Day, or Year from a Date Object
Apricot Results | Converting a Date or Number to a String of Text
Apricot Results | Converting 24 hour time to 12 hour timeHow to convert military/24 hour time formats to a 12 hour format
Apricot Results | Finding the Time Between Two Dates with Times using the Timebetween Function