Difference between revisions of "Cross Table"

From TaticView
Jump to: navigation, search
 
(13 intermediate revisions by 3 users not shown)
Line 1: Line 1:
 +
<languages/>
 +
 +
 
<translate>
 
<translate>
 
<!--T:1-->
 
<!--T:1-->
'''See a [[Tables Tutorial|video tutorial]] about tables'''.
+
[[File:mainmenu5.png]]
 +
'''Watch a [[Tables Tutorial|video tutorial]] about tables'''.
  
  
 
<!--T:2-->
 
<!--T:2-->
A table like object, a collection of columns and rows, that displays data as a crossed view of two text or date columns.
+
A table is like an object, a collection of columns and rows, that displays data as a crossed view of two text or date columns.
  
 
<!--T:3-->
 
<!--T:3-->
The Cross Table object needs two [[Date]] or [[Text]] columns (or one of each) and supports many [[Value]] columns.
+
The Cross Table object needs two [[Dates]] or [[Texts]] columns (or one of each) and supports many [[Value]] columns.
  
 
<!--T:4-->
 
<!--T:4-->
Line 15: Line 19:
  
 
<!--T:5-->
 
<!--T:5-->
In [[Execute a Dashboard|run-time]] cross tables have navigation buttons [[File:table_nav.png|link=]] where you can change pages by clicking the arrows or typing the page number directly in the input box, the option to change the number of rows per page [[File:table_rowspages.png|link=]] and displays information [[File:table_rowspagesinfo.png|link=]] about current and total rows.
+
In [[Execute a Dashboard|run-time]] cross tables have navigation buttons [[File:Tabela Cruzada 1+en-US.PNG]] where you can change pages by clicking the arrows or typing the page number directly in the input box, the option to change the number of rows per page [[File:Tabela Cruzada 2+en-US.PNG]] and to display information [[File:Tabela Cruzada 3+en-US.PNG]] about current and total rows.
  
  
Line 27: Line 31:
  
 
<!--T:8-->
 
<!--T:8-->
[[File:ctable_ex.png|link=]]
+
[[File:Tabela Cruzada 4+en-US.PNG]]
  
 
<!--T:9-->
 
<!--T:9-->
The above example, shows a cross table of ''Group'' (row) by ''Year'' (column) and the summarized ammount of ''Cost'' and ''Profit'' for these crossings.
+
The above example shows a cross table of ''Group'' (row) by ''Year'' (column) and the summarized amount of ''Cost'' and ''Profit'' for these crossings.
  
  
 
<!--T:10-->
 
<!--T:10-->
[[File:ctable_ex2.png|link=]]
+
[[File:Tabela Cruzada 5+en-US.PNG]]
  
 
<!--T:11-->
 
<!--T:11-->
The second example, shows a ''Product by Weekday Gross Sales'' with the option to [[Combo (Filter)|dynamic filter]] the object's data by ''Year'' and ''Month''.
+
The second example shows a ''Product by Weekday Profit'' with the option to [[Combo (Filter)|dynamic filter]] the object's data by ''Year'' and ''Month''.
  
  
Line 44: Line 48:
  
 
<!--T:13-->
 
<!--T:13-->
* [[Advanced row filter]]
 
* [[Column order]]
 
 
* [[Object Filters|Filters]]
 
* [[Object Filters|Filters]]
* [[Row limit]]
+
* [[Conditional Formatting]]
* [[Rows sort]]
+
* [[Rows sort|Rows Sort]]
 +
* [[Column order|Colum Order]]
 +
* [[Total column|Total Column]]
 +
* [[Total row|Total Row]]
 +
* [[Advanced row filter|Advanced Row Filter]]
 +
* [[Row limit|Row Limit]]
 
* [[Show Pager]]
 
* [[Show Pager]]
* [[Total column]]
+
 
* [[Total row]]
+
 
 +
<!--T:20-->
 +
'''Header Properties'''
 +
 
 +
<!--T:21-->
 +
* [[Header Properties]]
  
  
Line 59: Line 71:
 
<!--T:15-->
 
<!--T:15-->
 
* [[Title bar Properties]]
 
* [[Title bar Properties]]
 
 
<!--T:20-->
 
'''Header Properties'''
 
 
<!--T:21-->
 
* [[Header Properties]]
 
  
  
Line 72: Line 77:
  
 
<!--T:17-->
 
<!--T:17-->
* [[Alternate row colors]]
+
* [[Sequence column|Sequence Column]]
* [[Border color]]
+
* [[Alternate row colors|Alternate Row Colors]]
* [[Grid line color]]
+
* [[Hide Border|Show Border]]
* [[Object dimensions]]
+
* [[Border color|Border Color]]
* [[Sequence column]]
+
* [[Grid line color|Grid Line Color]]
* [[Object positions]]
+
* [[Object positions|Object Positions]]
 +
* [[Object dimensions|Object Dimensions]]
  
  
Line 84: Line 90:
  
 
<!--T:19-->
 
<!--T:19-->
* [[Column filters]]
+
''Data Properties''
* [[Column label]]
+
* [[Selected column]]
 
* [[Column name]]
 
* [[Column name]]
* [[Data type]]
+
* [[Data type|Data Type]]
* [[Decimal places]]
+
* [[Column label|Column Label]]
* [[Delete column]]
 
 
* [[Function]]
 
* [[Function]]
 +
* [[Column filters]]
 +
* [[Conditional Formatting]]
 +
* [[Delete column|Remove Column]]
 +
* [[Decimal places|Decimal Places]]
 +
* [[Thousand sep.|Thousand Sep.]]
 
* [[Mask]]
 
* [[Mask]]
* [[Thousand sep.]]
+
 
* [[Column font]]
+
<!--T:22-->
* [[Column font color]]
+
''Styles''
* [[Column font size]]
+
* [[Column width|Column Width]]
* [[Column font style]]
+
* [[Column font|Column Font]]
* [[Column width]]
+
* [[Column font size|Column Font Size]]
* [[Text alignment]]
+
* [[Column background color|Column Background Color]]
 +
* [[Column font color|Column Font Color]]
 +
* [[Column font style|Font Style]]
 +
* [[Text alignment|Text Alignment]]
 
</translate>
 
</translate>

Latest revision as of 02:02, 5 October 2022

Other languages:
English • ‎português do Brasil


Mainmenu5.png Watch a video tutorial about tables.


A table is like an object, a collection of columns and rows, that displays data as a crossed view of two text or date columns.

The Cross Table object needs two Dates or Texts columns (or one of each) and supports many Value columns.

The data displayed in the Cross Table will be a cross of the Data and Text columns with the first column being the row and the second the column. The Value columns will be shown summarized in the center.


In run-time cross tables have navigation buttons Tabela Cruzada 1+en-US.PNG where you can change pages by clicking the arrows or typing the page number directly in the input box, the option to change the number of rows per page Tabela Cruzada 2+en-US.PNG and to display information Tabela Cruzada 3+en-US.PNG about current and total rows.


For simple table options, see Table.


Examples

Tabela Cruzada 4+en-US.PNG

The above example shows a cross table of Group (row) by Year (column) and the summarized amount of Cost and Profit for these crossings.


Tabela Cruzada 5+en-US.PNG

The second example shows a Product by Weekday Profit with the option to dynamic filter the object's data by Year and Month.


Data Properties


Header Properties


Title Bar Properties


Layout Properties


Object Columns Properties

Data Properties

Styles