Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
user:reports:templ:contents:tables:parameters [14/05/2018 05:32]
tagr [Time intervals and their use in reports]
user:reports:templ:contents:tables:parameters [28/09/2018 07:56] (current)
tagr
Line 27: Line 27:
 Sorting allows to distribute the grouped data by any selected column of the report table. Sorting allows to distribute the grouped data by any selected column of the report table.
  
-Next to each added grouping interval, in the //Sorting// column there is a drop-down list where you can specify the column included in the report so that the data will be sorted by the specified characteristic (column) within the grouping. The selected sorting criterion is applied to the subsequent (nested) grouping level. In addition, to the left of the drop-down list there is an icon with the help of which you can set the direction of sorting (from smaller to greater and vice versa). ​+Next to each added grouping interval, in the //Sorting// column there is a drop-down list where you can specify the column included in the report so that the data will be sorted by the specified characteristic (column) within the grouping. The selected sorting criterion is applied to the subsequent (nested) grouping level. In addition, to the left of the drop-down listthere is an icon with the help of which you can set the direction of sorting (from smaller to greater and vice versa). ​
  
 Tabular data can be sorted even if the grouping is absent. To do this, in the drop-down list in front of the //Total// interval select the sorting parameter and also set the direction of grouping. ​ Tabular data can be sorted even if the grouping is absent. To do this, in the drop-down list in front of the //Total// interval select the sorting parameter and also set the direction of grouping. ​
Line 35: Line 35:
 Let us consider the example of grouping and sorting use.  Let us consider the example of grouping and sorting use. 
  
-We create a report on trips. In this report we are interested in the maximum speed, duration, and mileage. Mark these columns. In addition, the information should be grouped by years, months and dates; the dates, in turn, should be sorted by the maximum speed (from high to low).+We create a report on trips. In this reportwe are interested in the maximum speed, duration, and mileage. Mark these columns. In addition, the information should be grouped by years, months and dates; the dates, in turn, should be sorted by the maximum speed (from high to low).
  
 By default, there is no grouping, i.e. without adding grouping or sorting settings, we would get a detailed report where an individual line would correspond to each criterion. These lines would be arranged in chronological order or according to the sorting, indicated next to the //Total// grouping. ​ By default, there is no grouping, i.e. without adding grouping or sorting settings, we would get a detailed report where an individual line would correspond to each criterion. These lines would be arranged in chronological order or according to the sorting, indicated next to the //Total// grouping. ​
Line 70: Line 70:
 ====Retrieve intervals==== ====Retrieve intervals====
  
-This option applies only to the reports with the grouping by [[user/​reports/​templ/​settings/​shifts|shifts]]. If it is not activated, the whole interval of the trip which intersected with the shiftgets in the report. If it is activated, then only the data from the messages received within the specified interval is included in the report.+This option applies only to the reports with the grouping by [[user/​reports/​templ/​settings/​shifts|shifts]]. If it is not activated, the whole interval of the trip which intersected with the shift gets in the report. If it is activated, then only the data from the messages received within the specified interval is included in the report.
  
Follow us on Facebook Gurtam Wialon Twitter Gurtam Wialon info@gurtam.com   |   Copyright © 2002-2018 Gurtam