Difference between revisions of "Table"

From TaticView
Jump to: navigation, search
 
(20 intermediate revisions by 3 users not shown)
Line 1: Line 1:
A table like object, a collection of columns and rows, that displays data.
+
<languages/>
  
 +
 +
<translate>
 +
<!--T:1-->
 +
[[File:mainmenu5.png]]
 +
'''Watch a [[Tables Tutorial|video tutorial]] about tables'''.
 +
 +
 +
<!--T:2-->
 +
A table is like an object, a collection of columns and rows, that displays data.
 +
 +
<!--T:3-->
 
You can add to a table object any number of [[Date]], [[Text]], [[Value]] and [[Special]] columns desired.
 
You can add to a table object any number of [[Date]], [[Text]], [[Value]] and [[Special]] columns desired.
  
 +
<!--T:4-->
 
By default, the data displayed in the table will be grouped by the Data and Text columns and Value columns will be summarized.
 
By default, the data displayed in the table will be grouped by the Data and Text columns and Value columns will be summarized.
  
  
In [[Execute a Dashboard|run-time]], 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 display information about rows and pages [[File:table_rowspagesinfo.png|link=]].
+
<!--T:5-->
 +
In [[Execute a Dashboard|run-time]], tables have navigation buttons [[File:table_nav.png|link=]] where you can change pages by clicking on 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 to display information [[File:table_rowspagesinfo.png|link=]] about current and total rows.
  
  
 +
<!--T:6-->
 
For crossed data features in tables, see [[Cross Table]].
 
For crossed data features in tables, see [[Cross Table]].
  
  
 +
<!--T:7-->
 
'''Examples'''
 
'''Examples'''
  
 +
<!--T:8-->
 
[[File:table_ex.png|link=]]
 
[[File:table_ex.png|link=]]
  
The above example, shows a table grouped by the ''Year'' and ''State'' columns (two first columns) and the summarized amount of ''Gross Sales'' and ''Net Revenue'' for these groups.
+
<!--T:9-->
 +
The above example shows a table grouped by the ''Year'' and ''State'' columns (two first columns) and the summarized amount of ''Gross Sales'' and ''Net Revenue'' for these groups.
  
  
 +
<!--T:10-->
 
[[File:table_ex2.png|link=]]
 
[[File:table_ex2.png|link=]]
  
In this other example, using modified [[Layout Properties]], a [[Column filters|filtered column]] that displays only the ''Pizza Product Profit'' and a [[Special#Expression|expression]] to calculate the ''Pizza Profit'' percentage participation.
+
<!--T:11-->
 +
In this other example, using modified [[Layout Properties]], a [[Column filters|filtered column]] that displays only the ''Pizza Product Profit'' and an [[Special#Expression|expression]] to calculate the ''Pizza Profit'' percentage participation.
  
  
 +
<!--T:12-->
 
'''Data Properties'''
 
'''Data Properties'''
  
* [[Advanced row filter]]
+
<!--T:13-->
* [[Column order]]
 
 
* [[Object Filters|Filters]]
 
* [[Object Filters|Filters]]
* [[Row limit]]
+
* [[Conditional Formatting]]
* [[Rows sort]]
+
* [[Rows sort|Rows Sort]]
* [[Total row]]
+
* [[Column order|Colum Order]]
 +
* [[Drill Down]]
 +
* [[Total row|Total Row]]
 +
* [[Advanced row filter|Advanced Row Filter]]
 +
* [[Row limit|Row Limit]]
 +
* [[Show Pager]]
 +
 
 +
 
 +
<!--T:20-->
 +
'''Header Properties'''
  
 +
<!--T:21-->
 +
* [[Header Properties]]
  
 +
 +
<!--T:14-->
 
'''Title Bar Properties'''
 
'''Title Bar Properties'''
  
 +
<!--T:15-->
 
* [[Title bar Properties]]
 
* [[Title bar Properties]]
  
  
 +
<!--T:16-->
 
'''Layout Properties'''
 
'''Layout Properties'''
  
* [[Alternate row colors]]
+
<!--T:17-->
* [[Grid line color]]
+
* [[Frozen Column]]
* [[Object dimensions]]
+
* [[Sequence column|Sequence Column]]
* [[Sequence column]]
+
* [[Alternate row colors|Alternate Row Colors]]
* [[X position]]
+
* [[Hide Border|Show Border]]
* [[Y position]]
+
* [[Border color|Border Color]]
 +
* [[Grid line color|Grid Line Color]]
 +
* [[Object positions|Object Positions]]
 +
* [[Object dimensions|Object Dimensions]]
  
  
 +
<!--T:18-->
 
'''Object Columns Properties'''
 
'''Object Columns Properties'''
  
* [[Column filters]]
+
<!--T:19-->
* [[Column label]]
+
''Data Properties''
 +
* [[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>

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.

You can add to a table object any number of Date, Text, Value and Special columns desired.

By default, the data displayed in the table will be grouped by the Data and Text columns and Value columns will be summarized.


In run-time, tables have navigation buttons Table nav.png where you can change pages by clicking on the arrows or typing the page number directly in the input box, the option to change the number of rows per page Table rowspages.png and to display information Table rowspagesinfo.png about current and total rows.


For crossed data features in tables, see Cross Table.


Examples

Table ex.png

The above example shows a table grouped by the Year and State columns (two first columns) and the summarized amount of Gross Sales and Net Revenue for these groups.


Table ex2.png

In this other example, using modified Layout Properties, a filtered column that displays only the Pizza Product Profit and an expression to calculate the Pizza Profit percentage participation.


Data Properties


Header Properties


Title Bar Properties


Layout Properties


Object Columns Properties

Data Properties

Styles