{"id":4015,"date":"2024-02-01T14:33:56","date_gmt":"2024-02-01T12:33:56","guid":{"rendered":"https:\/\/bitimpulse.com\/?post_type=manual&p=4015"},"modified":"2024-09-27T14:07:04","modified_gmt":"2024-09-27T11:07:04","slug":"bizhuchyj-pokaznyk","status":"publish","type":"manual","link":"https:\/\/bitimpulse.com\/en\/manual\/rozshyreni-mozhlyvosti-oformlennya-zvitiv\/obchyslyuvani-elementy\/obchyslyuvani-pokaznyky-miry\/bizhuchyj-pokaznyk\/","title":{"rendered":"Rolling Measure"},"content":{"rendered":"

Rolling measure type is used to show an average or total value of some measure in a certain time period.<\/p>\n

For example, you can create a measure that will show an average profit for the last three month. To do that, create a new calculated measure of \u201cRolling\u201d type:<\/p>\n

\"\"<\/a><\/p>\n

In the next window fill in the fields as it is shown in the picture:<\/p>\n

\"\"<\/a><\/p>\n

The Operation type selected at the bottom (Average) means that the average value of a measure, set in the \u201cBase Measure\u2019 field, will be calculated, in our case \u2013 “Gross Profit\u201d. Values in fields \u201cPeriods\u201d and \u201cTime Hierarchy\u201d state that the average should be calculated over the last 3 month in the \u201cDate.Calendar\u201d hierarchy.<\/p>\n

After filling in the fields press \u00abOK\u00bb and you will see a new measure in a measures list:<\/p>\n

\"\"<\/a><\/p>\n

To try that new measure in practice, create a new page of the structure, described below.<\/p>\n

Put months of 2017 on columns:<\/p>\n

\"\"<\/a><\/p>\n

Put two measures on rows: \u201cGross Profit\u201d and \u201cGross Profit Rolling\u201d.<\/p>\n

Next, add a chart to the page and change the chart properties like this:<\/p>\n

\"\"<\/a><\/p>\n

You will get a page looking like this:<\/p>\n

\"\"<\/a><\/p>\n

Profit for a current month is displayed with a red line, and the blue line shows the average profit for the last three consecutive months. As you can notice, the line corresponding to the calculated measure is more flat, it doesn\u2019t display the sharp rises and falls of profit. It looks more like a tendency, because the average value of profit in three months is taken into account.<\/p>\n

 <\/p>","protected":false},"featured_media":0,"parent":3788,"menu_order":136,"template":"","manuals":[17],"class_list":["post-4015","manual","type-manual","status-publish","hentry","manuals-bat-report"],"_links":{"self":[{"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/manual\/4015","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/manual"}],"about":[{"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/types\/manual"}],"up":[{"embeddable":true,"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/manual\/3788"}],"wp:attachment":[{"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/media?parent=4015"}],"wp:term":[{"taxonomy":"manuals","embeddable":true,"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/manuals?post=4015"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}