{"id":5208,"date":"2024-02-29T12:39:53","date_gmt":"2024-02-29T10:39:53","guid":{"rendered":"https:\/\/bitimpulse.com\/?post_type=manual&#038;p=5208"},"modified":"2024-02-29T12:50:02","modified_gmt":"2024-02-29T10:50:02","slug":"obchyslyuvani-pokaznyky-miry","status":"publish","type":"manual","link":"https:\/\/bitimpulse.com\/en\/manual\/rozshyreni-mozhlyvosti-oformlennya-zvitiv-2\/obchyslyuvani-elementy\/obchyslyuvani-pokaznyky-miry\/","title":{"rendered":"Calculated Measures"},"content":{"rendered":"<p>You can create your own calculated measures and use them just the way you do it with ordinary measures. To create a new calculated measure press the right mouse button anywhere in the measures list. You will see the context menu, which will give you an ability to add calculated measures:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/6_92.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3945\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/6_92.png\" alt=\"\" width=\"301\" height=\"213\" \/><\/a><\/p>\n<p>After pressing \u201cNew Measure \u2026\u201d item you will see a wizard that will help you to create calculated measure:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/6_93.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3946\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/6_93.png\" alt=\"\" width=\"440\" height=\"412\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/6_93.png 440w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/6_93-300x281.png 300w\" sizes=\"auto, (max-width: 440px) 100vw, 440px\" \/><\/a><\/p>\n<p>The wizard lets you choose the type of a new calculated measure from six different options:<\/p>\n<ul>\n<li>Relationship;<\/li>\n<li>Parallel Period;<\/li>\n<li>Growth;<\/li>\n<li>Rolling;<\/li>\n<li>Period to date;<\/li>\n<li>Custom MDX;<\/li>\n<\/ul>\n<p>The last option is for experts that are familiar with MDX querying language. All other options will let you create new measures in an easy wizard mode.<\/p>\n<p>For example, let\u2019s create a calculated measure of an average sales amount by orders \u2013 the ratio of sales amount to orders count. Select a \u201cRelationship\u201d measure type:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/6_94.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3947\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/6_94.png\" alt=\"\" width=\"440\" height=\"412\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/6_94.png 440w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/6_94-300x281.png 300w\" sizes=\"auto, (max-width: 440px) 100vw, 440px\" \/><\/a><\/p>\n<p>Press \u201cNext\u201d and fill in the fields in the next window as it is shown in the picture:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/6_95.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3948\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/6_95.png\" alt=\"\" width=\"434\" height=\"466\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/6_95.png 434w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/6_95-419x450.png 419w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/6_95-279x300.png 279w\" sizes=\"auto, (max-width: 434px) 100vw, 434px\" \/><\/a><\/p>\n<p>After pressing \u201cFinish\u201d you will see the folder for calculated measures in the measures list and it will contain a new measure:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/8_4.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5209\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/8_4.png\" alt=\"\" width=\"248\" height=\"252\" \/><\/a><\/p>\n<p>Now you can use that calculated measures the same way you use the other measures. Just drug the new measure into the \u201cMeasures\u201d designer and you will get the expected result:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/6_97.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3950\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/6_97.png\" alt=\"\" width=\"603\" height=\"289\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/6_97.png 603w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/6_97-450x216.png 450w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/6_97-300x144.png 300w\" sizes=\"auto, (max-width: 603px) 100vw, 603px\" \/><\/a><\/p>\n<p>To edit or delete calculated measure just click the right mouse button on the corresponding measure in the list and select \u201cEdi\u201d or \u201cDelete\u201d, respectively:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/8_5.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5212\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/8_5.png\" alt=\"\" width=\"248\" height=\"252\" \/><\/a><\/p>","protected":false},"featured_media":0,"parent":5206,"menu_order":375,"template":"","manuals":[18],"class_list":["post-5208","manual","type-manual","status-publish","hentry","manuals-bat-desktop"],"_links":{"self":[{"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/manual\/5208","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\/5206"}],"wp:attachment":[{"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/media?parent=5208"}],"wp:term":[{"taxonomy":"manuals","embeddable":true,"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/manuals?post=5208"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}