Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
user:reports:templ:contents:tables:tables [11/09/2019 08:42]
alse
user:reports:templ:contents:tables:tables [11/02/2020 11:51] (current)
alse [Calculator] WH-1947
Line 29: Line 29:
 =====Calculator===== =====Calculator=====
  
-The calculator is available in all the tables ​(except for //Images//, //Video// and //​Statistics//​). It allows to add custom columns ​to them. To the left of the column names, ​indices in the C0, C1, C2 … CN format are indicatedIndices ​**do not change** regardless of the position of the column in the list. +The calculator is available in all the tables except for //Images//, //Video//and //​Statistics//​. It allows to add custom columns. To the left of the column names, ​you can see their indexes (C0, C1, C2 … CN)The indexes ​**do not change** regardless of the position of the column in the list. 
 {{ :​reports:​reports_calculator.png?​nolink }} {{ :​reports:​reports_calculator.png?​nolink }}
  
-To add an arbitrary ​column to the table, click on the //Add calculator//​ button and enter the calculation ​formula in the //Formula// field that appears. To do this, you can use:+To add a custom ​column to the table, click on the //Add calculator//​ button and specify ​the formula ​for calculating the value in the column. To do this, you can use: 
 +  * indexes of other columns (indicate them manually or click on the necessary ones in the list); 
 +  * unit parameters: consumption by rates (//​rcoef//​),​ daily engine hours rate (//dehr//), mileage coefficient (//​mcoef//​),​ unique ID (//​imei//​);​ 
 +  *  [[cms/​units/​charact|profile properties]] of the unit formatted as //​profile_field(index)//;​  
 +  * custom fields formatted as //​custom_field(name)//;​ 
 +  * constant values formatted as //​constX//;​ 
 +  * signs +, -, *, /, () for mathematical operations.
  
-  * indices of the columns of the table — you can enter them manually or click on the required ones in the list of available columns; +Thus, a formula ​can look, for example, ​as follows: ​//(С1+С2+С7)*const1.5/rcoef//.
-  * parameters of the unit: //rcoef// — consumption by rates//dehr// — standard hourly rate, //mcoef// - mileage coefficient;​ +
-  * constants (for example, //const2/5//); +
-  * mathematical operations +, -, *, and () to indicate their priority.+
  
-Thus, the formula ​can, for example, be as follows //(C1 + C2 + C7)*const1.5/rcoef//.+You can select the unit parameters and profile properties in the menu that opens when pointing to the '(...)' in the //Formula// field
  
-Specify ​the unit of measurement ​in the next field (up to 10 characters) and click //OK//The custom column ​automatically goes to the top of the list, however, if necessary, its position can be changed ​in the standard way. Such columns differ from the rest by the absence of an index and the background of a blue color.+:!: You cannot use the unique ID and profile properties ​in the formula together with other componentsOtherwise, a dash is displayed in the custom column in the report.
  
-:!: All time segments in the calculator use seconds as the unit of measurement.+To display a **custom field value** in a custom column, type //​custom_field(field name)// in the //​Formula// ​ field. Instead of the name, you can use its [[user/​gui/​masks#​name_mask|mask]]. If the names of several custom fields correspond to the indicated mask, the report shows the value of the field that comes first in the list of custom fields in the properties of the object. 
 + 
 +If the custom field value is indicated in numbers (without the unit of measurement),​ you can use it in the formula together with other components. With another type of custom field values, a dash is displayed in the custom column in the report. 
 + 
 +Next, type the unit of measurement (up to 10 characters) in the field to the right and click //OK//. The custom column automatically goes to the top of the list. However, you can change its position in the standard way if necessary. Such columns are highlighted in blue and do not have an index. 
 + 
 +:!: For time intervals, ​seconds ​are used as unit of measurement ​in the calculator
  
 {{ :​reports:​reports_calculator1.png?​nolink }} {{ :​reports:​reports_calculator1.png?​nolink }}
  
-To edit the name, formula, or units of measurement for the created column, click in the desired ​field with the left mouse button ​and make the required ​changes. Click anywhere in the dialog to confirm the changes.+To edit the name, formula, or unit of measurement for the created column, click in the necessary ​field and make the changes. Click anywhere in the dialog ​box to confirm the changes.
  
-:!: The value of an arbitrary ​column in the //​[[user/​reports/​templ/​contents/​tables/​settings#​total|Total]]//​ row is calculated in the same way as for other rows, that is, using the specified formula ​and the column ​values of the //Total// row.+:!: The value of the custom ​column in the //​[[user/​reports/​templ/​contents/​tables/​settings#​total|Total]]//​ row is calculated in the same way as for other rows, that is, in accordance with the specified formula ​that uses the values of the column.
  
 =====Table Settings===== =====Table Settings=====
Follow us on Facebook Gurtam Wialon Twitter Gurtam Wialon info@gurtam.com   |   Copyright © 2002-2020 Gurtam