Differences

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

--- en:v8_0_0:designer:menus:accueil:nouvellerequete:tableaucroise [2020/07/23 10:49]
sylvainair [Pivot Table]
+++ en:v8_0_0:designer:menus:accueil:nouvellerequete:tableaucroise [2020/09/14 15:58] (current)
sylvainair [Save and recall a pivot table/chart]
@@ Line 1: / Line 1: @@
 ====== Pivot Table ======
 {{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200723-102937.png?nolink&500}}
 ===== Usage =====
@@ Line 10: / Line 8: @@
 {{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200723-102832.png?nolink}}
+===== Types of table/chart =====
+A first drop-down list lets you choose the type of table/chart you want to display.
+{{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200723-113946.png?nolink}}
 ==== Table ====
@@ Line 20: / Line 23: @@
 {{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200723-103935.png?nolink&650}}
 ==== Column Heatmap ====
-{{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200723-104006.png&nolink&650}}
+{{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200723-104006.png?nolink&650}}
 ==== Line chart ====
 {{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200723-104506.png?nolink&650}}
@@ Line 29: / Line 32: @@
 ==== Area chart ====
 {{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200723-104720.png?nolink&650}}
-==== Scatter chart ====
 ==== Treemap ====
 {{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200723-104757.png?nolink&650}}
+===== Type of aggregation =====
+{{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200723-110424.png?nolink}}
+This is where you choose the numerical data to be displayed: sum, average, number of records, etc.
+{{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200723-110517.png?nolink}}
+Depending on the type of aggregation chosen, zero, one or two fields can be specified as parameters.\\
+{{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200723-110911.png?nolink}}\\
+{{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200723-110803.png?nolink}}\\
+{{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200723-110834.png?nolink}}\\
+===== Fields area =====
+Regardless of the field area chosen, and as long as you don't have too many different values for this field, you can filter the values to be taken into account here:
+{{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200723-105551.png?nolink}}\\
+==== Page fields ====
+This is the area for fields you don't want to see the details of.\\
+{{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200723-112310.png?nolink}}
+==== Columns fields ====
+This is the area for the fields whose details you want to see in the columns.\\
+{{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200723-112444.png?nolink}}
+==== Columns fields ====
+This is the area for the fields whose details you want to see in the lines.\\
+{{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200723-112652.png?nolink}}
+===== Save and recall a pivot table/chart =====
+At the top left of the screen is the ''Save Current Format'' button.
+You just have to give it a name and define whether it is public or private.
+{{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200723-112856.png?nolink}}
+When a pivot table format exists, a drop-down list allows you to recall a format.
+{{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200723-113202.png?nolink}}
+The edit button allows you to change name and switch the public/private status of the format.
+{{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200723-113518.png?nolink}}
+The last button ({{:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200629-165011.png?nolink}}) lets you to delete a format.

Tools

menus and quick search

quick search

site status

location indicator

Page Tools

meta data for this page

Differences