{"id":678,"date":"2020-05-06T16:08:27","date_gmt":"2020-05-06T08:08:27","guid":{"rendered":"http:\/\/www.yohz.com\/blogs\/?p=678"},"modified":"2020-05-06T17:49:51","modified_gmt":"2020-05-06T09:49:51","slug":"using-charts-in-your-analysis-tables","status":"publish","type":"post","link":"https:\/\/www.yohz.com\/blogs\/2020\/05\/06\/using-charts-in-your-analysis-tables\/","title":{"rendered":"Using charts in your analysis tables"},"content":{"rendered":"

In Easy Excel Analysis<\/a> and SQL Data Analysis<\/a>, you can use charts to visualize the data created in analysis tables<\/a>.\u00a0 A pre-requisite is that you analysis tables must have groups and summary values as described here<\/a>.<\/p>\n

Each grouped column serves as a level in the chart, and each summary value is the chart’s measure.\u00a0 For example, we have the following analysis table layout created based on the global superstore 2016.xlsx<\/strong> data.<\/p>\n

\"\"<\/p>\n

We have 3 grouping levels, and 2 summary values.\u00a0 To create a chart, click on the chart icon:<\/p>\n

\"\"<\/p>\n

A chart is displayed on the bottom of the analysis table.<\/p>\n

\"\"<\/p>\n

Clicking on the analysis table will update the chart accordingly, and vice versa.\u00a0 For example, if I click on the Europe<\/strong> item in the chart:<\/p>\n

\"\"<\/p>\n

the analysis table automatically expands the Europe<\/strong> grouping level, and the chart also displays the grouping level below Europe, which is the item category level.<\/p>\n

Likewise, if we click on a grouping level within the analysis table, the chart will also drill down to the corresponding level.<\/p>\n

\"\"<\/p>\n

 <\/p>\n

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

In Easy Excel Analysis and SQL Data Analysis, you can use charts to visualize the data created in analysis tables.\u00a0 A pre-requisite is that you analysis tables must have groups and summary values as described here. Each grouped column serves as a level in the chart, and each summary value is the chart’s measure.\u00a0 For […]<\/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":[95,96],"_links":{"self":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/678"}],"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=678"}],"version-history":[{"count":1,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/678\/revisions"}],"predecessor-version":[{"id":685,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/678\/revisions\/685"}],"wp:attachment":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/media?parent=678"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/categories?post=678"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/tags?post=678"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}