11,677
edits
Changes
Updating to match new version of source page
[[File:mainmenu5.png]]'''Watch a [[Tables Tutorial|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.
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 displays to display information [[File:table_rowspagesinfo.png|link=]] about current and total rows.
[[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.
[[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 an [[Special#Expression|expression]] to calculate the ''Pizza Profit'' percentage participation.
'''Data Properties'''
* [[Object Filters|Filters]]
* [[Row limitConditional Formatting]]* [[Rows sort|Rows Sort]]* [[Column order|Colum Order]]* [[Drill Down]]* [[Total row|Total Row]]* [[Advanced rowfilter|Advanced Row Filter]]* [[Row limit|Row Limit]]* [[Show Pager]] '''Header Properties''' * [[Header Properties]]
'''Layout Properties'''
* [[Frozen Column]]* [[Sequence column|Sequence Column]]* [[Alternate row colors|Alternate Row Colors]]* [[Hide Border|Show Border]]* [[Grid line Border color|Border Color]]* [[Object dimensionsGrid line color|Grid Line Color]]* [[Sequence columnObject positions|Object Positions]]* [[Object positionsdimensions|Object Dimensions]]
'''Object Columns Properties'''
* [[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]]
''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]]