Skip to Content

Changes for page 6. Flexible Reports Guide

Last modified by Iaroslav Platonov on 2026/06/08 15:20
From version 33.1
edited by Lana
on 2025/12/10 23:45
Change comment: Uploaded new attachment "Screenshot 2025-12-10 at 20.45.11.png", version {1}
To version 39.1
edited by Lana
on 2025/12/17 21:20
Change comment: Uploaded new attachment "Screenshot 2025-12-16 183927.png", version {1}

Summary

Details

Page properties
Content
... ... @@ -1,5 +1,7 @@
1 1  = CONTENT =
2 2  
3 +{{toc/}}
4 +
3 3  = 1. INTRODUCTION =
4 4  
5 5  CENTO is a multifunctional software platform for data collection, processing, and display. This guide describes the flexible reporting tool in CENTO.
... ... @@ -54,7 +54,7 @@
54 54  
55 55  For reports for a day, month, and year, the query is built as described in Figure 2.2.
56 56  
57 -[[image:Screenshot 2025-12-10 at 19.43.28.png]]
59 +[[image:Screenshot 2025-12-10 at 19.43.28.png||height="163" width="519"]]
58 58  
59 59  Fig.2.2 – Query example
60 60  
... ... @@ -62,15 +62,15 @@
62 62  
63 63  1) **y-m-d:** means that the year, month, and day values from the date** **associated with the report will be inserted into the query (specified when creating the template via the web-interface). Only part of the date associated with the report can be used. For example, **y2024-m-d **means that the month and day should be substituted, while the year (2024) remains fixed as specified in the request. **y2024-m2-d **means that only the day should be substituted with the year set to 2024 and the month set to 2 (February).
64 64  
65 -It is also possible to omit **d (y-m:)**, or omit **m** and **d (y:)**, this means that we are interested in the entire interval (if only the year is specified, then the entire annual interval, if the year and month are specified, then the monthly interval).
67 +It is also possible to omit **d (y-m: )**, or omit **m** and **d (y: )**, this means that we are interested in the entire interval (if only the year is specified, then the entire annual interval, if the year and month are specified, then the monthly interval).
66 66  
67 -The **d** can also be omitted (**y-m:**), or both **m** and **d** can be omitted (**y:**). This means the entire interval is considered, if only the year is specified, the entire annual interval is used, and if the year and month are specified, the monthly interval is used.
69 +The **d** can also be omitted (**y-m:**), or both **m** and **d** can be omitted (**y: **). This means the entire interval is considered, if only the year is specified, the entire annual interval is used, and if the year and month are specified, the monthly interval is used.
68 68  
69 69  **h10-m00** means that the values for the specified hour and minute will be inserted into the query. By omitting seconds, CENTO understands that the entire minute interval is of interest. This means the sample will be from 10:00 to 10:01 (excluding data for 10:01:00, effectively from 10:00:00 to 10:00:59). To make a sample for an hour, write **h10** omitting minutes and seconds. The time does not need to be specified at all, for example, if the interest is in the data for the day. However, to ensure the query is correct, write “*” in place of the time, like this: ~*~*y-m-d::el-dev-30-ea_imp-3m:sum~*~*.
70 70  
71 71  The first two parts of the query can be replaced with another, more convenient formula with **#date**, which will be described below.
72 72  
73 -2) The entry** el-dev-30-ea_imp-3m **has the following parts:
75 +2) The entry** el-dev-30-ea_imp-3m **has the following parts:
74 74  
75 75  * **el** (electricity) is electrical data. Data on other measurements (heat, pressure, emissions, etc.) are requested with the entry **en** (energy);
76 76  * **dev-30** (device) is accessing a device with an id 30 for which data needs to be downloaded;
... ... @@ -112,24 +112,24 @@
112 112  
113 113  Table 2.3. Comparative table of y-m-d and #date formulas
114 114  
115 -|**№**|(% style="width:161px" %)**Format with y-m-d**|(% style="width:134px" %)**Format with #date**|(% style="width:198px" %)**Description**|(% style="width:106px" %)**Type of report in which the formula is applied**
116 -|1|(% style="width:161px" %)y-m-d3:*:el-dev-201-ea_imp-30m:sum|(% style="width:134px" %)#date-d3:d:dev-201-ea_imp:sum|(% style="width:198px" %)Sum of all half-hours on the 3rd day of the month|(% style="width:106px" %)monthly, daily
117 -|2|(% style="width:161px" %)y-m-d1:h00-m30:el-dev-201-ea_imp-30m:sum|(% style="width:134px" %)#date-d1-h00-m30:*:dev-201-ea_imp|(% style="width:198px" %)Value of the half-hour is 00-30 on the first day|(% style="width:106px" %)monthly, daily
118 -|3|(% style="width:161px" %)y-m-d+1:h00-m30:el-dev-201-ea_imp-30m|(% style="width:134px" %)#date+1-h00-m30:*:dev-201-ea_imp|(% style="width:198px" %)Value of the half-hour is 00-30 of the day following the selected one|(% style="width:106px" %)daytime
119 -|4|(% style="width:161px" %)y-m-d+10:h00-m30:el-bg-42-30m|(% style="width:134px" %)#date+10-h00-m30:*:bg-42|(% style="width:198px" %)Value of the half-hour is 00-30 per day +10; checking the operation of the electro-billing group|(% style="width:106px" %)daytime
120 -|5|(% style="width:161px" %)y-m-d-1:h00-m30:el-dev-201-ea_imp-30m|(% style="width:134px" %)#date-1-h00-m30:*:dev-201-ea_imp|(% style="width:198px" %)Value of the 00-30 half-hour per day is -1|(% style="width:106px" %)daytime
121 -|6|(% style="width:161px" %)y-m-d1-1:h01-m00:el-dev-201-ea_imp-30m|(% style="width:134px" %)#date-d1-1-h01-m00:*:dev-201-ea_imp|(% style="width:198px" %)Value of the 01-00 half-hour for the last day of the previous month|(% style="width:106px" %)monthly, daily
122 -|7|(% style="width:161px" %)y-m-d1-2:h00-m30:el-dev-201-ea_imp-30m|(% style="width:134px" %)#date-d1-2-h00-m30:*:dev-201-ea_imp|(% style="width:198px" %)Value of the half-hour is 00-30 for the penultimate day of the previous month|(% style="width:106px" %)monthly, daily
123 -|8|(% style="width:161px" %)y-m-d:*:el-dev-201-ea_imp-30m:sum|(% style="width:134px" %)#date:d:dev-201-ea_imp:sum|(% style="width:198px" %)Sum of all half-hours for the selected day|(% style="width:106px" %)daytime
124 -|9|(% style="width:161px" %)y-m:*:el-dev-201-ea_imp-30m:sum|(% style="width:134px" %)#date:m:dev-201-ea_imp:sum|(% style="width:198px" %)Sum of all half-hours for the selected month|(% style="width:106px" %)annual, monthly, daily
125 -|10|(% style="width:161px" %)y:*:el-dev-201-ea_imp-30m:max|(% style="width:134px" %)#date:y:dev-201-ea_imp:max|(% style="width:198px" %)The maximum half-hour for a selected year|(% style="width:106px" %)annual, monthly, daily
126 -|11|(% style="width:161px" %)y-m-1m:*:el-dev-201-ea_imp-30m:min|(% style="width:134px" %)#date-1m:m:dev-201-ea_imp:min|(% style="width:198px" %)Minimum half-hour for the previous month|(% style="width:106px" %)annual, monthly
127 -|12|(% style="width:161px" %)y-m1:*:en-dev-220-1021-1h:mean|(% style="width:134px" %)#date-m2:m:ch-1021-1h:mean|(% style="width:198px" %)Output the average of all hours from channel 1021 at device 220 for February of the year selected by the user|(% style="width:106px" %)annual, monthly, daily
128 -| |(% style="width:161px" %) |(% style="width:134px" %)**New functions available only with #date**|(% style="width:198px" %) |(% style="width:106px" %)
129 -|13|(% style="width:161px" %) |(% style="width:134px" %)#date-h08-#date-h17:*:dev-201-ea_imp:sum|(% style="width:198px" %)Sum of energy as of the report date from 8 a.m. to 5 p.m.|(% style="width:106px" %)daytime
130 -|14|(% style="width:161px" %) |(% style="width:134px" %)#date+1-h08-#date+1-h17:*:dev-201-ea_imp:sum|(% style="width:198px" %)Sum of energy for the day following the reporting day from 8 a.m. to 5 p.m.|(% style="width:106px" %)daytime
131 -|15|(% style="width:161px" %) |(% style="width:134px" %)#date-d1-h08-#date+1-h17:*:dev-201-ea_imp:sum|(% style="width:198px" %)Sum of energy from the first day of the month at 8 a.m. to the day following the reporting day at 5 p.m.|(% style="width:106px" %)daytime
132 -|16|(% style="width:161px" %) |(% style="width:134px" %)#date-d1-1-h08-#date+1-h17:*:dev-201-ea_imp:sum|(% style="width:198px" %)Sum of energy from the last day of the previous month, 8 a. m. to the day following the reporting one, up to 5 p.m.|(% style="width:106px" %)daytime
117 +|(% style="width:52px" %)**№**|(% style="width:332px" %)**Format with y-m-d**|(% style="width:336px" %)**Format with #date**|(% style="width:461px" %)**Description**|(% style="width:160px" %)**Type of report in which the formula is applied**
118 +|(% style="width:52px" %)1|(% style="width:332px" %)y-m-d3:*:el-dev-201-ea_imp-30m:sum|(% style="width:336px" %)#date-d3:d:dev-201-ea_imp:sum|(% style="width:461px" %)Sum of all half-hours on the 3rd day of the month|(% style="width:160px" %)monthly, daily
119 +|(% style="width:52px" %)2|(% style="width:332px" %)y-m-d1:h00-m30:el-dev-201-ea_imp-30m:sum|(% style="width:336px" %)#date-d1-h00-m30:*:dev-201-ea_imp|(% style="width:461px" %)Value of the half-hour is 00-30 on the first day|(% style="width:160px" %)monthly, daily
120 +|(% style="width:52px" %)3|(% style="width:332px" %)y-m-d+1:h00-m30:el-dev-201-ea_imp-30m|(% style="width:336px" %)#date+1-h00-m30:*:dev-201-ea_imp|(% style="width:461px" %)Value of the half-hour is 00-30 of the day following the selected one|(% style="width:160px" %)daytime
121 +|(% style="width:52px" %)4|(% style="width:332px" %)y-m-d+10:h00-m30:el-bg-42-30m|(% style="width:336px" %)#date+10-h00-m30:*:bg-42|(% style="width:461px" %)Value of the half-hour is 00-30 per day +10; checking the operation of the electro-billing group|(% style="width:160px" %)daytime
122 +|(% style="width:52px" %)5|(% style="width:332px" %)y-m-d-1:h00-m30:el-dev-201-ea_imp-30m|(% style="width:336px" %)#date-1-h00-m30:*:dev-201-ea_imp|(% style="width:461px" %)Value of the 00-30 half-hour per day is -1|(% style="width:160px" %)daytime
123 +|(% style="width:52px" %)6|(% style="width:332px" %)y-m-d1-1:h01-m00:el-dev-201-ea_imp-30m|(% style="width:336px" %)#date-d1-1-h01-m00:*:dev-201-ea_imp|(% style="width:461px" %)Value of the 01-00 half-hour for the last day of the previous month|(% style="width:160px" %)monthly, daily
124 +|(% style="width:52px" %)7|(% style="width:332px" %)y-m-d1-2:h00-m30:el-dev-201-ea_imp-30m|(% style="width:336px" %)#date-d1-2-h00-m30:*:dev-201-ea_imp|(% style="width:461px" %)Value of the half-hour is 00-30 for the penultimate day of the previous month|(% style="width:160px" %)monthly, daily
125 +|(% style="width:52px" %)8|(% style="width:332px" %)y-m-d:*:el-dev-201-ea_imp-30m:sum|(% style="width:336px" %)#date:d:dev-201-ea_imp:sum|(% style="width:461px" %)Sum of all half-hours for the selected day|(% style="width:160px" %)daytime
126 +|(% style="width:52px" %)9|(% style="width:332px" %)y-m:*:el-dev-201-ea_imp-30m:sum|(% style="width:336px" %)#date:m:dev-201-ea_imp:sum|(% style="width:461px" %)Sum of all half-hours for the selected month|(% style="width:160px" %)annual, monthly, daily
127 +|(% style="width:52px" %)10|(% style="width:332px" %)y:*:el-dev-201-ea_imp-30m:max|(% style="width:336px" %)#date:y:dev-201-ea_imp:max|(% style="width:461px" %)The maximum half-hour for a selected year|(% style="width:160px" %)annual, monthly, daily
128 +|(% style="width:52px" %)11|(% style="width:332px" %)y-m-1m:*:el-dev-201-ea_imp-30m:min|(% style="width:336px" %)#date-1m:m:dev-201-ea_imp:min|(% style="width:461px" %)Minimum half-hour for the previous month|(% style="width:160px" %)annual, monthly
129 +|(% style="width:52px" %)12|(% style="width:332px" %)y-m1:*:en-dev-220-1021-1h:mean|(% style="width:336px" %)#date-m2:m:ch-1021-1h:mean|(% style="width:461px" %)Output the average of all hours from channel 1021 at device 220 for February of the year selected by the user|(% style="width:160px" %)annual, monthly, daily
130 +|(% style="width:52px" %) |(% style="width:332px" %) |(% style="width:336px" %)**New functions available only with #date**|(% style="width:461px" %) |(% style="width:160px" %)
131 +|(% style="width:52px" %)13|(% style="width:332px" %) |(% style="width:336px" %)#date-h08-#date-h17:*:dev-201-ea_imp:sum|(% style="width:461px" %)Sum of energy as of the report date from 8 a.m. to 5 p.m.|(% style="width:160px" %)daytime
132 +|(% style="width:52px" %)14|(% style="width:332px" %) |(% style="width:336px" %)#date+1-h08-#date+1-h17:*:dev-201-ea_imp:sum|(% style="width:461px" %)Sum of energy for the day following the reporting day from 8 a.m. to 5 p.m.|(% style="width:160px" %)daytime
133 +|(% style="width:52px" %)15|(% style="width:332px" %) |(% style="width:336px" %)#date-d1-h08-#date+1-h17:*:dev-201-ea_imp:sum|(% style="width:461px" %)Sum of energy from the first day of the month at 8 a.m. to the day following the reporting day at 5 p.m.|(% style="width:160px" %)daytime
134 +|(% style="width:52px" %)16|(% style="width:332px" %) |(% style="width:336px" %)#date-d1-1-h08-#date+1-h17:*:dev-201-ea_imp:sum|(% style="width:461px" %)Sum of energy from the last day of the previous month, 8 a. m. to the day following the reporting one, up to 5 p.m.|(% style="width:160px" %)daytime
133 133  
134 134  == 2.4. Query examples ==
135 135  
... ... @@ -181,13 +181,13 @@
181 181  
182 182  A template generated in accordance with the query language specified in Section 1 is uploaded to the Flexible Reports page (see Figure 3.1) by clicking the (Create Template) button [[image:Screenshot 2025-12-10 at 19.48.07.png||height="27" width="29"]] in the upper-right corner of the template list.
183 183  
184 -[[image:Screenshot 2025-12-10 at 19.48.44.png]]
186 +[[image:Screenshot 2025-12-10 at 19.48.44.png||height="402" width="593"]]
185 185  
186 186  Figure 3.1 – Flexible Report Template Management window
187 187  
188 188  After clicking the button [[image:Screenshot 2025-12-10 at 19.48.07.png||height="27" width="29"]] (see Figure 3.1), a download dialog box will open. Enter the template name, type, object, and category in this dialog box. Then, select the template file (Excel file), configure auto generation if needed, select a network resource and/or email address for saving automatically generated reports (see Figure 3.2), and click the button [[image:Screenshot 2025-12-10 at 19.49.45.png||height="23" width="46"]] to complete.
189 189  
190 -[[image:Screenshot 2025-12-10 at 19.50.16.png]]
192 +[[image:Screenshot 2025-12-10 at 19.50.16.png||height="448" width="493"]]
191 191  
192 192  Fig.3.2 – Template upload form
193 193  
... ... @@ -203,7 +203,7 @@
203 203  
204 204  The **“Interactive mode”** button [[image:Screenshot 2025-12-10 at 19.53.19.png||height="28" width="27"]] enables the report mode in the web interface. When interactive mode is enabled, the report opens in the web version of Excel spreadsheets (Fig. 3.3).
205 205  
206 -[[image:Screenshot 2025-12-10 at 19.53.57.png]]
208 +[[image:Screenshot 2025-12-10 at 19.53.57.png||height="527" width="1094"]]
207 207  
208 208  Fig.3.3 – Interactive mode
209 209  
... ... @@ -232,7 +232,7 @@
232 232  
233 233  Next, find the selected object in the User access rights interface (Settings – System – User Access Rights) and use the check marks in the Flexible Reports line to select which roles will have access to the flexible report bound to the object (Fig. 4.1).
234 234  
235 -[[image:Screenshot 2025-12-10 at 20.11.53.png]]
237 +[[image:Screenshot 2025-12-10 at 20.11.53.png||height="437" width="1097"]]
236 236  
237 237  Figure 4.1 – Rights to flexible reports in the user settings
238 238  
... ... @@ -246,7 +246,7 @@
246 246  
247 247  **~1. manually** – by clicking the "Create report" button [[image:Screenshot 2025-12-10 at 20.12.49.png||height="26" width="26"]] in the field of the template in the "Template list". In the pop-up window (see Figure 5.1), enter the report name, select **In a day** or **Per interval** for which the report(s) will be generated, and then click the button [[image:Screenshot 2025-12-10 at 20.13.37.png||height="26" width="62"]] to proceed.
248 248  
249 -[[image:Screenshot 2025-12-10 at 20.14.18.png]]
251 +[[image:Screenshot 2025-12-10 at 20.14.18.png||height="207" width="532"]]
250 250  
251 251  Fig.5.1 – Create report form
252 252  
... ... @@ -265,12 +265,18 @@
265 265  
266 266  Then, click the button [[image:Screenshot 2025-12-10 at 20.17.04.png||height="27" width="55"]] in the Template setup window.
267 267  
268 -[[image:Screenshot 2025-12-10 at 20.17.46.png]]
270 +[[image:Screenshot 2025-12-10 at 20.17.46.png||height="555" width="496"]]
269 269  
270 270  Fig.5.2 – Template setup window
271 271  
274 +[[image:5.3..png||height="493" width="492"]]
275 +
276 +Fig.5.3 – Autogeneration of cron rules
277 +
272 272  To display reports generated using the selected templates on the right side of the screen (Report list), select the templates in the "Template list" by selecting the appropriate checkboxes (see Fig.5.4). Templates can be filtered by name and type.
273 273  
280 +[[image:Screenshot 2025-12-16 183447.png]]
281 +
274 274  The created report can be downloaded [[image:Screenshot 2025-12-10 at 20.19.04.png||height="31" width="29"]] in Excel format or deleted [[image:Screenshot 2025-12-10 at 20.19.29.png||height="32" width="31"]] by marking the unwanted report with a checkmark.
275 275  
276 276  The report created in Excel format is shown in Fig. 5.5. All formulas, charts, and cell formatting specified in the template are preserved in the report file.
... ... @@ -279,4 +279,4 @@
279 279  
280 280  The created version is included in the nested list under the root report (see Fig.5.7). The new version can be renamed, copied, downloaded, uploaded, or deleted regardless of the original report.
281 281  
282 -Report versions can also be created by uploading a previously downloaded and edited Excel file. To do this, click the "Download [[image:Screenshot 2025-12-10 at 20.43.44.png||height="24" width="24"]]" button on the report version, select the file of the downloaded version in the pop-up window, and click the button
290 +Report versions can also be created by uploading a previously downloaded and edited Excel file. To do this, click the "Download [[image:Screenshot 2025-12-10 at 20.43.44.png||height="24" width="24"]]" button on the report version, select the file of the downloaded version in the pop-up window, and click the button [[image:Screenshot 2025-12-10 at 20.44.40.png||height="26" width="47"]]. Reports created by the user can be hidden and published to other users using the "Hide/Publish" button [[image:Screenshot 2025-12-10 at 20.45.11.png||height="34" width="68"]]. Hidden reports are visible only to the user who generated them.
5.3..png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.Lana
Size
... ... @@ -1,0 +1,1 @@
1 +27.5 KB
Content
Screenshot 2025-12-16 183447.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.Lana
Size
... ... @@ -1,0 +1,1 @@
1 +127.4 KB
Content
Screenshot 2025-12-16 183927.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.Lana
Size
... ... @@ -1,0 +1,1 @@
1 +47.7 KB
Content