Create multiple calculation queries, also known as a report.
{
"configuration": {
"id": "3687",
"title": "! !! ANALYTICS-2295",
"description": "",
"timeFilter": {
"arrangeType": "times_internal_day",
"connector": "AND",
"filterPredicate": "BETWEEN",
"value1": "2022-10-15",
"value2": "2023-12-28",
"context": "NONE",
"caseSensitive": false,
"intern": false,
"numberOfDays": "0"
},
"reportElements": [
{
"type": "TEXTBOX_DESCRIPTION",
"id": "43942",
"position": "0",
"positionAsPoint": {
"x": "0",
"y": "0"
},
"width": "3",
"height": "1",
"reportId": "3687",
"configJson": {}
},
{
"type": "TEXTBOX_CONTENT_TABLE",
"id": "43944",
"position": "1",
"positionAsPoint": {
"x": "3",
"y": "0"
},
"width": "3",
"height": "1",
"reportId": "3687",
"configJson": {}
},
{
"type": "ANALYSIS",
"id": "43946",
"position": "2",
"positionAsPoint": {
"x": "0",
"y": "0"
},
"width": "3",
"height": "78",
"reportId": "3687",
"configJson": {
"predefinedContainer": {
"filters": [],
"containers": [],
"combined": false
},
"title": "ThisareallyreallylongtrafficanalysistitleaimingtobreakthesidemenuUI",
"realTime": false,
"predefinedSegmentConnections": [],
"columns": [
{
"arrangeType": "time_id_categories_t_year_month_day",
"dataType": "NUMBER",
"sortDirection": "ASCENDING",
"title": "Days",
"scope": "OBJECT",
"context": "NONE",
"visible": true,
"dimension": true,
"metric": false,
"alias": "time_id_categories_t_year_month_day|0",
"lowerLimit": "1",
"upperLimit": "28",
"sumValue": false,
"predefinedSegmentConnections": []
},
{
"arrangeType": "visits",
"dataType": "NUMBER",
"title": "Visits",
"scope": "OBJECT",
"context": "SESSION",
"variant": "NORMAL",
"visible": true,
"dimension": false,
"metric": true,
"predefinedContainer": {
"filters": [],
"containers": [],
"combined": false
},
"alias": "visits|0",
"inTimeSeries": false,
"chart": {
"visible": true,
"yAxis": "0"
},
"sumValue": false,
"predefinedSegmentConnections": [],
"columnPeriod": "ANALYSIS",
"round": "-1",
"roundConfig": {
"override": false,
"round": "2"
}
},
{
"arrangeType": "page_impressions",
"dataType": "NUMBER",
"title": "Page Impressions",
"scope": "OBJECT",
"context": "PAGE",
"variant": "NORMAL",
"visible": true,
"dimension": false,
"metric": true,
"predefinedContainer": {
"filters": [],
"containers": [],
"combined": false
},
"alias": "page_impressions|0",
"inTimeSeries": false,
"chart": {
"visible": false,
"yAxis": "0"
},
"sumValue": false,
"predefinedSegmentConnections": [],
"columnPeriod": "ANALYSIS",
"round": "-1",
"roundConfig": {
"override": false,
"round": "2"
}
},
{
"arrangeType": "predefined_formula_new_visitor_rate",
"dataType": "NUMBER",
"title": "New Visit Rate %",
"metricDisplayType": "DISTRIBUTION",
"dataVisual": "BARS",
"scope": "OBJECT",
"variant": "NORMAL",
"visible": true,
"dimension": false,
"metric": true,
"predefinedContainer": {
"filters": [],
"containers": [],
"combined": false
},
"alias": "predefined_formula_new_visitor_rate|0",
"inTimeSeries": false,
"chart": {
"visible": true,
"yAxis": "1"
},
"sumValue": false,
"predefinedSegmentConnections": [],
"columnPeriod": "ANALYSIS",
"round": "2",
"roundConfig": {
"override": false,
"round": "2"
}
},
{
"arrangeType": "predefined_formula_avg_visit_duration",
"dataType": "NUMBER",
"title": "Visit Duration Avg",
"metricDisplayType": "TIME",
"dataVisual": "BARS",
"scope": "OBJECT",
"variant": "NORMAL",
"visible": true,
"dimension": false,
"metric": true,
"predefinedContainer": {
"filters": [],
"containers": [],
"combined": false
},
"alias": "predefined_formula_avg_visit_duration|0",
"inTimeSeries": false,
"chart": {
"visible": false,
"yAxis": "0"
},
"sumValue": false,
"predefinedSegmentConnections": [],
"columnPeriod": "ANALYSIS",
"round": "2",
"roundConfig": {
"override": false,
"round": "2"
}
},
{
"arrangeType": "predefined_formula_bounce_rate",
"dataType": "NUMBER",
"title": "Bounce Rate %",
"metricDisplayType": "DISTRIBUTION",
"dataVisual": "TRAFFIC_LIGHT",
"dataVisualTarget": "MIN",
"dataVisualTargetMax": "auto",
"dataVisualTargetMin": "auto",
"scope": "OBJECT",
"variant": "NORMAL",
"visible": true,
"dimension": false,
"metric": true,
"predefinedContainer": {
"filters": [],
"containers": [],
"combined": false
},
"alias": "predefined_formula_bounce_rate|0",
"inTimeSeries": false,
"chart": {
"visible": true,
"yAxis": "1"
},
"sumValue": false,
"predefinedSegmentConnections": [],
"columnPeriod": "ANALYSIS",
"round": "2",
"roundConfig": {
"override": false,
"round": "2"
}
}
],
"variant": "LIST",
"standardChart": "LINE",
"showTable": true,
"showPic": true,
"forbidChart": false,
"viewMode": {
"standard": {
"pivotState": [],
"sankeyConfig": {
"reverse": false,
"pathLength": "5",
"chartState": []
}
},
"timeSeries": {
"timeArrangeType": "time_id_categories_t_year_week",
"values": [],
"top": "3",
"viewType": "values"
},
"comparison": {
"type": "time",
"sorting": {
"time": [],
"segment": []
},
"values": {
"time": [],
"segment": []
},
"collapsed": {},
"primaryChangeType": {}
},
"path": {
"reverse": false,
"metricArrangeType": "",
"dimensionContext": "NONE",
"pathLength": "5",
"distinct": true,
"chartState": []
},
"crossTable": {
"metricArrangeType": "",
"metricSortDirection": "DESCENDING",
"crossDimensionSortDirection": "",
"mainDimensionSortDirection": "",
"dimensionUpperLimit": "10",
"crossDimensionArrangeType": ""
}
}
}
}
],
"showInMenu": true,
"predefined": false,
"creatorSSOUserId": "7",
"modifierSSOUserId": "7",
"creationTime": "2020-11-11T07:06:55+0000",
"modificationTime": "2021-12-17T09:48:24+0000",
"showContent": true,
"gridColumns": "0",
"publicReport": false,
"startDialogConfigurable": true,
"startDialogEnabled": false,
"quickFilters": [
{
"arrangeType": "custom_paras_session_generic42",
"connector": "AND",
"filterPredicate": "LIKE",
"value1": "",
"value2": "",
"context": "NONE",
"caseSensitive": false,
"intern": false,
"numberOfDays": "0"
}
],
"dashboardQuickFiltersCollapsed": false,
"dashboardQuickFilterValues": {
"custom_paras_session_generic42": {
"configurable": true,
"values": []
}
},
"categories": [],
"autoRefresh": false
}
}Id
Element Ids
Report Id
Array of columns
ID of the element
ID of the report
Type of the element for eg. Analysis, KPI, Sparkline
Different type of queries are possible
Array of columns
Possible sorting directions
Indicates order of sorting when there is more than one sorting column. (starting from 0).
Optional property indicating if a column will be used in time series view mode; defaults to false. Can be omitted if it's value is not set to true.
Indicates which Time range must be used for the column. ANALYSIS: uses the analysis time range. COLUMN: uses the time filter defined inside the column. ELEMENT: uses the time filter defined inside the element configuration - i.e. custom metric/formula
Context to evaluate the metric/dimension. If context property is not given or empty the default context of the object will be used. The default context can be identified from the context property in the response list of /query-objects.
Array of filters
Name of the Metric or Dimension being filtered.
Filter predicates
Connectors
Context to evaluate the metric/dimension. If context property is not given or empty the default context of the object will be used. The default context can be identified from the context property in the response list of /query-objects.
Indicates if filter should be prioritized (Advanced).
Array of values
Array of values
array of containers (recursion)
Connectors
Context to evaluate the metric/dimension. If context property is not given or empty the default context of the object will be used. The default context can be identified from the context property in the response list of /query-objects.
Indicates how filters must be applied. TIME_ORDER is sequential, NORMAL not
Type of Data Structure
Array of filters
Name of the Metric or Dimension being filtered.
Filter predicates
Connectors
Context to evaluate the metric/dimension. If context property is not given or empty the default context of the object will be used. The default context can be identified from the context property in the response list of /query-objects.
Indicates if filter should be prioritized (Advanced).
Array of values
Array of values
array of containers (recursion)
Connectors
Context to evaluate the metric/dimension. If context property is not given or empty the default context of the object will be used. The default context can be identified from the context property in the response list of /query-objects.
Indicates how filters must be applied. TIME_ORDER is sequential, NORMAL not
Name of the Metric or Dimension being filtered.
Filter predicates
Connectors
Context to evaluate the metric/dimension. If context property is not given or empty the default context of the object will be used. The default context can be identified from the context property in the response list of /query-objects.
Indicates if filter should be prioritized (Advanced).
Array of values
Array of values
type of comparison. It can be either on time or segment. The corresponding properties must be filled accordingly in values and sorting
Name of the Metric or Dimension being filtered.
Filter predicates
Connectors
Context to evaluate the metric/dimension. If context property is not given or empty the default context of the object will be used. The default context can be identified from the context property in the response list of /query-objects.
Indicates if filter should be prioritized (Advanced).
Array of values
Array of values
ID of the Segment
Context to evaluate the metric/dimension. If context property is not given or empty the default context of the object will be used. The default context can be identified from the context property in the response list of /query-objects.
Indicates segment ordering in case of several Segment
Sorting of comparison
alias of the column being sorted
Possible sorting directions
Sorting of comparison
alias of the column being sorted
Possible sorting directions
The name of the time dimension used in the time series - i.e. "time_days" for days.
The type of the time series view mode. Set "top" for time series of the top "x" number of objects. Set "values" based on specific object values populated in the values list of this configuration.
The number of top objects the time series is build upon.
A list of object values - i.e. ["Seach", "Cart", "Home"] for object "pages".
The name of the metric used in the path analysis - i.e. "visits".
The context in which the dimension for the path analysis is evaluated.
Whether the path analysis should be performed in reverse order.
Whether to count only unique paths in the analysis.
The maximum number of steps to include in the path analysis.
The name of the metric used for values in the cross table analysis - i.e. "pages_pageImpressions".
The name of the dimension used for the cross-analysis - i.e. "browser_fullName".
Sort direction for the main dimension.
Sort direction for the metric values.
The maximum number of dimension values to include in the analysis.
Sort direction for the cross dimension.
One of the following periods should be used:
- ELEMENT: when the time filter is either inherited from the report or the time filter configured in the report element configuration.
- MONAD: when the time filter is inherited from the custom metric configuration.
Type of the query
name of the metric of the KPI
name of the dimension of the KPI
Comparison definition
Type of comparison
Name of the Metric or Dimension being filtered.
Filter predicates
Connectors
Context to evaluate the metric/dimension. If context property is not given or empty the default context of the object will be used. The default context can be identified from the context property in the response list of /query-objects.
Indicates if filter should be prioritized (Advanced).
Array of values
Array of values
Array of filters
Name of the Metric or Dimension being filtered.
Filter predicates
Connectors
Context to evaluate the metric/dimension. If context property is not given or empty the default context of the object will be used. The default context can be identified from the context property in the response list of /query-objects.
Indicates if filter should be prioritized (Advanced).
Array of values
Array of values
array of containers (recursion)
Connectors
Context to evaluate the metric/dimension. If context property is not given or empty the default context of the object will be used. The default context can be identified from the context property in the response list of /query-objects.
Indicates how filters must be applied. TIME_ORDER is sequential, NORMAL not
Name of the Metric or Dimension being filtered.
Filter predicates
Connectors
Context to evaluate the metric/dimension. If context property is not given or empty the default context of the object will be used. The default context can be identified from the context property in the response list of /query-objects.
Indicates if filter should be prioritized (Advanced).
Array of values
Array of values
Name of the Metric or Dimension being filtered.
Filter predicates
Connectors
Context to evaluate the metric/dimension. If context property is not given or empty the default context of the object will be used. The default context can be identified from the context property in the response list of /query-objects.
Indicates if filter should be prioritized (Advanced).
Array of values
Array of values
Name of the Metric or Dimension being filtered.
Filter predicates
Connectors
Context to evaluate the metric/dimension. If context property is not given or empty the default context of the object will be used. The default context can be identified from the context property in the response list of /query-objects.
Indicates if filter should be prioritized (Advanced).
Array of values
Array of values
Name of the Metric or Dimension being filtered.
Filter predicates
Connectors
Context to evaluate the metric/dimension. If context property is not given or empty the default context of the object will be used. The default context can be identified from the context property in the response list of /query-objects.
Indicates if filter should be prioritized (Advanced).
Array of values
Array of values
OK
Correlation Id of the report
Status of the report after complete analysis
Last updated time of report
Report Unique Id
Report Name
List of query state of all caculation queries
Id of the account
ID of the query
Id of the calculated data
Link to get analysis data
Analysis query state
Last update time in milliseconds since the UNIX epoch
ID of the report element
Bad Request
HTTP Status Code
Specific Mapp Error Code
Short description of the problem
Detailed informations about the problem
Each error has specific properties described in following table:
| Error | Description | Relevant parameters |
|---|---|---|
| UnmappedName | At least one object name cannot be found. | List of objects not found in names array. |
| PivotIncompatibleMetric | Metric not usable in Pivot detected. | List of incompatible Metrics in names array. |
| PivotIncompatibleDimension | Dimension not usable in Pivot detected. | List of incompatible Dimensions in names array. |
| AnalysisLogicalCubeMismatch | All Dimensions and Metrics are not compatible. | List of incompatible objects in names array. |
| InvalidSortingCriteria | Sorting is applied on a non-sortable object. | List of invalid sorted objects in names array. |
| TimeFilterMissing | Each query must have a minimum of one Time Filter. | N/A |
| InvalidSegmentNoneContainer | A segment container has context set to NONE but either its connector is not set to AND or its inOrNotIn property is not set to IN. | N/A |
List of internal object names (dimension, metrics, filter, ...) that corresponds to the error.
List of columns aliases that corresponds to the error. See Result Header alias property.
List of object names (dimension, metrics, filter, ...) that corresponds to the error.
Each warnings has specific properties described in following table:
| Warning | Description | Relevant parameters |
|---|---|---|
| FilterLogicalCubeMismatch | At least one filter is ignored due to incompatibily with Dimensions and Metrics used. | List of incomptible filter objects in names array. |
| InvalidMetricContext | Metric used in an invalid context. | List of metric with invalid context in aliases array. |
| SortingEnforced | Sorting criteria has been added automatically | List of objects that were sorted automatically in aliases array. |
| NoSortingDefined | Sorting criteria is required for some dimensions. | List of dimensions requiring a sorting in names array. |
| SortingLimitExceeded | 3 sorting criteria are allowed. All additional sorting criteria have been omitted. | List of columns ignored for sorting in aliases array. |
| SortingRemoved | A requested sorting criteria has been removed | List of objects that were removed automatically in aliases array. |
| TodayRemoved | Today date has been removed from calculation time range because the selected datasource does not contain it. | daysInDataSource, todayDate |
List of internal object names (dimension, metrics, filter, ...) that corresponds to the warning.
List of columns aliases that corresponds to the error. See Result Header alias property.
List of object names (dimension, metrics, filter, ...) that corresponds to the warning.
Number of days in the datasource which is beeing cut
Date of the day being cut
Not Found
HTTP Status Code
Specific Mapp Error Code
Short description of the problem
Detailed informations about the problem
Each error has specific properties described in following table:
| Error | Description | Relevant parameters |
|---|---|---|
| UnmappedName | At least one object name cannot be found. | List of objects not found in names array. |
| PivotIncompatibleMetric | Metric not usable in Pivot detected. | List of incompatible Metrics in names array. |
| PivotIncompatibleDimension | Dimension not usable in Pivot detected. | List of incompatible Dimensions in names array. |
| AnalysisLogicalCubeMismatch | All Dimensions and Metrics are not compatible. | List of incompatible objects in names array. |
| InvalidSortingCriteria | Sorting is applied on a non-sortable object. | List of invalid sorted objects in names array. |
| TimeFilterMissing | Each query must have a minimum of one Time Filter. | N/A |
| InvalidSegmentNoneContainer | A segment container has context set to NONE but either its connector is not set to AND or its inOrNotIn property is not set to IN. | N/A |
List of internal object names (dimension, metrics, filter, ...) that corresponds to the error.
List of columns aliases that corresponds to the error. See Result Header alias property.
List of object names (dimension, metrics, filter, ...) that corresponds to the error.
Each warnings has specific properties described in following table:
| Warning | Description | Relevant parameters |
|---|---|---|
| FilterLogicalCubeMismatch | At least one filter is ignored due to incompatibily with Dimensions and Metrics used. | List of incomptible filter objects in names array. |
| InvalidMetricContext | Metric used in an invalid context. | List of metric with invalid context in aliases array. |
| SortingEnforced | Sorting criteria has been added automatically | List of objects that were sorted automatically in aliases array. |
| NoSortingDefined | Sorting criteria is required for some dimensions. | List of dimensions requiring a sorting in names array. |
| SortingLimitExceeded | 3 sorting criteria are allowed. All additional sorting criteria have been omitted. | List of columns ignored for sorting in aliases array. |
| SortingRemoved | A requested sorting criteria has been removed | List of objects that were removed automatically in aliases array. |
| TodayRemoved | Today date has been removed from calculation time range because the selected datasource does not contain it. | daysInDataSource, todayDate |
List of internal object names (dimension, metrics, filter, ...) that corresponds to the warning.
List of columns aliases that corresponds to the error. See Result Header alias property.
List of object names (dimension, metrics, filter, ...) that corresponds to the warning.
Number of days in the datasource which is beeing cut
Date of the day being cut
Unprocessable Entity
Internal Server Error
HTTP Status Code
Specific Mapp Error Code
Short description of the problem
Detailed informations about the problem
Each error has specific properties described in following table:
| Error | Description | Relevant parameters |
|---|---|---|
| UnmappedName | At least one object name cannot be found. | List of objects not found in names array. |
| PivotIncompatibleMetric | Metric not usable in Pivot detected. | List of incompatible Metrics in names array. |
| PivotIncompatibleDimension | Dimension not usable in Pivot detected. | List of incompatible Dimensions in names array. |
| AnalysisLogicalCubeMismatch | All Dimensions and Metrics are not compatible. | List of incompatible objects in names array. |
| InvalidSortingCriteria | Sorting is applied on a non-sortable object. | List of invalid sorted objects in names array. |
| TimeFilterMissing | Each query must have a minimum of one Time Filter. | N/A |
| InvalidSegmentNoneContainer | A segment container has context set to NONE but either its connector is not set to AND or its inOrNotIn property is not set to IN. | N/A |
List of internal object names (dimension, metrics, filter, ...) that corresponds to the error.
List of columns aliases that corresponds to the error. See Result Header alias property.
List of object names (dimension, metrics, filter, ...) that corresponds to the error.
Each warnings has specific properties described in following table:
| Warning | Description | Relevant parameters |
|---|---|---|
| FilterLogicalCubeMismatch | At least one filter is ignored due to incompatibily with Dimensions and Metrics used. | List of incomptible filter objects in names array. |
| InvalidMetricContext | Metric used in an invalid context. | List of metric with invalid context in aliases array. |
| SortingEnforced | Sorting criteria has been added automatically | List of objects that were sorted automatically in aliases array. |
| NoSortingDefined | Sorting criteria is required for some dimensions. | List of dimensions requiring a sorting in names array. |
| SortingLimitExceeded | 3 sorting criteria are allowed. All additional sorting criteria have been omitted. | List of columns ignored for sorting in aliases array. |
| SortingRemoved | A requested sorting criteria has been removed | List of objects that were removed automatically in aliases array. |
| TodayRemoved | Today date has been removed from calculation time range because the selected datasource does not contain it. | daysInDataSource, todayDate |
List of internal object names (dimension, metrics, filter, ...) that corresponds to the warning.
List of columns aliases that corresponds to the error. See Result Header alias property.
List of object names (dimension, metrics, filter, ...) that corresponds to the warning.
Number of days in the datasource which is beeing cut
Date of the day being cut