{"id":687,"date":"2020-05-06T16:52:02","date_gmt":"2020-05-06T08:52:02","guid":{"rendered":"http:\/\/www.yohz.com\/blogs\/?p=687"},"modified":"2020-05-06T16:52:02","modified_gmt":"2020-05-06T08:52:02","slug":"working-with-analysis-table-columns","status":"publish","type":"post","link":"https:\/\/www.yohz.com\/blogs\/2020\/05\/06\/working-with-analysis-table-columns\/","title":{"rendered":"Working with analysis table columns"},"content":{"rendered":"

Once you have imported a data set into Easy Excel Analysis<\/a> or SQL Data Analysis<\/a>, an analysis table is created.\u00a0 Here, we will described how to work with the analysis table columns.\u00a0 We will be using the global superstore 2016.xlsx<\/strong> file for reference.<\/p>\n

\"\"<\/p>\n

Creating summaries<\/h2>\n

To create summaries, please refer to this post<\/a> on how to create group and footer summaries.<\/p>\n

Hiding columns<\/h2>\n

To hide or display columns, open the Columns<\/strong> tab of the Customize<\/strong> panel.\u00a0 Select a column to make it visible, or deselect it to hide the column.<\/p>\n

\"\"<\/p>\n

Freezing columns<\/h2>\n

In Easy Excel Analysis<\/a> or SQL Data Analysis<\/a>, you can freeze columns on the left and right of the analysis table e.g. in the table below, the Order Date<\/strong> column is frozen on the left, and the Country<\/strong> column is frozen on the right.<\/p>\n

\"\"<\/p>\n

When you scroll the table horizontally, these 2 columns will remain fixed in their position.<\/p>\n

To freeze columns, first ensure that the LEFT BAND<\/strong> and\/or RIGHT BAND<\/strong> items are selected in the Customize<\/strong> panel.<\/p>\n

\"\"<\/p>\n

Then drag and drop columns onto either of those 2 items to freeze the columns in those bands.<\/p>\n

\"\"<\/p>\n

Stacking columns<\/h2>\n

You can stack columns by dragging them to a new column row, to create layouts like this:<\/p>\n

\"\"<\/p>\n

Notice that the Category<\/strong>, Sub-Category<\/strong>, Segment<\/strong>, Product ID<\/strong>, and Product Name<\/strong> columns are displayed on the second row.<\/p>\n

To stack columns, click on a column header and drag it to below the row where you want to create a new row.\u00a0 You will create a new row if you see the green horizontal indicator arrows.\u00a0 In the example below, we are dragging the Category<\/strong> column to create a new row.<\/p>\n

\"\"<\/p>\n

 <\/p>\n

 <\/p>\n

<\/fb:like><\/div>
<\/div><\/div>","protected":false},"excerpt":{"rendered":"

Once you have imported a data set into Easy Excel Analysis or SQL Data Analysis, an analysis table is created.\u00a0 Here, we will described how to work with the analysis table columns.\u00a0 We will be using the global superstore 2016.xlsx file for reference. Creating summaries To create summaries, please refer to this post on how […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[82,86],"tags":[83,91,92,89,90,87],"_links":{"self":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/687"}],"collection":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/comments?post=687"}],"version-history":[{"count":1,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/687\/revisions"}],"predecessor-version":[{"id":695,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/687\/revisions\/695"}],"wp:attachment":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/media?parent=687"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/categories?post=687"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/tags?post=687"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}