The design of a Table widget is illustrated in steps with an example.
Let us consider the example where the ‘PinnacleTransactions’ data model is used to create a Table widget. In the first instance of the design page, all the rows and tables available in the data model are displayed on the design page as shown very similar in presentation to a spreadsheet that has multiple columns and rows.
From this overall view of the data model choose which columns you wish to specifically display in the Table widget of your report. To do so, right click on a column. You will be provided with a list of options – one of the options is to hide/unhide the column. De-Select all the columns that you do not want displayed in the Table. Once you hit OK, you will only see the columns selected by you in the Hide/Unhide menu.
Once you have chosen which columns you wish to display in your report, you may choose to group your data based on column values. By right clicking on a specific column, you can also apply summary functions on your data. If the column contains numeric data, you will have the choice to compute the Sum, Minimum, Maximum, Average and Count.
For example in the image below, data in the table above is grouped into ‘Customer Country’ and the ‘Revenue’ is summed per country as illustrated in next image.
Right clicking on any of the columns in the Table displays the list of operations possible on the field.
Expand All |
Expands all the grouped rows and shows each individual data row in each group/sub group. |
Collapse All |
Collapses the grouped rows and shows only the computed values under each group. In the example illustration above, the rows have been collapsed. |
Sum |
Computes the sum of all the values in that data column which fall within the group. |
Minimum |
Displays the minimum value of all the values in that data column which fall within the group. |
Maximum |
Displays the maximum value of all the values in that data column which fall within the group |
Average |
Computes the average of all the values in that data column which fall within the group |
Count |
Counts number of values in that data column which fall within the group |
Alignment |
You can choose to align text in this field either to the left, centre or to the right of the cell. |
Wrap Text |
You may choose to wrap text in this cell when necessary. |
Hide |
Do not display this column. |
Hide/Unhide |
Clicking on this option displays list of all columns available in the data set. You may choose from this list which columns you wish to hide or unhide by checking on the respective boxes. |
<<Create Table Widget - Define Data Set page | Create Table Widget - Save Widget>>