{"id":20506,"date":"2016-10-11T12:33:28","date_gmt":"2016-10-11T04:33:28","guid":{"rendered":"http:\/\/localhost\/help\/?page_id=20506"},"modified":"2018-01-16T10:17:12","modified_gmt":"2018-01-16T02:17:12","slug":"table-layout-4-4-1","status":"publish","type":"page","link":"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/explorer-studio\/controls\/table-layout\/table-layout-4-4-1\/","title":{"rendered":"Table Layout (4.4.1)"},"content":{"rendered":"\n<p class=\"left-bar\">This article applies to versions 4.4.1 and later of P2 Explorer. For help on the latest version, see <a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/explorer-studio\/controls\/table-layout\/\">Table layout<\/a>.<\/p>\n<p class=\"overview\">The Table Layout is a component that arranges your data in a tabular format. You only need to configure the first row on the table and that will be repeated across each row in your dataset.<\/p>\n<p class=\"intro-text\">The Table Layout content isn\u2019t restricted to its selected data; you can add other components to the layout, and configure them to use contextual data by row. For example, if your table layout's data contains production figures for a group of entities, you can add a chart to the layout (formatted as a sparkline), which shows a trend of production data for the entity in its row, as covered in <a href=\"#Tutorial_2_Sparkline_on_a_Table_Layout\">Tutorial 2<\/a>.<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Example-of-a-Table-Layout-2.png\" rel=\"lightbox-0\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-20553 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Example-of-a-Table-Layout-2.png\" width=\"494\" height=\"191\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Example-of-a-Table-Layout-2.png 494w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Example-of-a-Table-Layout-2-150x58.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Example-of-a-Table-Layout-2-24x9.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Example-of-a-Table-Layout-2-36x14.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Example-of-a-Table-Layout-2-48x19.png 48w\" sizes=\"auto, (max-width: 494px) 100vw, 494px\" \/><\/a><\/p>\n<table style=\"width: 700px; border: 1px solid #cccccc;\">\n<tbody>\n<tr>\n<td style=\"width: 40%; padding-left: 10px; border-right: 1px solid #cccccc;\">\n<p>Examples of components you can add to a table layout:<\/p>\n<\/td>\n<td style=\"width: 60%; padding-left: 10px;\">\n<p>Example of a table layout that includes an image component:<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 35%; padding-left: 10px; border-right: 1px solid #cccccc;\">\n<ul class=\"intro-text\">\n<li><a title=\"Chart Tutorial\" href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/explorer-studio\/controls\/charts\/\">Chart<\/a><\/li>\n<li><a title=\"Data Label Tutorial\" href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/explorer-studio\/controls\/data-label\/\">Data Label<\/a><\/li>\n<li><a title=\"Text Label Tutorial\" href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/explorer-studio\/controls\/text-label\/\">Text Label<\/a><\/li>\n<li><a title=\"Hyperlink Tutorial\" href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/explorer-studio\/controls\/hyperlink\/\">Hyperlink<\/a><\/li>\n<li><a title=\"Status Indicator Tutorial\" href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/explorer-studio\/controls\/status-indicator\/\">Status Indicator<\/a><\/li>\n<li><a title=\"Image Tutorial\" href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/explorer-studio\/controls\/image\/\">Image<\/a><\/li>\n<li><a title=\"Target Variance Bar Tutorial\" href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/explorer-studio\/controls\/target-variance-bar\/\">Target Variance Bar<\/a><\/li>\n<li><a title=\"Bullet Graph\" href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/explorer-studio\/controls\/bullet-graph\/\">Bullet Graph<\/a><\/li>\n<\/ul>\n<\/td>\n<td>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Image-in-a-Table-Layout.png\" rel=\"lightbox-1\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-20563 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Image-in-a-Table-Layout.png\" width=\"439\" height=\"188\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Image-in-a-Table-Layout.png 439w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Image-in-a-Table-Layout-150x64.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Image-in-a-Table-Layout-24x10.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Image-in-a-Table-Layout-36x15.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Image-in-a-Table-Layout-48x21.png 48w\" sizes=\"auto, (max-width: 439px) 100vw, 439px\" \/><\/a><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<hr \/>\n<h2 class=\"page-subheading\">Overview<\/h2>\n<p class=\"no-toc-heading\">The Table Layout<\/p>\n<p class=\"intro-text\">Below is an example of a configured table layout, in design mode:<\/p>\n<p class=\"intro-text\"><strong>1.<\/strong> The Table Layout's data determines the rows and the contextual data. When you assign this data, the first five columns are added automatically.<\/p>\n<p class=\"intro-text\"><strong>2.<\/strong> Choose general appearance here: highlighting and showing\/hiding headers.<\/p>\n<p class=\"intro-text\"><strong>3.<\/strong> The automatically added columns. You can update these.<\/p>\n<p class=\"intro-text\"><strong>4.<\/strong> The final column has been manually added, and a Chart component placed on the column. You cannot see the chart here, as it is a separate component that has been placed on top of the column.<\/p>\n<p class=\"intro-text\"><strong>5.<\/strong> A style has been applied to the table, with rows wide enough to accommodate the chart\/Sparkline.<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Table-Layout-Overview-3-1.png\" rel=\"lightbox-2\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-20882 size-full\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Table-Layout-Overview-3-1.png\" width=\"1034\" height=\"479\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Table-Layout-Overview-3-1.png 1034w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Table-Layout-Overview-3-1-768x356.png 768w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Table-Layout-Overview-3-1-150x69.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Table-Layout-Overview-3-1-24x11.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Table-Layout-Overview-3-1-36x17.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Table-Layout-Overview-3-1-48x22.png 48w\" sizes=\"auto, (max-width: 1034px) 100vw, 1034px\" \/><\/a><\/p>\n<p class=\"no-toc-heading\">Columns on the Table Layout<\/p>\n<p class=\"left-bar\">Click on a column to see what component is there.<\/p>\n<p class=\"intro-text\"><strong>6. <\/strong> Columns that are added automatically use a Text Label component.<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Table-Layout-Overview-5-2.png\" rel=\"lightbox-3\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-20885 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Table-Layout-Overview-5-2.png\" width=\"1053\" height=\"340\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Table-Layout-Overview-5-2.png 1053w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Table-Layout-Overview-5-2-768x248.png 768w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Table-Layout-Overview-5-2-150x48.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Table-Layout-Overview-5-2-24x8.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Table-Layout-Overview-5-2-36x12.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Table-Layout-Overview-5-2-48x15.png 48w\" sizes=\"auto, (max-width: 1053px) 100vw, 1053px\" \/><\/a><\/p>\n<p class=\"intro-text\"><strong>7. <\/strong> This manually added column has had a Chart component added.<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Table-Layout-Overview-6-2.png\" rel=\"lightbox-4\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-20886 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Table-Layout-Overview-6-2.png\" width=\"1055\" height=\"357\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Table-Layout-Overview-6-2.png 1055w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Table-Layout-Overview-6-2-768x260.png 768w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Table-Layout-Overview-6-2-150x51.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Table-Layout-Overview-6-2-24x8.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Table-Layout-Overview-6-2-36x12.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Table-Layout-Overview-6-2-48x16.png 48w\" sizes=\"auto, (max-width: 1055px) 100vw, 1055px\" \/><\/a><\/p>\n<hr \/>\n<h2 class=\"page-subheading\">Working with the Table Layout and its Columns<\/h2>\n<p class=\"instruct\">To set up a Table Layout, choose data. Then, configure the columns and add new ones.<\/p>\n<h3>Accessing the Table Layout<\/h3>\n<p class=\"intro-text\">To configure the Table Layout, you first need to select the component. Because the Table Layout is overlaid with components, you can either access it by clicking on an empty column, or use the right-click menu.<\/p>\n<p class=\"intro-text\">1. Right-click on any component on the Table Layout to open the pop-up menu.<\/p>\n<p class=\"intro-text\">2. Click the <strong>Table Layout<\/strong> item, which is second on the list.<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Access-the-Table-Layout.png\" rel=\"lightbox-5\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-20623 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Access-the-Table-Layout.png\" width=\"256\" height=\"151\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Access-the-Table-Layout.png 256w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Access-the-Table-Layout-150x88.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Access-the-Table-Layout-24x14.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Access-the-Table-Layout-36x21.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Access-the-Table-Layout-48x28.png 48w\" sizes=\"auto, (max-width: 256px) 100vw, 256px\" \/><\/a><\/p>\n<p class=\"intro-text\">Now that you have selected the Table Layout, you can reposition it, resize it, and configure it.<\/p>\n<h3>Adding the Data<\/h3>\n<p class=\"intro-text\">There are four data categories to choose from. See: <a title=\"Setting up data for the Table Layout\" href=\"#Setting_up_Data_for_the_Table_Layout\">Setting up data for the Table Layout<\/a>.<\/p>\n<ul class=\"intro-text\">\n<li>Dataset Query<\/li>\n<li>Ad hoc Calculations<\/li>\n<li>Attributes<\/li>\n<li>Tags<\/li>\n<\/ul>\n<h3>Adding and Removing Columns<\/h3>\n<p class=\"intro-text\"><strong>To add a column:<\/strong> Click <strong>Add <\/strong>to add a column, then type in a <em>Header <\/em>and optionally adjust the <em>Width.<\/em><\/p>\n<p class=\"intro-text\"><strong>To remove a column:<\/strong> Click the <strong>Remove<\/strong> button alongside the column.<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Add-and-remove-columns.png\" rel=\"lightbox-6\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-20625 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Add-and-remove-columns.png\" width=\"338\" height=\"233\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Add-and-remove-columns.png 338w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Add-and-remove-columns-150x103.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Add-and-remove-columns-24x17.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Add-and-remove-columns-36x25.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Add-and-remove-columns-48x33.png 48w\" sizes=\"auto, (max-width: 338px) 100vw, 338px\" \/><\/a><\/p>\n<h3>Configuring Columns<\/h3>\n<p class=\"intro-text\"><strong>Header:<\/strong> Edit a header by typing over it, or type in a header for a new column.<\/p>\n<p class=\"intro-text\"><strong>Width:<\/strong> Each new column has an asterisk <strong>*<\/strong> as its default width. All columns that use this asterisk for their width have an equal portion of their collective width. Columns that have a number (for example, 100), have a width of that number of pixels (for example, 100 pixels).<\/p>\n<p class=\"note\">Resize the Table Layout component if you need more space for columns.<\/p>\n<h3>Configuring a Column's Component<\/h3>\n<p class=\"intro-text\"><strong>1. <\/strong>Select a column to configure the component positioned on it.<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Select-a-column.png\" rel=\"lightbox-7\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-20670 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Select-a-column.png\" width=\"785\" height=\"185\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Select-a-column.png 785w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Select-a-column-768x181.png 768w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Select-a-column-150x35.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Select-a-column-24x6.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Select-a-column-36x8.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Select-a-column-48x11.png 48w\" sizes=\"auto, (max-width: 785px) 100vw, 785px\" \/><\/a><\/p>\n<p class=\"intro-text\"><strong>2. <\/strong>Now configure the component as you normally would, depending on the component; note that there are some changes to the data you can select, as contextual data is available.<\/p>\n<h3>Highlighting Rows or Columns<\/h3>\n<p class=\"intro-text\">You can highlight a table layout's columns or rows, as long as you use a style that has an alternating colour for this.<\/p>\n<p class=\"instruct\">Select an option from the <strong>Highlight<\/strong> drop-down list.<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Highlights.png\" rel=\"lightbox-8\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-20892 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Highlights.png\" width=\"351\" height=\"217\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Highlights.png 351w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Highlights-150x93.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Highlights-24x15.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Highlights-36x22.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Highlights-48x30.png 48w\" sizes=\"auto, (max-width: 351px) 100vw, 351px\" \/><\/a><\/p>\n<table style=\"width: 900px; border: 1px solid #cccccc;\">\n<tbody>\n<tr>\n<td style=\"width: 33%; padding-left: 10px; border-right: 1px solid #cccccc;\">\n<p><strong>Table Layout with Alternate Rows highlighting<\/strong><\/p>\n<\/td>\n<td style=\"width: 33%; padding-left: 10px; border-right: 1px solid #cccccc;\">\n<p><strong>Table Layout with Alternate Columns highlighting<\/strong><\/p>\n<\/td>\n<td style=\"width: 33%; padding-left: 10px;\">\n<p><strong>Table Layout with Choose Columns highlighting<\/strong><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 33%; padding-left: 10px; border-right: 1px solid #cccccc;\">\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Alternate-Rows-Preview.png\" rel=\"lightbox-9\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-20874\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Alternate-Rows-Preview.png\" width=\"300\" height=\"166\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Alternate-Rows-Preview.png 434w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Alternate-Rows-Preview-150x83.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Alternate-Rows-Preview-24x13.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Alternate-Rows-Preview-36x20.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Alternate-Rows-Preview-48x27.png 48w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<\/td>\n<td style=\"width: 33%; padding-left: 10px; border-right: 1px solid #cccccc;\">\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Alternate-Columns-Preview.png\" rel=\"lightbox-10\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-20873\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Alternate-Columns-Preview.png\" width=\"300\" height=\"167\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Alternate-Columns-Preview.png 441w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Alternate-Columns-Preview-150x83.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Alternate-Columns-Preview-24x13.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Alternate-Columns-Preview-36x20.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Alternate-Columns-Preview-48x27.png 48w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<\/td>\n<td>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Choose-Columns-Preview.png\" rel=\"lightbox-11\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-20872\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Choose-Columns-Preview.png\" width=\"300\" height=\"168\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Choose-Columns-Preview.png 436w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Choose-Columns-Preview-150x84.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Choose-Columns-Preview-24x13.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Choose-Columns-Preview-36x20.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Choose-Columns-Preview-48x27.png 48w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 33%; padding-left: 10px; border-right: 1px solid #cccccc;\">\n<p>Select <em>Alternate Rows<\/em> from the <strong>Highlight<\/strong> drop-down list.<\/p>\n<\/td>\n<td style=\"width: 33%; padding-left: 10px; border-right: 1px solid #cccccc;\">\n<p>Select <em>Alternate Columns<\/em> from the <strong>Highlight<\/strong> drop-down list.<\/p>\n<\/td>\n<td style=\"width: 33%; padding-left: 10px;\">\n<p>Select <em>Choose Columns <\/em> from the <strong>Highlight<\/strong> drop-down list, then select the <strong>Highlight<\/strong> checkbox next to the columns to highlight.<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 33%; padding-left: 10px; border-right: 1px solid #cccccc;\">\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Alt-Rows.png\" rel=\"lightbox-12\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-20901\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Alt-Rows.png\" width=\"300\" height=\"368\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Alt-Rows.png 323w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Alt-Rows-122x150.png 122w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Alt-Rows-20x24.png 20w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Alt-Rows-29x36.png 29w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Alt-Rows-39x48.png 39w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<\/td>\n<td style=\"width: 33%; padding-left: 10px; border-right: 1px solid #cccccc;\">\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/alt-columns.png\" rel=\"lightbox-13\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-20902\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/alt-columns.png\" width=\"300\" height=\"367\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/alt-columns.png 322w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/alt-columns-123x150.png 123w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/alt-columns-20x24.png 20w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/alt-columns-29x36.png 29w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/alt-columns-39x48.png 39w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<\/td>\n<td style=\"width: 33%; padding-left: 10px;\">\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Selected-Columns.png\" rel=\"lightbox-14\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-20900\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Selected-Columns.png\" width=\"300\" height=\"363\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Selected-Columns.png 324w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Selected-Columns-124x150.png 124w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Selected-Columns-20x24.png 20w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Selected-Columns-30x36.png 30w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Selected-Columns-40x48.png 40w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p class=\"instruct\">To clear highlighting, select <em>None<\/em> from the <strong>Highlight<\/strong> drop-down list.<\/p>\n<h3>Hiding the Headers<\/h3>\n<p class=\"intro-text\">To hide the table layout headers, select the <strong>Headerless<\/strong> checkbox.<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Choose-Headerless.png\" rel=\"lightbox-15\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-20889 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Choose-Headerless.png\" width=\"329\" height=\"152\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Choose-Headerless.png 329w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Choose-Headerless-150x69.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Choose-Headerless-24x11.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Choose-Headerless-36x17.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Choose-Headerless-48x22.png 48w\" sizes=\"auto, (max-width: 329px) 100vw, 329px\" \/><\/a><\/p>\n<h3>Styling the Table Layout<\/h3>\n<p class=\"intro-text\">First style the table layout, by selecting a style from the drop-down list. If you are a Style Administrator, you can add a new Table Layout style.<\/p>\n<p class=\"intro-text\">Next, click on each of the column components, and style these to work well with as a group.<\/p>\n<hr \/>\n<h2 class=\"page-subheading\">The Table Layout's Data<\/h2>\n<p class=\"intro-text\">When you have assigned data to a new table layout, the first five data columns are automatically added as columns on the Table Layout, each with a Text Label component containing data for one of the five data columns. The number of rows depends on the dataset: if the dataset has ten rows, the Table Layout will have ten rows, and so on.<\/p>\n<p class=\"intro-text\">Any components that you want to add to the Table Layout have access to the data. For example:<\/p>\n<ul class=\"intro-text\">\n<li>Drop an Image component onto a Table Layout column, and configure its conditions to use contextual Table Layout data.<\/li>\n<li>Drop a Data Label component onto a Table Layout column, and configure its <em>Value<\/em> to use contextual Table Layout data.<\/li>\n<li>Drop a Target Variance Bar component onto a Table Layout column, and configure its <em>Actual<\/em> and its <em>Target<\/em> to use contextual Table Layout data.<\/li>\n<\/ul>\n<p class=\"note\"><strong>Note: <\/strong>Contextual data always applies to the <em>current row<\/em>.<\/p>\n<h3>Selecting the Table Layout's Data<\/h3>\n<p class=\"intro-text\">How you choose the Table layout's data depends on the component's property that you are configuring.<\/p>\n<p class=\"intro-text\"><strong>Example 1<\/strong>: Choosing Table Layout data using the <strong>Context<\/strong> option (here we are selecting a table layout data column for the <em>Filter Value<\/em> property of a <em>Chart's<\/em> line series).<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Using-context-data.png\" rel=\"lightbox-16\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-20905 size-full\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Using-context-data.png\" width=\"326\" height=\"100\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Using-context-data.png 326w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Using-context-data-150x46.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Using-context-data-24x7.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Using-context-data-36x11.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Using-context-data-48x15.png 48w\" sizes=\"auto, (max-width: 326px) 100vw, 326px\" \/><\/a><\/p>\n<p class=\"intro-text\"><strong>Example 2:<\/strong> Choosing Table Layout data using the <strong>table layout data<\/strong> <a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Table-Layout-Data-icon.png\" rel=\"lightbox-17\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-20724 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Table-Layout-Data-icon.png\" width=\"15\" height=\"13\" \/><\/a> icon (here we are selecting a table layout data column for the <em>Actual<\/em> property of a <em>Bullet Graph).<\/em><\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Using-the-table-layout-data-1.png\" rel=\"lightbox-18\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-20913 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Using-the-table-layout-data-1.png\" width=\"337\" height=\"125\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Using-the-table-layout-data-1.png 337w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Using-the-table-layout-data-1-150x56.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Using-the-table-layout-data-1-24x9.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Using-the-table-layout-data-1-36x13.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Using-the-table-layout-data-1-48x18.png 48w\" sizes=\"auto, (max-width: 337px) 100vw, 337px\" \/><\/a><\/p>\n<hr \/>\n<h2 class=\"page-subheading\">Setting up Data for the Table Layout<\/h2>\n<p class=\"intro-text\">There are four separate categories of data that you can select for your table layout's <em>Data<\/em>.<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/04\/Select-data-for-data-table.png\" rel=\"lightbox-19\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-14109 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/04\/Select-data-for-data-table.png\" alt=\"\" width=\"348\" height=\"212\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/04\/Select-data-for-data-table.png 348w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/04\/Select-data-for-data-table-150x91.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/04\/Select-data-for-data-table-24x15.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/04\/Select-data-for-data-table-36x22.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/04\/Select-data-for-data-table-48x29.png 48w\" sizes=\"auto, (max-width: 348px) 100vw, 348px\" \/><\/a><\/p>\n<p class=\"left-bar\"><strong>Note: <\/strong>You can tab through the different data categories, to configure them. The one that is selected when you save the page remains the configured option. Any other configurations will be lost.<\/p>\n<p class=\"intro-text\">Here is the full reference to the different data categories you can choose for a table layout's data.<\/p>\n<table>\n<tbody>\n<tr style=\"border: 1px solid #cccccc; border-left: 2px solid #cccccc; border-right: 2px solid #cccccc;\">\n<td style=\"padding-left: 20px; padding-top: 20px; width: 50%; border-right: 2px solid #cccccc;\">\n<p><strong>Dataset Query Columns:<\/strong> <img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-9576 size-full\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/02\/Dataset-Icon.png\" alt=\"\" width=\"20\" height=\"20\" \/> Configure your table layout's <em>Data<\/em> to use a column from a dataset query: <a title=\"Using Dataset Data\" href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/explorer-studio\/data-selector\/#Using_Dataset_Data\">Using Dataset Data<\/a><\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Dataset-Data.png\" rel=\"lightbox-20\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-20691 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Dataset-Data.png\" width=\"340\" height=\"376\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Dataset-Data.png 340w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Dataset-Data-136x150.png 136w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Dataset-Data-22x24.png 22w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Dataset-Data-33x36.png 33w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Dataset-Data-43x48.png 43w\" sizes=\"auto, (max-width: 340px) 100vw, 340px\" \/><\/a><\/p>\n<\/td>\n<td style=\"padding-left: 20px; padding-top: 20px; width: 50%;\"><strong>Ad hoc Calculation Columns: <\/strong> <img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-9575 size-full\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/02\/Ad-Hoc-Calc-Icon.png\" alt=\"\" width=\"20\" height=\"20\" \/> Configure your table layout's <em>Data<\/em> to use ad hoc calculations: <a title=\"Using Ad hoc Calculation Data\" href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/explorer-studio\/data-selector\/#Using_Ad_hoc_Calculation_Data\">Using Ad hoc Calculation Data<\/a><\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Calculations-Data.png\" rel=\"lightbox-21\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-20689 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Calculations-Data.png\" width=\"335\" height=\"485\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Calculations-Data.png 335w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Calculations-Data-104x150.png 104w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Calculations-Data-17x24.png 17w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Calculations-Data-25x36.png 25w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Calculations-Data-33x48.png 33w\" sizes=\"auto, (max-width: 335px) 100vw, 335px\" \/><\/a><\/p>\n<\/td>\n<\/tr>\n<tr style=\"border: 1px solid #cccccc; border-left: 2px solid #cccccc; border-right: 2px solid #cccccc;\">\n<td style=\"padding-left: 20px; padding-top: 20px; width: 50%; border-right: 2px solid #cccccc;\">\n<p><strong>Attribute Columns:<\/strong> <img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-17335 size-full\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/07\/Attribute-icon.png\" width=\"21\" height=\"19\" \/> Configure your table layout's <em>Data<\/em> to use attributes for one or more entities: <a title=\"Using Attribute Data\" href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/explorer-studio\/data-selector\/#Using_Attribute_Data\">Using Attribute Data<\/a><\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Attribute-Data.png\" rel=\"lightbox-22\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-20688 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Attribute-Data.png\" width=\"345\" height=\"440\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Attribute-Data.png 345w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Attribute-Data-118x150.png 118w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Attribute-Data-19x24.png 19w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Attribute-Data-28x36.png 28w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Attribute-Data-38x48.png 38w\" sizes=\"auto, (max-width: 345px) 100vw, 345px\" \/><\/a><\/p>\n<\/td>\n<td style=\"padding-left: 20px; padding-top: 20px; width: 50%;\"><strong>Tag Columns:<\/strong> <img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-9573 size-full\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/02\/tag-Icon.png\" alt=\"\" width=\"20\" height=\"20\" \/> Configure your table layout's <em>Data<\/em> to use tags: <a title=\"Using Tag Data\" href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/explorer-studio\/data-selector\/#Using_Tag_Data\">Using Tag Data<\/a><\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/tag-data.png\" rel=\"lightbox-23\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft wp-image-20690 size-full\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/tag-data.png\" width=\"337\" height=\"437\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/tag-data.png 337w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/tag-data-116x150.png 116w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/tag-data-19x24.png 19w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/tag-data-28x36.png 28w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/tag-data-37x48.png 37w\" sizes=\"auto, (max-width: 337px) 100vw, 337px\" \/><\/a><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<hr \/>\n<h2 class=\"page-subheading\">Using the Table Layout's Data<\/h2>\n<p class=\"intro-text\">When you configure a component on one of the Table Layout's columns, you can select any of the Table Layout's data columns, provided it is of the relevant type (for example, <em>text<\/em>, <em>number<\/em> and so on).<\/p>\n<p class=\"intro-text\">The data that gets used is contextual for the row.<\/p>\n<p class=\"intro-text\"><strong>Table Layout Data<\/strong> can be identified by the little table layout data <a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Table-Layout-Data-icon.png\" rel=\"lightbox-17\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-20724 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Table-Layout-Data-icon.png\" width=\"15\" height=\"13\" \/><\/a> icon, in the data category options.<\/p>\n<p class=\"intro-text\">For example, the Data Label picutred below is on a Table Layout component; its <strong>Value<\/strong> property can be configured to use data from the Table Layout columns:<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Example-of-the-table-layout-category.png\" rel=\"lightbox-25\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-20726 size-full\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Example-of-the-table-layout-category.png\" width=\"347\" height=\"205\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Example-of-the-table-layout-category.png 347w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Example-of-the-table-layout-category-150x89.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Example-of-the-table-layout-category-24x14.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Example-of-the-table-layout-category-36x21.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Example-of-the-table-layout-category-48x28.png 48w\" sizes=\"auto, (max-width: 347px) 100vw, 347px\" \/><\/a><\/p>\n<p class=\"left-bar\">Follow the example below, to see how Table Layout's data columns are used.<\/p>\n<p class=\"intro-text\">1. A preview of a Table Layout's dataset. Columns highlighted in green are already used in the Table Layout columns. We are going to add <em>WaterPlannedSum<\/em>, highlighted in yellow, to a new Table Layout column.<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Using-data-table-data-1.png\" rel=\"lightbox-26\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-20723 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Using-data-table-data-1.png\" width=\"812\" height=\"273\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Using-data-table-data-1.png 812w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Using-data-table-data-1-768x258.png 768w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Using-data-table-data-1-150x50.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Using-data-table-data-1-24x8.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Using-data-table-data-1-36x12.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Using-data-table-data-1-48x16.png 48w\" sizes=\"auto, (max-width: 812px) 100vw, 812px\" \/><\/a><\/p>\n<p class=\"intro-text\">2. This is what the Table Layout looks like, before new columns have been added.<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Using-data-table-data-2.png\" rel=\"lightbox-27\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-20722 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Using-data-table-data-2.png\" width=\"912\" height=\"363\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Using-data-table-data-2.png 912w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Using-data-table-data-2-768x306.png 768w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Using-data-table-data-2-150x60.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Using-data-table-data-2-24x10.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Using-data-table-data-2-36x14.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Using-data-table-data-2-48x19.png 48w\" sizes=\"auto, (max-width: 912px) 100vw, 912px\" \/><\/a><\/p>\n<p class=\"intro-text\">3. We add a new column, by clicking <strong>Add<\/strong>, and type in a header: <em>Water Planned<\/em>. The new column appears in the Table Layout component.<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Using-data-table-data-3.png\" rel=\"lightbox-28\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-20721 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Using-data-table-data-3.png\" width=\"921\" height=\"398\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Using-data-table-data-3.png 921w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Using-data-table-data-3-768x332.png 768w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Using-data-table-data-3-150x65.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Using-data-table-data-3-24x10.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Using-data-table-data-3-36x16.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Using-data-table-data-3-48x21.png 48w\" sizes=\"auto, (max-width: 921px) 100vw, 921px\" \/><\/a><\/p>\n<p class=\"intro-text\">4. Next, we drag and drop a Data Label component from the component toolbox onto the new column in the Table layout component. Note how the component icon is repeated across the different rows.<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Using-data-table-data-4.png\" rel=\"lightbox-29\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-20720 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Using-data-table-data-4.png\" width=\"565\" height=\"303\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Using-data-table-data-4.png 565w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Using-data-table-data-4-150x80.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Using-data-table-data-4-24x13.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Using-data-table-data-4-36x19.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Using-data-table-data-4-48x26.png 48w\" sizes=\"auto, (max-width: 565px) 100vw, 565px\" \/><\/a><\/p>\n<p class=\"intro-text\">5. We click on the Data Label compomonent to configure it. Click the <strong>Value<\/strong> drop-down list, select the <strong>Value<\/strong> <img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-9572 size-full\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/02\/Value-Icon.png\" alt=\"\" width=\"20\" height=\"20\" \/> data category (see <a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/explorer-studio\/data-selector\/#Using_Value_Data\">Using Value Data<\/a>). Next click the <strong>Table Layout Data<\/strong> <a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Table-Layout-Data-icon.png\" rel=\"lightbox-17\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-20724 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Table-Layout-Data-icon.png\" width=\"15\" height=\"13\" \/><\/a> icon, then select the <em>WaterPlannedSum<\/em> column from the drop-down list.<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Using-data-table-data-5.png\" rel=\"lightbox-31\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-20719 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Using-data-table-data-5.png\" width=\"359\" height=\"444\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Using-data-table-data-5.png 359w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Using-data-table-data-5-121x150.png 121w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Using-data-table-data-5-19x24.png 19w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Using-data-table-data-5-29x36.png 29w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Using-data-table-data-5-39x48.png 39w\" sizes=\"auto, (max-width: 359px) 100vw, 359px\" \/><\/a>.<\/p>\n<p class=\"intro-text\">6. The <em>WaterPlannedSum<\/em> value appears on the table layout. Note how it changes per row. If you look back at the data preview screenshot in <strong>Step 1<\/strong> you can see how <em>WaterPlannedSum<\/em> is <em>1081<\/em> for entity <em>Anstey<\/em>, <em>531<\/em> for <em>Big Red<\/em>, <em>578<\/em> for <em>Burt<\/em>, etc. The corresponding values are displayed in the Table Layout now, with data integrity maintained for the <strong>row<\/strong>.<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Using-data-table-data-6.png\" rel=\"lightbox-32\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-20718 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Using-data-table-data-6.png\" width=\"829\" height=\"260\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Using-data-table-data-6.png 829w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Using-data-table-data-6-768x241.png 768w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Using-data-table-data-6-150x47.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Using-data-table-data-6-24x8.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Using-data-table-data-6-36x11.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Using-data-table-data-6-48x15.png 48w\" sizes=\"auto, (max-width: 829px) 100vw, 829px\" \/><\/a><\/p>\n<p class=\"intro-text\">7. In the final step, we style the Data Label to match the other columns in the Table Layout.<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Using-data-table-data-7.png\" rel=\"lightbox-33\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-20717 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Using-data-table-data-7.png\" width=\"832\" height=\"269\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Using-data-table-data-7.png 832w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Using-data-table-data-7-768x248.png 768w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Using-data-table-data-7-150x48.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Using-data-table-data-7-24x8.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Using-data-table-data-7-36x12.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Using-data-table-data-7-48x16.png 48w\" sizes=\"auto, (max-width: 832px) 100vw, 832px\" \/><\/a><\/p>\n<hr \/>\n<h2 class=\"page-subheading\">Tutorials<\/h2>\n<p class=\"note\">If you're unfamiliar with the process of building pages, read the article\u00a0<a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/explorer-create-your-first-page\/building-an-explorer-page\/\">Building an Explorer Page<\/a>.<\/p>\n<p class=\"intro-text\">The following tutorials demonstrate how to add a table layout, assign data to it, and then use that data for components on additional columns.<\/p>\n<p class=\"left-bar\"><strong>Note<\/strong>: This configuration uses the <em>Sample Data <\/em>table\u00a0and datasets that can be optionally made available\u00a0during initial installation and setup. If you don't have access to this data, you will need to adjust the configuration to suit your data at your site.<\/p>\n<h3>Tutorial 1: Bullet Graph on a Table Layout<\/h3>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Table-Layout-with-Bullet-Graph.png\" rel=\"lightbox-34\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-20817 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Table-Layout-with-Bullet-Graph.png\" width=\"510\" height=\"337\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Table-Layout-with-Bullet-Graph.png 510w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Table-Layout-with-Bullet-Graph-150x99.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Table-Layout-with-Bullet-Graph-24x16.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Table-Layout-with-Bullet-Graph-36x24.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Table-Layout-with-Bullet-Graph-48x32.png 48w\" sizes=\"auto, (max-width: 510px) 100vw, 510px\" \/><\/a><\/p>\n<p class=\"no-toc-heading\">Step 1. Prepare the Tutorial Page<\/p>\n<p class=\"left-bar\"><strong>Note: <\/strong>Before you start the tutorial, <a title=\"Preparing an Explorer page for Tutorials (Precision)\" href=\"https:\/\/oihelp.corporate.ifs.com\/help\/preparing-an-explorer-page-for-tutorials-precision\/\">prepare a precision layout page in Studio<\/a> and save it with a suitable name, such as <em>Table Layout Tutorial 1 with Bullet Graph<\/em>.<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/04\/Precision-Layout-Page.png\" rel=\"lightbox-35\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-14582 size-medium\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/04\/Precision-Layout-Page-400x270.png\" width=\"400\" height=\"270\" \/><\/a><\/p>\n<p class=\"no-toc-heading\">Step 2. Add a Default Value<\/p>\n<p class=\"intro-text\">Click <strong>Defaults<\/strong> on the Explorer Ribbon, then add a new default in the Defaults Panel.<\/p>\n<p class=\"intro-text\"><em>Name<\/em>: selectedEntities, <em>Type<\/em>: EntityList, <em>Values<\/em>: Anstey, Big Red, Burt, Derby, Maxwell, Tucki.<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Add-Default-Values.png\" rel=\"lightbox-36\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-20813 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Add-Default-Values.png\" width=\"337\" height=\"711\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Add-Default-Values.png 337w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Add-Default-Values-71x150.png 71w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Add-Default-Values-11x24.png 11w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Add-Default-Values-17x36.png 17w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Add-Default-Values-23x48.png 23w\" sizes=\"auto, (max-width: 337px) 100vw, 337px\" \/><\/a><\/p>\n<p class=\"no-toc-heading\">Step 3. Add a Month Picker<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-20805 size-full\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/month-picker.png\" width=\"95\" height=\"93\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/month-picker.png 95w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/month-picker-24x24.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/month-picker-36x36.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/month-picker-48x48.png 48w\" sizes=\"auto, (max-width: 95px) 100vw, 95px\" \/><\/p>\n<p class=\"intro-text\">Drag and drop a <a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/explorer-studio\/controls\/month-picker\/\">Month Picker<\/a> component near the top left corner of the page. The Month Picker is in the Time <img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1865 size-full\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/02\/timeicon_sm.png\" alt=\"timeicon_sm\" width=\"18\" height=\"17\" \/> group.<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Step-3-month-Picker.png\" rel=\"lightbox-37\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-20754 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Step-3-month-Picker.png\" width=\"375\" height=\"135\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Step-3-month-Picker.png 375w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Step-3-month-Picker-150x54.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Step-3-month-Picker-24x9.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Step-3-month-Picker-36x13.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Step-3-month-Picker-48x17.png 48w\" sizes=\"auto, (max-width: 375px) 100vw, 375px\" \/><\/a><\/p>\n<p class=\"no-toc-heading\">Step 4. Add a Table Layout<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-20803 size-full\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/table-Layout.png\" width=\"92\" height=\"93\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/table-Layout.png 92w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/table-Layout-24x24.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/table-Layout-36x36.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/table-Layout-48x48.png 48w\" sizes=\"auto, (max-width: 92px) 100vw, 92px\" \/><\/p>\n<p class=\"intro-text\">1. Drag and drop a Table Layout component below the Month Picker, and resize it by dragging the edges. The Table Layout is in the Layout <img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-20808 size-full\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/layout-group.png\" width=\"21\" height=\"19\" \/> group.<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Step-4.1.png\" rel=\"lightbox-38\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-20753 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Step-4.1.png\" width=\"759\" height=\"414\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Step-4.1.png 759w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Step-4.1-150x82.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Step-4.1-24x13.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Step-4.1-36x20.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Step-4.1-48x26.png 48w\" sizes=\"auto, (max-width: 759px) 100vw, 759px\" \/><\/a><\/p>\n<p class=\"intro-text\">2. Click the Table Layout component to configure it.<\/p>\n<p class=\"intro-text\">3. Add a dataset query to the Table Layout's data, using the <a title=\"Data Selector\" href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/explorer-studio\/data-selector\/#Using_Dataset_Data\">Data Selector for Dataset Queries<\/a>.<\/p>\n<ul class=\"intro-text\">\n<li>Select the <strong>WellProductionDataSumByYear<\/strong> dataset query from the <em>Oil and Gas Data<\/em> datasource (or substitute with your own dataset query).<\/li>\n<li>Select <strong>endTime<\/strong> from the <em>EndDate<\/em> parameter drop-down list (variables). This uses the Page Default variable for <em>endTime<\/em>, which gets updated when the users selects a period from the Month picker.<\/li>\n<li>Select <strong>selectedEntities<\/strong> from the <em>EntitiesList<\/em> parameter drop-down list (variables). This uses the Default variable that you added in Step 2.<\/li>\n<li>Select <strong>startTime<\/strong> from the <em>startDate<\/em> parameter drop-down list (variables). This uses the Page Default variable for <em>startTime<\/em>, which gets updated when the users selects a period from the Month picker.<\/li>\n<\/ul>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Step-4.2.png\" rel=\"lightbox-39\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-20752 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Step-4.2.png\" width=\"342\" height=\"377\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Step-4.2.png 342w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Step-4.2-136x150.png 136w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Step-4.2-22x24.png 22w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Step-4.2-33x36.png 33w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Step-4.2-44x48.png 44w\" sizes=\"auto, (max-width: 342px) 100vw, 342px\" \/><\/a><\/p>\n<p class=\"intro-text\">The first five columns from the dataset are automatically added to the Table Layout.<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/First-five-columns-added.png\" rel=\"lightbox-40\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-20815 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/First-five-columns-added.png\" width=\"355\" height=\"393\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/First-five-columns-added.png 355w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/First-five-columns-added-135x150.png 135w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/First-five-columns-added-22x24.png 22w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/First-five-columns-added-33x36.png 33w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/First-five-columns-added-43x48.png 43w\" sizes=\"auto, (max-width: 355px) 100vw, 355px\" \/><\/a><\/p>\n<p class=\"intro-text\">4. Remove the <em>Year, OilPlannedSum<\/em> and <em>GasPlannedSum<\/em> columns (click the <strong>Remove<\/strong> button next to each), and rename <em>OilActualSum<\/em> to <em>Oil Prod<\/em> (type in the <strong>Header<\/strong> edit box).<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Step-4.3-BEFORE-2.png\" rel=\"lightbox-41\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-20812 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Step-4.3-BEFORE-2.png\" width=\"355\" height=\"393\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Step-4.3-BEFORE-2.png 355w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Step-4.3-BEFORE-2-135x150.png 135w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Step-4.3-BEFORE-2-22x24.png 22w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Step-4.3-BEFORE-2-33x36.png 33w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Step-4.3-BEFORE-2-43x48.png 43w\" sizes=\"auto, (max-width: 355px) 100vw, 355px\" \/><\/a><\/p>\n<p class=\"intro-text\">5. Click <strong>Add<\/strong> to add a new column, and name it <em>Oil Targets<\/em> (type in the <strong>Header<\/strong> text box).<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Step-4.3-AFTER-2.png\" rel=\"lightbox-42\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-20811 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Step-4.3-AFTER-2.png\" width=\"352\" height=\"338\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Step-4.3-AFTER-2.png 352w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Step-4.3-AFTER-2-150x144.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Step-4.3-AFTER-2-24x24.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Step-4.3-AFTER-2-36x36.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Step-4.3-AFTER-2-48x46.png 48w\" sizes=\"auto, (max-width: 352px) 100vw, 352px\" \/><\/a><\/p>\n<p class=\"no-toc-heading\">Step 5. Add a Bullet Graph<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-20806 size-full\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Bullet-Charts.png\" width=\"92\" height=\"89\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Bullet-Charts.png 92w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Bullet-Charts-24x24.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Bullet-Charts-36x36.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Bullet-Charts-48x46.png 48w\" sizes=\"auto, (max-width: 92px) 100vw, 92px\" \/><\/p>\n<p class=\"intro-text\">In this step, we'll add a bullet graph onto the table layout, and then configure its value to use a column from the table layout's data (<em>OilActualSum<\/em>), and compare it to a fixed target value.<\/p>\n<p class=\"intro-text\">1. Drag and drop a <a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/explorer-studio\/controls\/bullet-graph\/\">Bullet Graph<\/a> component onto the last column of the Table Layout (with the header: <strong>Oil Targets<\/strong>). The Bullet Graph is in the Chart <a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/02\/chartsicon_sm.png\" rel=\"lightbox-43\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1837\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/02\/chartsicon_sm.png\" alt=\"chartsicon_sm\" width=\"22\" height=\"17\" \/><\/a> group.<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Drag-and-drop-bullet.png\" rel=\"lightbox-44\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-20819 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Drag-and-drop-bullet.png\" width=\"751\" height=\"403\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Drag-and-drop-bullet.png 751w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Drag-and-drop-bullet-150x80.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Drag-and-drop-bullet-24x13.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Drag-and-drop-bullet-36x19.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Drag-and-drop-bullet-48x26.png 48w\" sizes=\"auto, (max-width: 751px) 100vw, 751px\" \/><\/a><\/p>\n<p class=\"intro-text\">2. Add value data to the Bullet Graph's <em>Actual<\/em> property, using the <a title=\"Data Selector\" href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/explorer-studio\/data-selector\/#Using_Value_Data\">Data Selector for Values<\/a>.<\/p>\n<p class=\"note\"><strong>Note:<\/strong> Because the Bullet Graph is on a Table Layout component, the <em>Value<\/em> data category has the additional data button for Table Layout Data <a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Table-Layout-Data-icon.png\" rel=\"lightbox-17\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-20724 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Table-Layout-Data-icon.png\" width=\"15\" height=\"13\" \/><\/a>. Click the <strong>Table Layout Data<\/strong> <a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Table-Layout-Data-icon.png\" rel=\"lightbox-17\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-20724 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Table-Layout-Data-icon.png\" width=\"15\" height=\"13\" \/><\/a> icon, then select the <em>OilActualSum<\/em> column from the drop-down list.<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Step-5.2.png\" rel=\"lightbox-47\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-20748 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Step-5.2.png\" width=\"353\" height=\"429\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Step-5.2.png 353w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Step-5.2-123x150.png 123w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Step-5.2-20x24.png 20w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Step-5.2-30x36.png 30w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Step-5.2-39x48.png 39w\" sizes=\"auto, (max-width: 353px) 100vw, 353px\" \/><\/a><\/p>\n<p class=\"intro-text\">3. Add value data to the Bullet Graph's <em>Target<\/em> property, using the <a title=\"Data Selector\" href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/explorer-studio\/data-selector\/#Using_Value_Data\">Data Selector for Values<\/a>. Click the <em> numeric constant<\/em> <img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-20824 size-full\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/numeric-constant.png\" width=\"37\" height=\"30\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/numeric-constant.png 37w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/numeric-constant-24x19.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/numeric-constant-36x29.png 36w\" sizes=\"auto, (max-width: 37px) 100vw, 37px\" \/> icon, and type in a number: <em>120000<\/em>.<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/step-5.3.png\" rel=\"lightbox-48\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-20747 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/step-5.3.png\" width=\"342\" height=\"264\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/step-5.3.png 342w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/step-5.3-150x116.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/step-5.3-24x19.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/step-5.3-36x28.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/step-5.3-48x37.png 48w\" sizes=\"auto, (max-width: 342px) 100vw, 342px\" \/><\/a><\/p>\n<p class=\"no-toc-heading\">Step 6. Style the Table Layout<\/p>\n<p class=\"intro-text\">In this step, we'll select a style that has wide rows for accommodating the Bullet Graph component. If you are a Style Administrator, you can add a new Table Layout style.<\/p>\n<p class=\"intro-text\">1. Select the Table Layout component: right-click on any component on the Table Layout to open the pop-up menu, then click the <strong>Table Layout<\/strong> option.<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Step-6.1.png\" rel=\"lightbox-49\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-20746 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Step-6.1.png\" width=\"464\" height=\"324\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Step-6.1.png 464w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Step-6.1-150x105.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Step-6.1-24x17.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Step-6.1-36x25.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Step-6.1-48x34.png 48w\" sizes=\"auto, (max-width: 464px) 100vw, 464px\" \/><\/a><\/p>\n<p class=\"intro-text\">2. Select a style from the <strong>Style<\/strong> drop-down list.<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Step-6.2.png\" rel=\"lightbox-50\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-20745 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Step-6.2.png\" width=\"356\" height=\"453\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Step-6.2.png 356w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Step-6.2-118x150.png 118w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Step-6.2-19x24.png 19w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Step-6.2-28x36.png 28w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Step-6.2-38x48.png 38w\" sizes=\"auto, (max-width: 356px) 100vw, 356px\" \/><\/a><\/p>\n<p class=\"no-toc-heading\">Step 7. Preview the Page<\/p>\n<ul class=\"intro-text\">\n<li class=\"intro-text\">Click the Preview <a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/03\/preview.png\" rel=\"lightbox-51\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2896\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/03\/preview.png\" alt=\"preview\" width=\"13\" height=\"14\" \/><\/a> button on the Studio toolbar to see what your page will look like in run-time.<\/li>\n<li class=\"intro-text\">Select <em>August 2016<\/em> from the month picker.<\/li>\n<\/ul>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Step-7.png\" rel=\"lightbox-52\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-20744 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Step-7.png\" width=\"459\" height=\"221\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Step-7.png 459w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Step-7-150x72.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Step-7-24x12.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Step-7-36x17.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Step-7-48x23.png 48w\" sizes=\"auto, (max-width: 459px) 100vw, 459px\" \/><\/a><\/p>\n<h3>Tutorial 2: Sparkline on a Table Layout<\/h3>\n<p class=\"intro-text\">In this tutorial, we'll update the Table Layout used in Tutorial 1, and configure it to use a Sparkline instead of a Bullet Graph. The Sparkline is a Chart component without labels or gridlines.<\/p>\n<p class=\"note\"><strong>Note:<\/strong> If you skipped <a href=\"#Tutorial_1_Bullet_Graph_on_a_Table_Layout\">Tutorial 1<\/a>, you'll need to follow the steps up to step 5.<\/p>\n<p class=\"no-toc-heading\">Step 1. Prepare the Tutorial Page<\/p>\n<p class=\"intro-text\">1. Open the page you created in Tutorial 1 (called <em>Table Layout Tutorial 1 with Bullet Graph<\/em>, or similar).<\/p>\n<p class=\"intro-text\">2. Click <strong>Save As<\/strong> <img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-13286 size-full\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/04\/save-as-button.png\" width=\"21\" height=\"22\" \/> on the Explorer toolbar, and save a copy of the page to your workspace (call it <em>Table Layout Tutorial 2 with Sparkline<\/em>, or similar).<\/p>\n<p class=\"no-toc-heading\">Step 2. Update the Table Layout<\/p>\n<p class=\"intro-text\">1. Select the Table Layout component: right-click on any component on the Table Layout to open the pop-up menu, then click the <strong>Table Layout<\/strong> option.<\/p>\n<p class=\"intro-text\">2. Rename <em>Oil Targets<\/em> (in the third column) to <em>Oil Trend<\/em> (type in the <strong>Header<\/strong> edit box).<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Update-Oil-Targets-to-Oil-Trend.png\" rel=\"lightbox-53\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-20831 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Update-Oil-Targets-to-Oil-Trend.png\" width=\"348\" height=\"336\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Update-Oil-Targets-to-Oil-Trend.png 348w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Update-Oil-Targets-to-Oil-Trend-150x145.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Update-Oil-Targets-to-Oil-Trend-24x24.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Update-Oil-Targets-to-Oil-Trend-36x36.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Update-Oil-Targets-to-Oil-Trend-48x46.png 48w\" sizes=\"auto, (max-width: 348px) 100vw, 348px\" \/><\/a><\/p>\n<p class=\"no-toc-heading\">Step 3. Add a Chart<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-20804 size-full\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/chart-icon.png\" width=\"92\" height=\"93\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/chart-icon.png 92w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/chart-icon-24x24.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/chart-icon-36x36.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/chart-icon-48x48.png 48w\" sizes=\"auto, (max-width: 92px) 100vw, 92px\" \/><\/p>\n<p class=\"intro-text\">In this step, we'll add a chart onto the table layout, configure it to use its own data, with a filter value using the table layout's data (<em>Entity<\/em>).<\/p>\n<p class=\"intro-text\">1. Drag and drop a <a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/explorer-studio\/controls\/charts\/\">Chart<\/a> component onto the last column of the Table Layout (with the header: <strong>Oil Trend<\/strong>). The Chart is in the Chart <a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/02\/chartsicon_sm.png\" rel=\"lightbox-54\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1837\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/02\/chartsicon_sm.png\" alt=\"chartsicon_sm\" width=\"22\" height=\"17\" \/><\/a> group.<\/p>\n<p class=\"intro-text\">2. Click the Chart component to configure it.<\/p>\n<p class=\"intro-text\">3. Add a dataset query to the Chart's data, using the <a title=\"Data Selector\" href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/explorer-studio\/data-selector\/#Using_Dataset_Data\">Data Selector for Dataset Queries<\/a>.<\/p>\n<ul class=\"intro-text\">\n<li>Select the <strong>WellProductionSumbyMonth<\/strong> dataset query from the <em>Oil and Gas Data<\/em> datasource (or substitute with your own dataset query).<\/li>\n<li>Select <strong>endTime<\/strong> from the <em>EndDate<\/em> parameter drop-down list (variables). This uses the Page Default variable for <em>endTime<\/em>, which gets updated when the users selects a period from the Month picker.<\/li>\n<li>Select <strong>selectedEntities<\/strong> from the <em>EntitiesList<\/em> parameter drop-down list (variables). This uses the Default variable that you added in Step 2 of Tutorial 1.<\/li>\n<li>Select <strong>startTime<\/strong> from the <em>startDate<\/em> parameter drop-down list (variables). This uses the Page Default variable for <em>startTime<\/em>, which gets updated when the users selects a period from the Month picker.<\/li>\n<\/ul>\n<p class=\"note\"><strong>Note:<\/strong> These are the same parameters used for the Table Layout data's dataset query, keeping the two in sync. The dataset queries themselves are also similar, and access the same data; the difference is that the chart's query divides the results into separate months, ideal for showing a Sparkline trend.<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Configure-Chart-Data.png\" rel=\"lightbox-55\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-20837 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Configure-Chart-Data.png\" width=\"349\" height=\"427\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Configure-Chart-Data.png 349w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Configure-Chart-Data-123x150.png 123w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Configure-Chart-Data-20x24.png 20w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Configure-Chart-Data-29x36.png 29w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Configure-Chart-Data-39x48.png 39w\" sizes=\"auto, (max-width: 349px) 100vw, 349px\" \/><\/a><\/p>\n<p class=\"intro-text\">4. Configure the Line Series:<\/p>\n<p class=\"intro-text\">a. Click to open the Line Series.<\/p>\n<p class=\"intro-text\">b. For the <strong>Y Column<\/strong>, select <em>DataColumn<\/em> and <em>OilActualSum<\/em> from the respective drop-down lists.<\/p>\n<p class=\"intro-text\">c. For the <strong>Filter Column<\/strong>, select <em>DataColumn<\/em> and <em>Entity<\/em> from the respective drop-down lists.<\/p>\n<p class=\"intro-text\">d. For the <strong>Filter Value<\/strong>, select <em>Context<\/em> and <em>Entity<\/em> from the respective drop-down lists.<\/p>\n<p class=\"note\"><strong>Note: <\/strong> The <em>Context<\/em> option is available to all of the chart's properties, because it is on a Table Layout component. When you select context data, Explorer uses the selected Y Column for the current row.<\/p>\n<p class=\"intro-text\">e. For the <strong>Colour Matcher<\/strong>, type <em>OIL<\/em>. This colours the trend in green.<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Configure-the-chart-line-series.png\" rel=\"lightbox-56\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-20841 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Configure-the-chart-line-series.png\" width=\"330\" height=\"578\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Configure-the-chart-line-series.png 330w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Configure-the-chart-line-series-86x150.png 86w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Configure-the-chart-line-series-14x24.png 14w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Configure-the-chart-line-series-21x36.png 21w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Configure-the-chart-line-series-27x48.png 27w\" sizes=\"auto, (max-width: 330px) 100vw, 330px\" \/><\/a><\/p>\n<p class=\"intro-text\">5. Configure the X Axis:<\/p>\n<p class=\"intro-text\">a. Click to open the X Axis.<\/p>\n<p class=\"intro-text\">b. For the <strong>Column<\/strong>, select <em>DataColumn<\/em> and <em>Month<\/em> from the respective drop-down lists.<\/p>\n<p class=\"intro-text\">c. Clear the <strong>Visible<\/strong> checkbox, so that the X Values do not appear along the X Axis (there is no space for this, for a Sparkline).<\/p>\n<p class=\"intro-text\">d. Clear the <strong>Enable Gridlines<\/strong> checkbox.<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Configure-X-Axis.png\" rel=\"lightbox-57\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-20843 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Configure-X-Axis.png\" width=\"357\" height=\"357\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Configure-X-Axis.png 357w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Configure-X-Axis-150x150.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Configure-X-Axis-252x252.png 252w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Configure-X-Axis-24x24.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Configure-X-Axis-36x36.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Configure-X-Axis-48x48.png 48w\" sizes=\"auto, (max-width: 357px) 100vw, 357px\" \/><\/a><\/p>\n<p class=\"intro-text\">5. Configure the Left Y Axis:<\/p>\n<p class=\"intro-text\">a. Click to open the Left Y Axis.<\/p>\n<p class=\"intro-text\">b. Clear the <strong>Visible<\/strong> checkbox, so that the y Values do not appear along the Y Axis (there is no space for this, for a Sparkline).<\/p>\n<p class=\"intro-text\">c. Clear the <strong>Enable Gridlines<\/strong> checkbox.<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Configure-Y-Axis-1.png\" rel=\"lightbox-58\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-20851 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Configure-Y-Axis-1.png\" width=\"358\" height=\"441\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Configure-Y-Axis-1.png 358w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Configure-Y-Axis-1-122x150.png 122w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Configure-Y-Axis-1-19x24.png 19w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Configure-Y-Axis-1-29x36.png 29w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Configure-Y-Axis-1-39x48.png 39w\" sizes=\"auto, (max-width: 358px) 100vw, 358px\" \/><\/a><\/p>\n<p class=\"note\"><strong>Note:<\/strong> In the <strong>Others<\/strong> properties group, <strong>Legend<\/strong> and <strong>Tooltip<\/strong> are cleared by default. Keep the defaults settings, as the Sparkline should use neither of these.<\/p>\n<p class=\"no-toc-heading\">Step 4. Preview the Page<\/p>\n<ul class=\"intro-text\">\n<li class=\"intro-text\">Click the Preview <a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/03\/preview.png\" rel=\"lightbox-51\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2896\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/03\/preview.png\" alt=\"preview\" width=\"13\" height=\"14\" \/><\/a> button on the Studio toolbar to see what your page will look like in run-time.<\/li>\n<li class=\"intro-text\">Select <em>September 2016<\/em> from the month picker.<\/li>\n<\/ul>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Preview-with-sparkline.png\" rel=\"lightbox-60\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-20854 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Preview-with-sparkline.png\" width=\"448\" height=\"273\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Preview-with-sparkline.png 448w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Preview-with-sparkline-150x91.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Preview-with-sparkline-24x15.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Preview-with-sparkline-36x22.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Preview-with-sparkline-48x29.png 48w\" sizes=\"auto, (max-width: 448px) 100vw, 448px\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>The Table Layout is a component that arranges your data in a tabular format. You only need to configure the first row on the table and that will be repeated across each row in your dataset.<\/p>\n<p class=\"continue-reading-button\"> <a class=\"continue-reading-link\" href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/explorer-studio\/controls\/table-layout\/table-layout-4-4-1\/\">Read more<i class=\"crycon-right-dir\"><\/i><\/a><\/p>\n","protected":false},"author":8,"featured_media":23923,"parent":31334,"menu_order":5,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":"","_members_access_role":[],"_members_access_error":""},"categories":[11],"tags":[116,113],"class_list":["post-20506","page","type-page","status-publish","has-post-thumbnail","hentry","category-tutorial","tag-layouts","tag-tables","Product-ex"],"_links":{"self":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/20506","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=20506"}],"version-history":[{"count":0,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/20506\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/31334"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/media\/23923"}],"wp:attachment":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/media?parent=20506"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/categories?post=20506"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/tags?post=20506"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}