Workspace
-
Workbench. This is the work area in which you will be building the report.
-
Report Output. As you build your report, the Report Output pane allows you to preview the report.
-
Facts. Each piece displayed on your workbench is known as a fact. All reports must have at least one fact. Facts can be created for data source queries, formulas, or filters.
-
Data Sources pane. All reporting fields come from one of several data sources. Select the data source that makes the most sense for your report.
-
Fields pane. Add fields to your report by searching for and dragging them from the Fields pane to your facts.
Primary Query and Aggregated Fields
-
Primary Query. The first fact created from a data source acts as the Primary Query. The data source used here determines the base granularity of the report.
-
Aggregated fields. You can add fields as aggregated fields to consolidate data against them. For example, you would aggregate on Facility name to see data by facility.
-
Other included (non-aggregated) fields. If you choose not to aggregate any fields, you would add all fields into this box. If you choose to aggregate any fields, the data for the fields in this box will be consolidated.
-
Consolidation type. The consolidation type determines how data from non-aggregated fields will consolidate. The types are:
-
ONE. Assume one value.
-
MIN. Use lowest value from group.
-
MAX. Use highest value from group.
-
AVG. Take average of values in group.
-
SUM. Take sum of values in group.
-
CNT. Count of distinct values in group.
-
Formulas and Filters
-
Formulas. Formulas can be used to create new fields based on data from existing fields. Create a new formula by pressing the [Add Formula] button in the Data Sources pane.
-
Formula references. After creating a formula, you may reference the formula in subsequent formulas. These are highlighted in green.
-
Filters. Filters allow you to set limits on the scope of the report. You can add query-level filters by entering them into the query's Filter expression box. Or you can add report-wide filters by pressing the [Add Filter] button in the Data Sources pane.
-
Relative dates. Relative dates are date values that change relative to the present time e.g. {yesterday}, {last week}, and {2 months ago}. These can be used in filters by surrounding the date value in {curly braces}. These are highlighted in yellow.
Comments
2 comments
This is a good layout of where everything is, but doesn't quite explain how to create your report. For instance- how do you change the consolidation type for a field?
Hi Jene! To change the consolidation type, click on the text ("ONE", "CNT" etc) and select a consolidation type from the list. Check out our YouTube channel, we'll have a video about the reporting tool up soon! Typically we recommend that people start with a System Report if you're not sure where to start with a report. Please open a ticket with Support if we can assist further!
Please sign in to leave a comment.