{"id":6083,"date":"2019-07-18T18:41:37","date_gmt":"2019-07-18T10:41:37","guid":{"rendered":"http:\/\/www.finereport.com\/en\/?p=6083"},"modified":"2019-10-16T16:37:22","modified_gmt":"2019-10-16T08:37:22","slug":"pure-report-operated-heat-map-tutorial-without-one-line-of-code","status":"publish","type":"post","link":"https:\/\/frg.fineres.com\/en\/2019\/07\/18\/pure-report-operated-heat-map-tutorial-without-one-line-of-code\/","title":{"rendered":"Pure report-operated heat map tutorial without one line of code!"},"content":{"rendered":"\r\n\r\nHow can I create a heat map without writing a single line of code? It sounds very difficult, but it&#8217;s not really the case. Just use our reporting tool, <em><a href=\"http:\/\/www.finereport.com\/en\/\">FineReport<\/a><\/em>, to easily create a cool heat map with an excel-like operation!\r\n\r\n\r\n\r\n\r\n<div class=\"wp-block-image\">\r\n<figure class=\"aligncenter\"><img class=\"wp-image-6111\" src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/blogs\/images\/2019071801L.gif\" alt=\"\" \/><figcaption>Made by <a href=\"http:\/\/www.finereport.com\/en\/\"><em>FineReport<\/em><\/a><\/figcaption><\/figure>\r\n<\/div>\r\n\r\n\r\n\r\n<h4><strong>1\u3001Find the data source<\/strong><\/h4>\r\n\r\n\r\n\r\n\r\nThe first step in data analysis is to find the source of the data. So where can I find the data for the seismic heat map? The answer is USGS. We can obtain seismic data of various regions from it. In this article, we take the world&#8217;s seismic data from 1999 to 2019 and import it into Excel and edit it into a unified format as shown below.\r\n\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img class=\"wp-image-6112\" src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/blogs\/images\/2019071802L.png\" alt=\"\" \/><\/figure>\r\n\r\n\r\n\r\n<h4><strong>2\u3001Connect data set<\/strong><\/h4>\r\n\r\n\r\n\r\n\r\nThe data source is found, now\r\ndownload our FineReport (<a href=\"http:\/\/bit.ly\/2Y5clsR\">Download<\/a>) first~\r\n\r\n\r\n\r\n\r\n\r\nAfter completing the download,\r\nopen the designer and how to connect to the dataset? Since FineReport can&#8217;t\r\ndirectly connect to Excel data source, we need to put the excel data under the\r\npath of installing FineReport. At this time, re-open the designer, you will\r\nfind your Excel data file, and then import it. Select file, set file type as\r\nexcel, then choose local file, select the excel file just imported, on the\r\nright side select &#8220;First row contains column headings&#8221;.\r\n\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img class=\"wp-image-6100\" src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/blogs\/images\/2019071803L.png\" alt=\"\" \/><\/figure>\r\n\r\n\r\n\r\n<h4><strong>3\u3001 Template data set<\/strong><\/h4>\r\n\r\n\r\n\r\n\r\nTake a cell chart as an example, merge a\r\ncell, click Insert -&gt; Cell Element -&gt; Insert Chart, select the heat map,\r\nas shown below:\r\n\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img class=\"wp-image-6102\" src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/blogs\/images\/2019071804L.png\" alt=\"\" \/><\/figure>\r\n\r\n\r\n\r\n\r\nSelect the chart, on the right side select the chart property table -&gt; type, and select the heat map by default, as shown in the following figure: here I select Template Parameter, then select the GIS layer as Satellite (many other options). You can set the center point of the map display. Here I choose (101,0) to display Southeast Asia as the center.\r\n\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img class=\"wp-image-6113\" src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/blogs\/images\/2019071805L.png\" alt=\"\" \/><\/figure>\r\n\r\n\r\n\r\n\r\nThen set the map data, as follows\r\n\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img class=\"wp-image-6114\" src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/blogs\/images\/2019071806L.png\" alt=\"\" \/><\/figure>\r\n\r\n\r\n\r\n<h4><strong>4\u3001Template style design<\/strong><\/h4>\r\n\r\n\r\n\r\n\r\nNext, adjust the specific form.\r\n\r\n\r\n\r\n\r\n\r\nThe legend is set to a gradient color by default. You can define the maximum and minimum according to your needs. Select Chart Property Table -&gt; Style -&gt; Series, you can see that the series properties are divided into two settings: Heat point and BG area. If the boundary\/point selected by the user does not contain the boundary information, the setting is invalid. The series interface of the thermal point is as follows: the larger the rendering radius, the larger the display range of the heat region; the greater the blur, the higher the blur of the heat boundary. Opacity minimum and maximum, corresponding to the opacity of the minimum and maximum values in the graph, set here as follows.\r\n\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img class=\"wp-image-6115\" src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/blogs\/images\/2019071807L.png\" alt=\"\" \/><\/figure>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img class=\"wp-image-6116\" src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/blogs\/images\/2019071808L.png\" alt=\"\" \/><\/figure>\r\n\r\n\r\n\r\n<h4><strong>5<\/strong><strong>\u3001Effect display<\/strong><\/h4>\r\n\r\n\r\n\r\n\r\nFinally click on the preview and all done!\r\n\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img class=\"wp-image-6117\" src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/blogs\/images\/2019071809L.png\" alt=\"\" \/><\/figure>\r\n\r\n\r\n\r\n\r\nWow, the effect is great! Here is a heat map of earthquake in Southeast Asia. The darker the color, the higher the probability of an earthquake! Come and see where the earthquake is happening!\r\n\r\n\r\n\r\n\r\n\r\nSeeing here, someone may be a bit curious about how the Earth image at the beginning of the article was made. very simple! Just select structure(new) when inserting the chart. The subsequent settings can be experienced by yourself, very similar~\r\n\r\n\r\n\r\n\r\n<div class=\"wp-block-image\">\r\n<figure class=\"aligncenter\"><img class=\"wp-image-6118\" src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/blogs\/images\/2019071810L.gif\" alt=\"\" \/><\/figure>\r\n<\/div>\r\n\r\n\r\n\r\n\r\n<em>Follow<a>\u00a0<\/a><a href=\"https:\/\/www.facebook.com\/finereport\/\">FineReport Reporting Software<\/a>\u00a0on Facebook to learn more about data visualization!<\/em>\r\n\r\n","protected":false},"excerpt":{"rendered":"<p>If you want to make a cool heat map without writing code, this article can help you!<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[111],"tags":[118],"_links":{"self":[{"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/posts\/6083"}],"collection":[{"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/comments?post=6083"}],"version-history":[{"count":5,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/posts\/6083\/revisions"}],"predecessor-version":[{"id":8314,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/posts\/6083\/revisions\/8314"}],"wp:attachment":[{"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/media?parent=6083"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/categories?post=6083"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/tags?post=6083"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}