Difference between revisions of "Table"
(Marked this version for translation) |
|||
| Line 1: | Line 1: | ||
<translate> | <translate> | ||
| + | <!--T:1--> | ||
'''See a [[Tables Tutorial|video tutorial]] about tables'''. | '''See a [[Tables Tutorial|video tutorial]] about tables'''. | ||
| + | <!--T:2--> | ||
A table like object, a collection of columns and rows, that displays data. | A table like 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. | ||
| + | <!--T:5--> | ||
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 displays information [[File:table_rowspagesinfo.png|link=]] about current and total rows. | 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 displays 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=]] | ||
| + | <!--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. | 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=]] | ||
| + | <!--T:11--> | ||
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. | 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:12--> | ||
'''Data Properties''' | '''Data Properties''' | ||
| + | <!--T:13--> | ||
* [[Advanced row filter]] | * [[Advanced row filter]] | ||
* [[Column order]] | * [[Column order]] | ||
| Line 38: | Line 51: | ||
| + | <!--T:14--> | ||
'''Title Bar Properties''' | '''Title Bar Properties''' | ||
| + | <!--T:15--> | ||
* [[Title bar Properties]] | * [[Title bar Properties]] | ||
| + | <!--T:16--> | ||
'''Layout Properties''' | '''Layout Properties''' | ||
| + | <!--T:17--> | ||
* [[Alternate row colors]] | * [[Alternate row colors]] | ||
* [[Grid line color]] | * [[Grid line color]] | ||
| Line 52: | Line 69: | ||
| + | <!--T:18--> | ||
'''Object Columns Properties''' | '''Object Columns Properties''' | ||
| + | <!--T:19--> | ||
* [[Column filters]] | * [[Column filters]] | ||
* [[Column label]] | * [[Column label]] | ||
Revision as of 13:47, 2 April 2014
See a video tutorial about tables.
A table like 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 
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 
and displays information 
about current and total rows.
For crossed data features in tables, see Cross Table.
Examples
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.
In this other example, using modified Layout Properties, a filtered column that displays only the Pizza Product Profit and a expression to calculate the Pizza Profit percentage participation.
Data Properties
Title Bar Properties
Layout Properties
Object Columns Properties
