Differences

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

--- en:v8_0_0:web:menus:executionderequete:start [2020/07/06 15:24]
jacobt ↷ Page déplacée de en:v8_0_0:web:menus:runningqueries:start à en:v8_0_0:web:menus:executionderequete:start
+++ en:v8_0_0:web:menus:executionderequete:start [2020/10/14 10:04] (current)
sylvainair [Running Queries]
@@ Line 1: / Line 1: @@
 ====== Running Queries ======
 There are several steps to run a query:
   * Data selection.
   * Format selection.
@@ Line 59: / Line 57: @@
 The user will fill in the tab ''HEADER'', the title, description, level of visibility, and the refresh time. The parameters of the tab ''CONTENT'' will be displayed according to the type of result desired.
-{{:en:v8_0_0:web:menus:runningqueries:pasted:20200706-150617.png?nolink&500}}{{:en:v8_0_0:web:menus:runningqueries:pasted:20200706-150653.png?nolink&500}}
+{{:en:v8_0_0:web:menus:runningqueries:pasted:20200706-150617.png?nolink&600}}{{:en:v8_0_0:web:menus:runningqueries:pasted:20200706-150653.png?nolink&600}}
@@ Line 79: / Line 77: @@
   * **Export**: Exports data in formats (excel, text, or homepage indicator).
 {{:en:v8_0_0:web:menus:runningqueries:pasted:20200706-151610.png?nolink&600}}{{:en:v8_0_0:web:menus:runningqueries:pasted:20200706-151650.png?nolink&600}}
+=== Dynamic charts ===
+Among these modifications, it is possible to generate a dynamic chart.
+{{:en:v8_0_0:web:menus:executionderequete:pasted:20200708-110110.png?nolink&500}}
+{{:en:v8_0_0:web:menus:executionderequete:pasted:20200708-110226.png?nolink&500}}
+<font 14px/inherit;;inherit;;inherit>**Options in the table:**</font>
+  * Free selection of columns.
+  * Choice of the type of calculation.
+  * Choice of the type of restitution.
+  * Possibility to filter the desired values by fields.
+{{{:v8_0_0:web:menus:executionderequete:pasted:20200702-154638.png?nolink&600}}}
+== Calculation Type: ==
+  * Count: Counts the number of lines in a group.
+  * Count unique value: Counts the number of rows with different values for the specified field in a group.
+  * List unique Value: Displays the list of values for the specified field in the group without duplicates.
+  * Sum: Sum the values of the specified field for all rows in the group.
+  * Integer sum: Same as above, but displays a value rounded to an integer.
+  * Average: Averages the values of the specified field for each group.
+  * Minimum: Displays the minimum value of the specified field for each group.
+  * Maximum: Displays for each group the maximum value of the specified field.
+  * Sum over sum: For each group calculates the sum of each specified field, then performs the following ratio: "fields_1" / "fields_2".
+  * 80% Upper/Lower bound: Displays the maximum or minimum value of the 80% confidence interval.
+  * Sum as a fraction of Total: For each group makes the sum of the specified field values, then determines the percentage of this value compared to the table total, row total, or column total.
+  * Number in fraction of Row: For each group counts the number of rows, then determines the percentage of this value in relation to the total number of rows in the table, row, or column.
+== Return ==
+__Table__
+  * Standard return.
+  * Choice of fields to compose the table freely.
+{{:v8_0_0:web:menus:executionderequete:pasted:20200702-155626.png?nolink&650}}
+__Table barchart__
+  * Fills the background of the cell with a bar representing the contribution of this value in the row total.
+  * Choice of fields to compose the table freely.
+{{{:v8_0_0:web:menus:executionderequete:pasted:20200702-155736.png?nolink&650}}}
+__Heatmap__
+  * Fills the background of the cell with a more or less strong shade of red depending on the contribution of the value in the total.
+  * The total taken into account may be the total of the table, the row or the column.
+  * Choice of fields to compose the table freely.
+{{:v8_0_0:web:menus:executionderequete:pasted:20200702-155826.png?nolink&650}}}
+__Curve__
+  * Choice of fields to freely compose the curve.
+  * If intermediate points are missing, they are not extrapolated, leaving unconnected points.
+{{:v8_0_0:web:menus:executionderequete:pasted:20200702-160003.png?nolink&650}}
+__Zone__
+  * Same as the curve but the area between the curve and the smallest value is colored.
+{{:v8_0_0:web:menus:executionderequete:pasted:20200702-160113.png?nolink&650}}
+__Bar chart__
+  * Choice of fields to compose the graph freely.
+  * Colors and legend are done automatically.
+{{:v8_0_0:web:menus:executionderequete:pasted:20200702-160214.png?nolink&650}}
+__Stacked bar__
+  * Same principle as bar rendering except that the values of the different groups are not shown side by side but are cumulative.
+{{:v8_0_0:web:menus:executionderequete:pasted:20200702-160423.png?nolink&650}}
+__Treemap__
+  * Choice of fields only in the header column of the dynamic table.
+  * The surface area of the elements is proportional to the ratio of their value on the total of the dynamic table.
+{{:v8_0_0:web:menus:executionderequete:pasted:20200702-160540.png?nolink&650}}}
+__Scatter__
+  * Displays a point if a value exists in the data for a key corresponding to the torque (ordinate axis value, abscissa axis value).
+  * The type of calculation performed does not change the position of the points, but it does change the value indicated in the tooltip when passing over a point.
+{{{:v8_0_0:web:menus:executionderequete:pasted:20200702-160702.png?nolink&650}}}

Tools

menus and quick search

quick search

site status

location indicator

Page Tools

meta data for this page

Differences