Changes

Jump to: navigation, search

Table

1,938 bytes added, 02:02, 5 October 2022
no edit summary
Implements 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 Sum<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 features in tables, see [[Cross Table]].
<!--T:3-->
You can add to a table object any number of [[Date]], [[Text]], [[Value]] and [[Special]] columns desired.
[[File<!--T:table_ex4-->By default, the data displayed in the table will be grouped by the Data and Text columns and Value columns will be summarized.png]]
'''Data Properties'''<!--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.
[[Advanced row filter]]
<!--T:6-->For crossed data features in tables, see [[Column orderCross Table]].
[[Filters]]
[[Row limit]]<!--T:7-->'''Examples'''
<!--T:8-->[[Rows sortFile:table_ex.png|link=]]
[[Total row]]<!--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.
'''Title Bar Properties'''<!--T:10-->[[File:table_ex2.png|link=]]
<!--T:11-->In this other example, using modified [[Title bar 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-->'''Layout Data Properties'''
<!--T:13-->* [[Alternate Object Filters|Filters]]* [[Conditional Formatting]]* [[Rows sort|Rows Sort]]* [[Column order|Colum Order]]* [[Drill Down]]* [[Total row|Total Row]]* [[Advanced row colorsfilter|Advanced Row Filter]]* [[Row limit|Row Limit]]* [[Show Pager]]
[[Grid line color]]
[[Object dimensions]]<!--T:20-->'''Header Properties'''
<!--T:21-->* [[Sequence columnHeader Properties]]
[[X position]]
[[Y position]]<!--T:14-->'''Title Bar Properties'''
<!--T:15-->
* [[Title bar Properties]]
'''Object Columns Properties'''
[[Column filters]]<!--T:16-->'''Layout Properties'''
<!--T:17-->* [[Frozen Column label]]* [[Sequence column|Sequence Column]]* [[Alternate row colors|Alternate Row Colors]]* [[Hide Border|Show Border]]* [[Border color|Border Color]]* [[Grid line color|Grid Line Color]]* [[Object positions|Object Positions]]* [[Object dimensions|Object Dimensions]]
[[Column name]]
[[Data type]]<!--T:18--> [[Decimal places]] [[Delete column]] [[Function]] [[Mask]] [[Thousand sep.]] [[Column font]] [[Column font color]] [[Column font size]] [[Column font style]]'''Object Columns Properties'''
<!--T:19-->''Data Properties''* [[Selected column]]* [[Column name]]* [[Data type|Data Type]]* [[Column label|Column Label]]* [[Function]]* [[Column filters]]* [[Conditional Formatting]]* [[Delete column|Remove Column width]]* [[Decimal places|Decimal Places]]* [[Thousand sep.|Thousand Sep.]]* [[Mask]]
<!--T:22-->''Styles''* [[Column width|Column Width]]* [[Column font|Column Font]]* [[Column font size|Column Font Size]]* [[Column background color|Column Background Color]]* [[Column font color|Column Font Color]]* [[Column font style|Font Style]]* [[Text alignment|Text Alignment]]</translate>

Navigation menu