{"id":8499,"date":"2022-06-13T21:38:40","date_gmt":"2022-06-13T19:38:40","guid":{"rendered":"https:\/\/www.leaplytics.de\/?page_id=8499"},"modified":"2024-10-29T11:53:22","modified_gmt":"2024-10-29T10:53:22","slug":"discretizare-pentru-risc-heatmap-matrice-putere-bi","status":"publish","type":"page","link":"https:\/\/www.leaplytics.de\/ro\/discretizare-pentru-risc-heatmap-matrice-putere-bi\/","title":{"rendered":"Discretizare \u0219i transformare"},"content":{"rendered":"<p>Harta termic\u0103 \/ matricea noastr\u0103 de risc necesit\u0103 valorile de la 1 la 10, dar ce trebuie s\u0103 face\u021bi dac\u0103 datele dvs. sunt continue \u0219i nu se afl\u0103 \u00een acest interval? Sau dac\u0103 expresiile riscurilor dvs. constau \u00een cuvinte? Mai jos sunt prezentate patru solu\u021bii cu binning, quintile, praguri personalizate \u0219i coresponden\u021b\u0103 \u00eentre cuvinte \u0219i numere.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"binning\">Binning<\/h2>\n\n\n\n<p>\u00cen aceast\u0103 abordare a solu\u021biei, toate valorile continue din setul dvs. de date sunt \u00eemp\u0103r\u021bite \u00een cinci bini. V\u0103 rug\u0103m s\u0103 re\u021bine\u021bi c\u0103 dimensiunea intervalului este \u00eentotdeauna aceea\u0219i.<\/p>\n\n\n\n<p><em>Exemplu: Valorile dvs. sunt cuprinse \u00eentre 0 \u0219i 100: Sunt create urm\u0103toarele bins:<\/em><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><em>0 p\u00e2n\u0103 la 20<\/em><\/li>\n\n\n\n<li><em>21 p\u00e2n\u0103 la 40<\/em><\/li>\n\n\n\n<li><em>41 p\u00e2n\u0103 la 60<\/em><\/li>\n\n\n\n<li><em>61 p\u00e2n\u0103 la 80<\/em><\/li>\n\n\n\n<li><em>81 p\u00e2n\u0103 la 100<\/em><\/li>\n<\/ul>\n\n\n\n<p><em><strong>Prin urmare, acest lucru nu ia \u00een considerare cantitatea de riscuri din pubelele individuale.<\/strong> Intervalele de date sunt \u00eemp\u0103r\u021bite doar \u00een mod egal.<\/em><\/p>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-1 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:66.66%\">\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"400\" height=\"606\" src=\"https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/grafik-4.png\" alt=\"\" class=\"wp-image-8500\" srcset=\"https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/grafik-4.png 400w, https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/grafik-4-198x300.png 198w, https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/grafik-4-40x60.png 40w\" sizes=\"auto, (max-width: 400px) 100vw, 400px\" \/><\/figure>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:33.33%\">\n<p>\u00cen bara lateral\u0103, face\u021bi mai \u00eent\u00e2i clic dreapta pe c\u00e2mpul pe care dori\u021bi s\u0103 \u00eel transforma\u021bi. \u00cen exemplul nostru, c\u00e2mpul \"Impact Example\".<\/p>\n\n\n\n<p>Apoi selecta\u021bi \"Grup nou\" cu un clic st\u00e2nga. Se deschide fereastra \"Grupuri\".<\/p>\n<\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-2 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:33.33%\">\n<p>Aici selecta\u021bi op\u021biunea \"Number of bins\" pentru \"Bin type\". \u00cen partea st\u00e2ng\u0103 jos introduce\u021bi valoarea \"10\" ca \"Bin Count\". Apoi se calculeaz\u0103 automat l\u0103\u021bimea pubelelor la rubrica \"Bin size\".<\/p>\n\n\n\n<p>\u00cen final, face\u021bi clic pe \"OK\".<\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:66.66%\">\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"806\" height=\"635\" src=\"https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/grafik-5.png\" alt=\"\" class=\"wp-image-8501\" srcset=\"https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/grafik-5.png 806w, https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/grafik-5-300x236.png 300w, https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/grafik-5-768x605.png 768w, https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/grafik-5-76x60.png 76w\" sizes=\"auto, (max-width: 806px) 100vw, 806px\" \/><\/figure>\n<\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-3 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:66.66%\">\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"402\" height=\"664\" src=\"https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/grafik-6.png\" alt=\"\" class=\"wp-image-8503\" srcset=\"https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/grafik-6.png 402w, https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/grafik-6-182x300.png 182w, https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/grafik-6-36x60.png 36w\" sizes=\"auto, (max-width: 402px) 100vw, 402px\" \/><\/figure>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:33.33%\">\n<p>\u00cen ultimul pas, face\u021bi clic din nou pe c\u00e2mpul nou creat din bara lateral\u0103.<\/p>\n\n\n\n<p>Acum apare din nou fereastra \"Grupuri\".<\/p>\n<\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-4 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:33.33%\">\n<p>Aici selecta\u021bi tipul de grup \"List\" \u00een loc de \"Bin\". Valorile neagrupate apar \u00een caseta din st\u00e2nga.<\/p>\n\n\n\n<p>Acum \u00eencepe\u021bi \u0219i selecta\u021bi fiecare valoare \u0219i muta\u021bi-o \u00een coloana din dreapta prin intermediul butonului \"Grup\".<\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:66.66%\">\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"796\" height=\"631\" src=\"https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/grafik-7.png\" alt=\"\" class=\"wp-image-8504\" srcset=\"https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/grafik-7.png 796w, https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/grafik-7-300x238.png 300w, https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/grafik-7-768x609.png 768w, https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/grafik-7-76x60.png 76w\" sizes=\"auto, (max-width: 796px) 100vw, 796px\" \/><\/figure>\n<\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-5 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:66.66%\">\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"797\" height=\"631\" src=\"https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/grafik-8.png\" alt=\"\" class=\"wp-image-8505\" srcset=\"https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/grafik-8.png 797w, https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/grafik-8-300x238.png 300w, https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/grafik-8-768x608.png 768w, https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/grafik-8-76x60.png 76w\" sizes=\"auto, (max-width: 797px) 100vw, 797px\" \/><\/figure>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:33.33%\">\n<p>Aproape gata! Acum atribui\u021bi valorile de la 1 la 10 celor zece valori f\u0103c\u00e2nd dublu clic pe fiecare supergrup \u0219i inser\u00e2nd valorile. \u00cen final, face\u021bi clic pe \"OK\".<\/p>\n<\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-6 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:33.33%\">\n<p>Gata! A\u021bi transformat datele \u0219i acum le pute\u021bi trage pe o ax\u0103 din matricea noastr\u0103 de risc.<\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:66.66%\">\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"416\" height=\"634\" src=\"https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/grafik-9.png\" alt=\"\" class=\"wp-image-8506\" srcset=\"https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/grafik-9.png 416w, https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/grafik-9-197x300.png 197w, https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/grafik-9-39x60.png 39w\" sizes=\"auto, (max-width: 416px) 100vw, 416px\" \/><\/figure>\n<\/div>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"quintiles\">Quintile<\/h2>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-7 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:66.66%\">\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"393\" height=\"677\" src=\"https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/grafik-11.png\" alt=\"\" class=\"wp-image-8541\" srcset=\"https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/grafik-11.png 393w, https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/grafik-11-174x300.png 174w, https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/grafik-11-35x60.png 35w\" sizes=\"auto, (max-width: 393px) 100vw, 393px\" \/><\/figure>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:33.33%\">\n<p>Mai \u00eent\u00e2i facem clic dreapta din nou pe c\u00e2mpul pe care dorim s\u0103 \u00eel discretiz\u0103m. \u00cen exemplul nostru, acesta este \"Impact Example\". Apoi select\u0103m \"M\u0103sur\u0103 nou\u0103\". Editorul DAX se deschide deasupra tabloului de bord.<\/p>\n<\/div>\n<\/div>\n\n\n\n<p>Acum ad\u0103ug\u0103m urm\u0103torul cod, personalizat pentru tabelul \u0219i coloana dorit\u0103 din setul dvs. de date. Important - acesta este un exemplu pentru chintile. Dac\u0103 este necesar, \u00eel pute\u021bi adapta la percentile:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Quantile =\nvar FirstQuantile = CALCULATE(PERCENTILE.INC(Table[Column], .2), ALL(Table[Column]))\nvar SecondQuantile = CALCULATE(PERCENTILE.INC(Table[Column], .4), ALL(Table[Column]))\nvar ThirdQuantile = CALCULATE(PERCENTILE.INC(Table[Column], .6), ALL(Table[Column]))\nvar FourthQuantile = CALCULATE(PERCENTILE.INC(Table[Column], .8), ALL(Table[Column]))\nvar ThisVal = Min(Tabelul[Coloana])\nreturn\nIF(HASONEVALUE(Tabelul[Coloana]),\n\t\tIF(ThisVal  FirstQuantile &amp;&amp; ThisVal  SecondQuantile &amp;&amp; ThisVal  ThirdQuantile &amp;&amp; ThisVal &lt;= FourthQuantile, 4,\n\t\t\t\t5)\n\t\t\t)\n\t\t)\n) )<\/code><\/pre>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-8 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:33.33%\">\n<p>Gata! Astfel, am discretizat \u0219i am ob\u021binut valorile de la 1 la 5. Acum putem utiliza acest c\u00e2mp pentru matricea noastr\u0103 de risc!<\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:66.66%\">\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"244\" height=\"493\" src=\"https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/grafik-12.png\" alt=\"\" class=\"wp-image-8542\" srcset=\"https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/grafik-12.png 244w, https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/grafik-12-148x300.png 148w, https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/grafik-12-30x60.png 30w\" sizes=\"auto, (max-width: 244px) 100vw, 244px\" \/><\/figure>\n<\/div>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"custom-thresholds\">Praguri personalizate<\/h2>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-9 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:66.66%\">\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"393\" height=\"677\" src=\"https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/grafik-11.png\" alt=\"\" class=\"wp-image-8541\" srcset=\"https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/grafik-11.png 393w, https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/grafik-11-174x300.png 174w, https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/grafik-11-35x60.png 35w\" sizes=\"auto, (max-width: 393px) 100vw, 393px\" \/><\/figure>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:33.33%\">\n<p>Mai \u00eent\u00e2i facem clic dreapta din nou pe c\u00e2mpul pe care dorim s\u0103 \u00eel discretiz\u0103m. \u00cen exemplul nostru, acesta este \"Impact Example\". Apoi select\u0103m \"M\u0103sur\u0103 nou\u0103\". Editorul DAX se deschide deasupra tabloului de bord.<\/p>\n<\/div>\n<\/div>\n\n\n\n<p>Acum ad\u0103ug\u0103m urm\u0103torul cod, personalizat pentru tabelul \u0219i coloana dorit\u0103 din setul de date:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Custom_Thresholds =\nvar Primul prag = valoarea primului t\u0103u prag aici\nvar SecondThreshold = al doilea_valoare_de_valoare_aici\nvar ThirdThreshold = al_treilea_bunal_valoare_aici\nvar FourthThreshold = valoarea celui de-al patrulea prag al t\u0103u\nvar ThisVal = Min(Table[Column])\nreturn\nIF(HASONEVALUE(Tabel[Coloan\u0103]),\n\t\tIF(ThisVal  FirstThreshold &amp;&amp; ThisVal  SecondThreshold &amp;&amp; ThisVal  ThirdThreshold &amp;&amp; ThisVal &lt;= FourthThreshold, 4,\n\t\t\t\t5)\n\t\t\t)\n\t\t)\n) )<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"words-to-numbers\">De la cuvinte la numere<\/h2>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-10 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:66.66%\">\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"627\" height=\"439\" src=\"https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/grafik-17.png\" alt=\"\" class=\"wp-image-8963\" srcset=\"https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/grafik-17.png 627w, https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/grafik-17-300x210.png 300w, https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/grafik-17-86x60.png 86w\" sizes=\"auto, (max-width: 627px) 100vw, 627px\" \/><\/figure>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:33.33%\">\n<p>Mai \u00eent\u00e2i face\u021bi clic pe \"Transformare date\" \u00een meniu. Acest lucru deschide editorul Power Query.<\/p>\n<\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-11 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:33.33%\">\n<p>Selecta\u021bi coloana pe care dori\u021bi s\u0103 o transforma\u021bi. \u00cen acest exemplu este vorba de coloana \"Probability Text\". Apoi face\u021bi clic pe \"Column from Examples\" \u00een col\u021bul din st\u00e2nga sus \u0219i selecta\u021bi \"From Selection\".<\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:66.66%\">\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"627\" height=\"268\" src=\"https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/grafik-18.png\" alt=\"\" class=\"wp-image-8964\" srcset=\"https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/grafik-18.png 627w, https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/grafik-18-300x128.png 300w, https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/grafik-18-140x60.png 140w\" sizes=\"auto, (max-width: 627px) 100vw, 627px\" \/><\/figure>\n<\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-12 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:66.66%\">\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"627\" height=\"268\" src=\"https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/grafik-19.png\" alt=\"\" class=\"wp-image-8965\" srcset=\"https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/grafik-19.png 627w, https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/grafik-19-300x128.png 300w, https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/grafik-19-140x60.png 140w\" sizes=\"auto, (max-width: 627px) 100vw, 627px\" \/><\/figure>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:33.33%\">\n<p>Se adaug\u0103 o nou\u0103 coloan\u0103. Face\u021bi clic pe prima celul\u0103 a noii coloane \u0219i introduce\u021bi valoarea numeric\u0103 dorit\u0103. \u00cen exemplul nostru, \"Remote\" (expresia cea mai mic\u0103) corespunde valorii \"1\".&nbsp; <em><strong>Nu trebuie s\u0103 modifica\u021bi individual toate valorile. Power BI recunoa\u0219te numerele \u0219i le mapeaz\u0103 automat \u00een func\u021bie de <\/strong><\/em><strong>dou\u0103<\/strong><em><strong> exemple ale tale.<\/strong><\/em><\/p>\n<\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-13 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:33.33%\">\n<p>Repeta\u021bi acest lucru pentru fiecare expresie din setul dvs. de date ...<\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:66.66%\">\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"627\" height=\"317\" src=\"https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/grafik-20.png\" alt=\"\" class=\"wp-image-8966\" srcset=\"https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/grafik-20.png 627w, https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/grafik-20-300x152.png 300w, https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/grafik-20-119x60.png 119w\" sizes=\"auto, (max-width: 627px) 100vw, 627px\" \/><\/figure>\n<\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-14 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:66.66%\">\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"627\" height=\"315\" src=\"https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/grafik-21.png\" alt=\"\" class=\"wp-image-8969\" srcset=\"https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/grafik-21.png 627w, https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/grafik-21-300x151.png 300w, https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/grafik-21-119x60.png 119w\" sizes=\"auto, (max-width: 627px) 100vw, 627px\" \/><\/figure>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:33.33%\">\n<p>Dup\u0103 ce a\u021bi mapat ultima expresie, face\u021bi clic pe \"OK\" . Asta este: O coloan\u0103 transformat\u0103 pentru \"Probabilitate\". Repeta\u021bi acest lucru cu \"Impact\" \u0219i ave\u021bi formatul de date necesar. Am ales aceast\u0103 logic\u0103 de la 1 la 10, deoarece fiecare are o formulare diferit\u0103 pentru cele cinci categorii.<\/p>\n<\/div>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>Our Risk Heatmap \/ Matrix requires 1 to 10 as values, but what to do if your data is continuous and not in this interval? Or if the expressions of your risks consist of words? Below are four solutions with binning, quintiles, custom thresholds and words to numbers mapping. Binning In this solution approach, all &hellip; <\/p>","protected":false},"author":2,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-8499","page","type-page","status-publish","hentry","latest_post"],"_links":{"self":[{"href":"https:\/\/www.leaplytics.de\/ro\/wp-json\/wp\/v2\/pages\/8499","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.leaplytics.de\/ro\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.leaplytics.de\/ro\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.leaplytics.de\/ro\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.leaplytics.de\/ro\/wp-json\/wp\/v2\/comments?post=8499"}],"version-history":[{"count":2,"href":"https:\/\/www.leaplytics.de\/ro\/wp-json\/wp\/v2\/pages\/8499\/revisions"}],"predecessor-version":[{"id":13647,"href":"https:\/\/www.leaplytics.de\/ro\/wp-json\/wp\/v2\/pages\/8499\/revisions\/13647"}],"wp:attachment":[{"href":"https:\/\/www.leaplytics.de\/ro\/wp-json\/wp\/v2\/media?parent=8499"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}