Changes

Jump to: navigation, search

Table

1,433 bytes added, 02:02, 5 October 2022
no edit summary
A table like object, a collection of columns and rows, that displays data.<languages/>
You can add to a table object any number of [[Date]], [[Text]] and [[Value]] columns needed.
By default, the data displayed in the table will be grouped by the Data and Text columns and Value columns will be summarized<translate><!--T:1-->[[File:mainmenu5.png]]'''Watch a [[Tables Tutorial|video tutorial]] about tables'''.
For crossed <!--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. <!--T:4-->By default, the data features displayed in the table will be grouped by the Data and Text columns and Value columns will be summarized.  <!--T:5-->In [[Execute a Dashboard|run-time]], tableshave 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, see the option to change the number of rows per page [[File:table_rowspages.png|link=]] and to display information [[Cross TableFile:table_rowspagesinfo.png|link=]]about current and total rows.
<!--T:6-->
For crossed data features in tables, see [[Cross Table]].
'''Example'''
<!--T:7-->
'''Examples'''
<!--T:8-->
[[File:table_ex.png|link=]]
<!--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=]]
Other <!--T:11-->In this other example, using modified [[Layout Properties]], a [[Column filters|filtered column]] that displays only the ''Pizza Product Profit'' and a an [[Special#Expression|expression]] to calculate the ''Pizza Profit'' percentage participation.
<!--T:12-->
'''Data Properties'''
<!--T:13-->* [[Object Filters|Filters]]* [[Advanced row filterConditional Formatting]]* [[Rows sort|Rows Sort]]* [[Column order|Colum Order]]* [[Drill Down]]* [[Total row|Total Row]]* [[FiltersAdvanced row filter|Advanced Row Filter]]* [[Row limit|Row Limit]]* [[Rows sortShow Pager]]  <!--T:20-->'''Header Properties''' <!--T:21-->* [[Total rowHeader Properties]]
<!--T:14-->
'''Title Bar Properties'''
<!--T:15-->
* [[Title bar Properties]]
<!--T:16-->
'''Layout Properties'''
<!--T:17-->* [[Frozen Column]]* [[Sequence column|Sequence Column]]* [[Alternate row colors|Alternate Row Colors]]* [[Grid line colorHide Border|Show Border]]* [[Object dimensionsBorder color|Border Color]]* [[Sequence columnGrid line color|Grid Line Color]]* [[X positionObject positions|Object Positions]]* [[Y positionObject dimensions|Object Dimensions]]
<!--T:18-->
'''Object Columns Properties'''
* [[Column filters]]<!--T:19-->''Data Properties''* [[Column labelSelected column]]
* [[Column name]]
* [[Data type|Data Type]]* [[Decimal places]]* [[Delete columnColumn label|Column Label]]
* [[Function]]
* [[Column filters]]
* [[Conditional Formatting]]
* [[Delete column|Remove Column]]
* [[Decimal places|Decimal Places]]
* [[Thousand sep.|Thousand Sep.]]
* [[Mask]]
 <!--T:22-->''Styles''* [[Thousand sep.Column width|Column Width]]* [[Column font|Column Font]]* [[Column font colorsize|Column Font Size]]* [[Column font sizebackground color|Column Background Color]]* [[Column font stylecolor|Column Font Color]]* [[Column widthfont style|Font Style]]* [[Text alignment|Text Alignment]]</translate>

Navigation menu