{"id":7844,"date":"2024-12-05T15:28:55","date_gmt":"2024-12-05T13:28:55","guid":{"rendered":"https:\/\/bitimpulse.com\/?post_type=manual&#038;p=7844"},"modified":"2024-12-05T15:28:55","modified_gmt":"2024-12-05T13:28:55","slug":"stovbecz-delta","status":"publish","type":"manual","link":"https:\/\/bitimpulse.com\/en\/manual\/zvit-interaktyvnyj-deshbord\/tablyczya\/stovbecz-delta\/","title":{"rendered":"Delta column"},"content":{"rendered":"<p>Let us create a column of a \u201cDelta\u201d type. Choose the type and click an \u00ab\u041e\u041a\u00bb button:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_6_2_1-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7871\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_6_2_1-2.png\" alt=\"\" width=\"541\" height=\"353\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_6_2_1-2.png 541w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_6_2_1-2-450x294.png 450w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_6_2_1-2-300x196.png 300w\" sizes=\"auto, (max-width: 541px) 100vw, 541px\" \/><\/a><\/p>\n<p>In a column field two new fields \u2013 \u201cActual\u201d and \u201cTarget\u201d appear. Let\u2019s choose a \u201cInternet Order Quantity\u201d measure for real values (actual), and a \u201cReseller Order Quantity\u201d measure will be a target. We will get a new column, which will show a delta value and its indicator:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_6_2_2-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7870\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_6_2_2-2.png\" alt=\"\" width=\"716\" height=\"470\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_6_2_2-2.png 716w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_6_2_2-2-450x295.png 450w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_6_2_2-2-300x197.png 300w\" sizes=\"auto, (max-width: 716px) 100vw, 716px\" \/><\/a><\/p>\n<p>A delta value type may be the following:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_6_2_3-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7869\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_6_2_3-2.png\" alt=\"\" width=\"541\" height=\"353\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_6_2_3-2.png 541w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_6_2_3-2-450x294.png 450w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_6_2_3-2-300x196.png 300w\" sizes=\"auto, (max-width: 541px) 100vw, 541px\" \/><\/a><\/p>\n<ul>\n<li>Actual value \u2013 an actual measure value;<\/li>\n<li>Absolute variation \u2013 difference between an actual and a target;<\/li>\n<li>Percent variation \u2013 percent of difference between an actual and a target;<\/li>\n<li>Percent of target \u2013 percent of an actual and a target.<\/li>\n<\/ul>\n<p>An indicator may have the following value:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_6_2_4-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7868\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_6_2_4-2.png\" alt=\"\" width=\"541\" height=\"353\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_6_2_4-2.png 541w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_6_2_4-2-450x294.png 450w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_6_2_4-2-300x196.png 300w\" sizes=\"auto, (max-width: 541px) 100vw, 541px\" \/><\/a><\/p>\n<ul>\n<li>Greater is good \u2013 \u00abgood\u00bb a target is achieved (an actual is bigger than a target);<\/li>\n<li>Less is good \u2013 \u00abbad\u00bb a goal is not achieved (an actual is less than a target);<\/li>\n<li>Warning if greater \u2013 a target is bigger than an actual;<\/li>\n<li>Warning if less \u2013 a target is less than an actual;<\/li>\n<li>No indication \u2013 indication is not<\/li>\n<\/ul>\n<p>For the delta, you can set the threshold value, which will indicate the excess of the actual above the target.<\/p>\n<p>The threshold can be of the following type:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_6_2_5-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7867\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_6_2_5-2.png\" alt=\"\" width=\"541\" height=\"353\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_6_2_5-2.png 541w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_6_2_5-2-450x294.png 450w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_6_2_5-2-300x196.png 300w\" sizes=\"auto, (max-width: 541px) 100vw, 541px\" \/><\/a><\/p>\n<p>Let&#8217;s get back to our grid and see if the target is achieved as a percentage. For this, let\u2019s fill out the form as follows:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_6_2_6-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7866\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_6_2_6-2.png\" alt=\"\" width=\"541\" height=\"353\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_6_2_6-2.png 541w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_6_2_6-2-450x294.png 450w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_6_2_6-2-300x196.png 300w\" sizes=\"auto, (max-width: 541px) 100vw, 541px\" \/><\/a><\/p>\n<p>As a result, we will see a delta column in which all the values exceeding the target are highlighted with a green indicator, and the red values are those that have not reached a target:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_6_2_7-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7865\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_6_2_7-2.png\" alt=\"\" width=\"463\" height=\"121\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_6_2_7-2.png 463w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_6_2_7-2-450x118.png 450w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_6_2_7-2-300x78.png 300w\" sizes=\"auto, (max-width: 463px) 100vw, 463px\" \/><\/a><\/p>\n<p>Obviously, the target was achieved only for \u201cAccessories\u201d category. The delta value can be displayed not only as text, but also as a diagram:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_6_2_8-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7864\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_6_2_8-2.png\" alt=\"\" width=\"766\" height=\"353\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_6_2_8-2.png 766w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_6_2_8-2-450x207.png 450w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_6_2_8-2-300x138.png 300w\" sizes=\"auto, (max-width: 766px) 100vw, 766px\" \/><\/a><\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_6_2_9-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7863\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_6_2_9-2.png\" alt=\"\" width=\"464\" height=\"122\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_6_2_9-2.png 464w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_6_2_9-2-450x118.png 450w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_6_2_9-2-300x79.png 300w\" sizes=\"auto, (max-width: 464px) 100vw, 464px\" \/><\/a><\/p>","protected":false},"featured_media":0,"parent":7830,"menu_order":205,"template":"","manuals":[17],"class_list":["post-7844","manual","type-manual","status-publish","hentry","manuals-bat-report"],"_links":{"self":[{"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/manual\/7844","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\/7830"}],"wp:attachment":[{"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/media?parent=7844"}],"wp:term":[{"taxonomy":"manuals","embeddable":true,"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/manuals?post=7844"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}