Teach you what year-over-year ringgit is and how to calculate it... get in here, white boy!_Intefrankly

Teach you what year-over-year ringgit is and how to calculate it... get in here, white boy!

When doing statistics, year-over-year and year-over-year calculations have to be done from time to time. Than in Excel by entering "year-on-year: = [the current period]/[the same period in the previous year]-1", "ring: = [the current period]/[the previous period]-1" such a formula for calculation, in the data view, with the field editor in the "advanced calculation" function, just a click of the mouse can be completed by all kinds of year-on-year, ring calculation. Here is an example to demonstrate the month-over-month and day-over-day comparison of the order amount.

Step1 Prepare data

Login to the Data View software, select the required data, enter the "Chart Designer", select "Table" in the drop-down menu of the chart type in the upper right corner, and select "Order Date" and "Order Amount" in the left field editing area to complete the preparation of the required data. Click for details on the process of creating a chart

Step2 Calculate month-over-month and day-over-day

* Calculation of month-on-month growth rate. Click the button shown on the right side of "Order Amount", select "Advanced Calculation" in the drop-down menu, you can see that the data view provides "Year-on-year growth value", "Year-on-year growth rate", "Chain growth value", "Chain growth rate" four kinds of calculation, here we choose "Month-on-month growth rate", and the name of the field with the "rename" function to "Order Amount Month-on-month growth rate", the effect is shown in the figure.

* Calculating the daily chain growth rate. The same procedure as "Calculate month-on-month growth rate", in the advanced calculation, you can select "Day-on-day growth rate", the effect is shown in the following figure.

In addition, if people are more used to looking at year-over-year and year-over-year data through charts, in Data View, by Changing the chart type , it can be done quickly, and we'll use a bar chart as an example. The original data are shown in the figure below.

The table is then turned into a bar chart by changing the chart type, which works as follows.

On this basis, it will become a bar chart (click to see the specific operation process of the bar chart ), the final effect is as follows.

Recommended>>
1、Manufacturing Big Data Analytics System for SMEs
2、Think carefully Is artificial intelligence really a species above humans
3、Attention Wish Sellers verify your account before April 15 to avoid losing money
4、Word cloud chart on the data cultivation of a sophisticated piggy boy
5、Why Big Data Needs Agile Thinking

已推荐到看一看 和朋友分享想法
最多200字，当前共 发送

已发送

确定
分享你的想法...
取消

确定
最多200字，当前共

发送中