Some events can be charted with a limited set of dimensions. All events in a report must contain a report group that contains all of the included dimensions, although this report group does not have to be the same group across the events in the report.
If you add an event or dimension and the total number of potential rows to be displayed in the detail table exceeds 1,000 rows, a warning indicates that report performance can be impacted. If the warning is ignored, the Report Builder attempts to query and display the report. If this row limit is indeed exceeded in the returned data, the report is not displayed. If the warning is canceled, the proposed changes are maintained so that you can apply filtering to reduce the scope of the report.
If you add multiple events with shared dimensions, all data is displayed regardless of whether the data appears for both events. Suppose Event A and Event B share Dimension 1, and Event A has data for Dimension 1 value 1a, but Event B does not. The data for Event A, Dimension 1, value 1a is displayed in the report, while Event B shows a blank value for that data point. Dimension values that do not exist in the data set can be filled with 0
.
Multiple events
You cannot add multiple instances of the same event with the same data type to a single report, as it would be considered a duplicate, which is not allowed. However, if you add the event and change the data type for the first instance, you can then add the event again, as the event/default data type combination is not present in the report.
You can add the same event or ratio multiple times to see the data reported in multiple ways, such as raw count or average. You must open the Event Selector multiple times.
When the same event is added multiple times, its data is displayed on-screen only once, although the data can be in use in multiple ways in the report.
Numeric events
After you add a numeric event, the data type for the event is listed in square brackets.
- For regular events, the default data type is
[Count]
. - For numeric events, the default data type is
[Sum]
. - For ratios, the data type is set to
[Ratio]
. - If an item is renamed, the data type is no longer automatically displayed.
- The data type displayed in the report can be configured in the context menu.
Automatic event dimension
If no dimension is added to the report, the special Automatic
dimension is applied to the report. When report users adjust dates to display in the report, the appropriate date-based dimension is automatically selected for the report.
- If no dimension is added to the report, all included events must use the
Automatic
dimension. - If a specific dimension is selected for any selected event, the
Automatic
dimension is not applied.
Functions
You can apply mathematical functions to numerical event data or ratios for the Focus range and display the results in the same chart as the instance data. Using these functions, such as same day average, average, minimum, and maximum, you can make immediate comparisons of instance data against data across the function period range.
To the same metric, you can add multiple functions or duplicates of the same function, with different date ranges. If multiple functions are used for the same metric, the first function must have a value, or none of the functions are displayed.
Functions can be added for any event or ratio if no dimensions are present. If the Hour
of Day
, Day and Hour
, or Day
dimension is added to the chart, you must explicitly add a time-based dimension to the chart to enable the adding of functions.
Functions cannot be used in the same report as Top N filtering.
If you add multiple ratios with functions to a report, you cannot use non-calendar dimensions in it.
Function types
The following functions are available to apply to Focus data for events or ratios. If no date range dimension is explicitly included, the date interval is automatically calculated to display in the most legible output. For example, for date intervals larger than 28 days, the date interval is set to Month, and functions cannot be applied.
Function | Description | Default Period Range |
---|---|---|
Previous Days Average |
Average value of the values over the number of preceding days that are specified by the period range | 4 data points (4 days) |
Same Day of Week Average |
Computes a rolling average of the data for the same day over the number of preceding weeks that are specified by the period range. | 7 data points (7 days) |
Same Day of Week Minimum |
Minimum value of the values for the same day over the number of preceding weeks that are specified by the period range | 4 data points (4 weeks) |
Same Day of Week Maximum |
Maximum value of the values for the same day over the number of preceding weeks that are specified by the period range | 4 data points (4 weeks) |
When a function is added, it is listed by name under the event or ratio to which it is applied. The chart is updated to include the function output next the focus period data.
- You can add multiple functions of different types to the same event or ratio. You can not add multiple functions of the same type to the same item.
- You can change the type of charting for the function in the drop-down menu.
- Each function is also added as a column in the detail table.
You can configure aspects of the display of the function data from its drop-down menu. Specifically, you can configure the range of the reporting period for the function data.
Function period ranges
The period range for the function indicates the number of data points to use in the calculation. You can select one of the predefined values or enter a custom value for this period.
Depending on the type of function, how the configured number of data points applies to the Focus data can vary.
When a function is added, no check is made to see whether data is available for all data points required to fill the function period range. Reported values can be influenced by incomplete data. For example, if only seven days of data exist for a 28-day period, then the average value calculations are skewed downward. Minimum and maximum values can not capture the true values over the period.
For averaging functions, the function period range must be at least 3
. The upper limit in days to the function range is defined by the number of days of daily reporting data that are retained (Reporting Data (daily)-Days Retain
). This limit does not factor the date when Tealeaf was installed; it is possible to specify a function period that includes dates before Tealeaf was installed.
To verify the presence of data over the function period, configure the Focus range for each event to which you are adding a function to be a period as long as the function period range.
Dimensions
To complete dimensional analysis in your report, you can add dimensions to any of the three designated locations: X-axis, Y-axis, or Segment. All dimensions in the report must have at least one report group in common with all other dimensions.
You can not add multiple instances of the same dimension in the X-axes and Y-axes. You can add multiple instances of the same dimension to the Segment area. Dimensions can be moved between axes by using drag-and-drop, which preserves any configured dimension filtering.
Dimension types
Dimension types are indicated by color:
- Blue dimensions: The blue dimensions are custom dimensions that are specified in the currently selected event.
- Gray dimensions: Default Time dimensions are automatically recorded by Tealeaf. By default, only the compatible dimensions are displayed. If your selected event does not include a specific dimension, that dimension is not available for selection in the report. For example if the event does not have Browser Type as a dimension, the Browser Type dimension is not displayed in the left column.
- Dark gray dimensions: These dimensions are not available for selection for the current event.
General data dimension limits to reports
In a report, you can have up to nine specified dimensions:
- 4 x-axis dimensions. A chart cannot be rendered for a report that contains multiple X-axis dimensions
- 1 y-axis dimension
- 4 segment dimensions
A chart can have up to nine dimensions, including the date dimensions, which are always available.
You can add more than four distinct dimensions by adding time dimensions. They do occupy spots in the X-axis, Y-axis, and Segment zones.
Dimension limits for charting
The following limitations apply to the display of chart data regardless of chart type:
- Multiple dimensions cannot be charted.
- You cannot chart a Y-axis dimension if you include multiple events.
The number of dimensions depends on the type of chart that you have selected:
- Bar, Line, or Shaded charts - You cannot chart a Y-axis dimension if you include multiple events.
- Pie:
- You can add up to 4 segment dimensions and 1 Y-axis dimension if you have only 1 event.
- You cannot add a Y-axis dimension if you have more than 1 event.
- You cannot add X-axis dimensions to a pie chart.
- If you switch from a bar/line/shaded chart to a pie chart, the pie chart ignores the x-axis dimensions that you had configured.
Effects of dimensions on ratios
If you add a ratio to the report, any selected dimensions are applied to both the numerator and denominator.
For example, if you want to see a conversion rate report, you specify the numerator event to be a Completed Checkout event and the denominator to be a Started Checkout event. To review the conversion rate by Member Type, each Member Type value is applied to both the numerator and denominator at the same time.