{"id":7268,"date":"2015-10-27T13:18:24","date_gmt":"2015-10-27T05:18:24","guid":{"rendered":"http:\/\/localhost\/help\/?page_id=7268"},"modified":"2024-04-05T10:40:28","modified_gmt":"2024-04-05T02:40:28","slug":"dataset-tables-4-4-2","status":"publish","type":"page","link":"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/using-the-page-controls\/using-data-tables\/dataset-tables-4-4-2\/","title":{"rendered":"Using Data Tables (4.4.2)"},"content":{"rendered":"

<\/p>\n

This article applies to the Data Table in versions 4.4.2 of P2 Explorer. For the latest help, see Using Data Tables<\/a>.<\/p>\n

Overview<\/span><\/h1>\n

P2 Explorer Data Tables display your data in tabular format (rows and columns). Possible configuration options include grouping your data, setting group aggregates, filtering, sorting, hiding, resizing or pinning columns.<\/p>\n

Your data table may also show totals such as average value, maximimum, count and so on (depending on how it has been pre-configured).<\/p>\n

\"\"<\/p>\n

 <\/p>\n

Data Table Features<\/span><\/h2>\n

Data table features and functionality may vary, depending on how the table is configured.<\/p>\n\n\n\n
\n\n\n\n\n\n\n\n
1. Sort<\/strong>:<\/p>\n

Click a column header<\/strong> to sort in ascending (click once) or descending (click twice) order. Click a third time to unsort.<\/p>\n<\/td>\n<\/tr>\n

2. Filter<\/strong>:<\/p>\n

Type text in the filter edit box<\/strong> below a column header. You can filter on more than one column.<\/p>\n<\/td>\n<\/tr>\n

3. Open column functions menu<\/span><\/strong>:<\/p>\n

Click the down arrow<\/strong> to the right of the column header. Clear all filters, and hide some columns.<\/p>\n<\/td>\n<\/tr>\n

4. Resize column<\/strong>:<\/p>\n

Hover between two column headers, until you see a resize pointer<\/strong>. Then drag to left or right.<\/p>\n<\/td>\n<\/tr>\n

5. Open grid menu<\/span><\/strong>:<\/p>\n

Click the menu button<\/strong> \"\" on the top right of the table. This menu may include the option to group<\/span> this column.<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n

\n\n\n\n\n\n\n
\u00a0<\/td>\n<\/tr>\n
\"\"<\/td>\n<\/tr>\n
 <\/td>\n<\/tr>\n
6. Scroll<\/strong>:<\/p>\n

Scroll horizontally or vertically using the scrollbars<\/strong>.<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Note<\/strong>: Your data table may have a footer<\/strong>, and it may include a column aggregate<\/strong> for various columns (average, minimum, sum, etc.), if so configured.<\/p>\n

Column Functions Menu<\/h3>\n

Click the little arrow next to a column header, to open that column's function menu.<\/p>\n

\"\"<\/p>\n

The Column Functions Menu<\/em> lists various menu items for a column. These depend on how the column was configured in design time, as well as the selections you have already made for this column, or another.<\/p>\n

For example, if you have grouped any column, you will find menu items for aggregating a column's data within the grouping.<\/p>\n

Here are some of the menu items from a column functions menu:<\/p>\n\n\n\n
\n\n\n\n\n\n\n\n
1. Sort<\/strong>:<\/p>\n

Click to sort the column in ascending\/descending order. (You can also click the column header to sort.)<\/p>\n<\/td>\n<\/tr>\n

2. Hide Column<\/strong>:<\/p>\n

Click to hide the column from the dataset table.<\/p>\n<\/td>\n<\/tr>\n

3. Group<\/strong>:<\/p>\n

Click to group the column. Equal values within the column are grouped together. (Note that you can ungroup a grouped column.)<\/p>\n<\/td>\n<\/tr>\n

4. Aggregates<\/strong>:<\/p>\n

Click one of these items, to aggregate column values. Some of the options are: Agg: Count<\/strong>, Agg:Sum<\/strong>, Agg:Avg<\/strong>. Apart from Agg: Count<\/em>, you should limit aggregation to numerical columns.<\/p>\n<\/td>\n<\/tr>\n

5. Pin<\/strong>:<\/p>\n

Click Pin Left<\/strong> or Pin Right<\/strong> to pin a column to the left or right of a table, fixing it in position when you use the horizontal scrollbar.<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n

\"\"<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Grid Menu<\/h3>\n

The Grid Menu<\/em> allows you to hide columns from the data table (or show hidden columns), as well as clear all column filters; it is only available if your data table has been configured to show it.<\/p>\n\n\n\n
\n\n\n\n\n\n\n
1. Open grid menu<\/strong>:<\/p>\n

Click the little button \"\" on the far right of the dataset table, to open the grid menu.<\/p>\n<\/td>\n<\/tr>\n

2. Clear all filters<\/strong>:<\/p>\n

Any filters you have applied to columns will be cleared.<\/p>\n<\/td>\n<\/tr>\n

3. Show\/Hide column<\/strong>:<\/p>\n

Hover over a column header name in the list, then click to hide that column from the dataset table (a hidden column is preceded by a cross \"\"). Click again to show the column again (a visible column is preceded by a tick\/check \"\").<\/p>\n<\/td>\n<\/tr>\n

4. Close<\/strong>:<\/p>\n

Click to close the Grid Menu.<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n

\"\"<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Grouping in a Data Table<\/h3>\n

The data table may be configured to enable grouping.<\/p>\n\n\n\n
\n\n\n\n\n
1. Group by a Column<\/strong>:<\/p>\n

Click the down arrow<\/strong> to the right of the column header to open the Column Functions Menu<\/span>, then select the Group<\/em> menu item. The grouped column moves to the leftmost side of the table.<\/p>\n

Note<\/em>: You can group more than one column.<\/p>\n<\/td>\n<\/tr>\n

2. Set a Group Aggregate<\/strong>:<\/p>\n

Click the down arrow<\/strong> to the right of the column header to open the Column Functions Menu, then select the Agg: Avg<\/em> menu item. An average value for this column is displayed in each grouping.<\/p>\n

Note<\/em>: To remove a group aggregate for a column, select a different group aggregate, or select the Agg: Remove<\/em> menu item.<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n

\n\n\n\n\n\n
\"\"<\/a><\/td>\n<\/tr>\n
3. Expand\/Collapse Grouping<\/strong>:<\/p>\n

Click the plus button<\/strong> \"\"<\/a> to the left of the grouping to expand that group, and click the minus button<\/strong> \"\"<\/a> to collapse it again. The expanded group reveals the usual table rows, only for that group.<\/p>\n

Note<\/em>: You can expand more than one grouped row.<\/p>\n<\/td>\n<\/tr>\n

Footer<\/strong>: Your data table footer shows the total number of rows, as well as the number on display in their groupings.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Data Table Demo<\/span><\/h2>\n

Watch the video below to see how to manipulate a data table.<\/p>\n\r\n\t\r\n\t

The P2 Explorer Data Table displays your data in tabular format (rows and columns).
\nPossible configuration options include: grouping your data, setting group aggregates, filtering, sorting, hiding, resizing or pinning columns to left or right for more effective scrolling.<\/p>\n

Read more<\/i><\/a><\/p>\n","protected":false},"author":8,"featured_media":7612,"parent":23241,"menu_order":3,"comment_status":"open","ping_status":"closed","template":"","meta":{"footnotes":"","_members_access_role":[],"_members_access_error":""},"categories":[4],"tags":[113],"class_list":["post-7268","page","type-page","status-publish","has-post-thumbnail","hentry","category-explainer","tag-tables","Product-ex"],"_links":{"self":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/7268","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/comments?post=7268"}],"version-history":[{"count":1,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/7268\/revisions"}],"predecessor-version":[{"id":66449,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/7268\/revisions\/66449"}],"up":[{"embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/23241"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/media\/7612"}],"wp:attachment":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/media?parent=7268"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/categories?post=7268"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/tags?post=7268"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}