- \n
- 0-20<\/em><\/li>\n\n\n\n
- Nuo 21 iki 40<\/em><\/li>\n\n\n\n
- nuo 41 iki 60<\/em><\/li>\n\n\n\n
- 61-80<\/em><\/li>\n\n\n\n
- Nuo 81 iki 100<\/em><\/li>\n<\/ul>\n\n\n\n
Tod\u0117l neatsi\u017evelgiama \u012f pavojaus kiek\u012f atskirose \u0161iuk\u0161liad\u0117\u017e\u0117se.<\/strong> Duomen\u0173 intervalai padalyti po lygiai.<\/em><\/p>\n\n\n\n
\n\n![\"\"](\"https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/grafik-4.png\")
<\/figure>\n<\/div>\n\n\n\n\n\u0160onin\u0117je juostoje pirmiausia de\u0161iniuoju pel\u0117s klavi\u0161u spustel\u0117kite lauk\u0105, kur\u012f norite transformuoti. M\u016bs\u0173 pavyzdyje laukas \"Poveikio pavyzdys\".<\/p>\n\n\n\n
Tada kairiuoju pel\u0117s klavi\u0161u spustel\u0117kite \"Nauja grup\u0117\". Atsidarys langas \"Grup\u0117s\".<\/p>\n<\/div>\n<\/div>\n\n\n\n
\n\n\u010cia pasirinkite parinkt\u012f \"Number of bins\" (\u0161iuk\u0161liad\u0117\u017e\u0117s tipas). Apa\u010dioje kair\u0117je pus\u0117je kaip \"Bin Count\" (\u0161iuk\u0161liad\u0117\u017ei\u0173 skai\u010dius) \u012fveskite reik\u0161m\u0119 \"10\". Tada automati\u0161kai apskai\u010diuojamas \u0161iuk\u0161liad\u0117\u017ei\u0173 plotis laukelyje \"Bin size\" (\u0161iuk\u0161liad\u0117\u017e\u0117s dydis).<\/p>\n\n\n\n
Galiausiai spustel\u0117kite \"OK\".<\/p>\n<\/div>\n\n\n\n
\n![\"\"](\"https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/grafik-5.png\")
<\/figure>\n<\/div>\n<\/div>\n\n\n\n\n\n![\"\"](\"https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/grafik-6.png\")
<\/figure>\n<\/div>\n\n\n\n\nPaskutiniame \u017eingsnyje dar kart\u0105 spustel\u0117kite naujai sukurt\u0105 lauk\u0105 \u0161onin\u0117je juostoje.<\/p>\n\n\n\n
Dabar v\u0117l rodomas langas \"Grup\u0117s\".<\/p>\n<\/div>\n<\/div>\n\n\n\n
\n\nPasirinkite grup\u0117s tip\u0105 \"List\" (s\u0105ra\u0161as), o ne \"Bin\" (\u0161iuk\u0161liad\u0117\u017e\u0117). Nesugrupuotos reik\u0161m\u0117s rodomos kairiajame lange.<\/p>\n\n\n\n
Dabar prad\u0117kite, pasirinkite kiekvien\u0105 reik\u0161m\u0119 ir perkelkite j\u0105 \u012f de\u0161in\u012fj\u012f stulpel\u012f naudodami mygtuk\u0105 \"Group\".<\/p>\n<\/div>\n\n\n\n
\n![\"\"](\"https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/grafik-7.png\")
<\/figure>\n<\/div>\n<\/div>\n\n\n\n\n\n![\"\"](\"https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/grafik-8.png\")
<\/figure>\n<\/div>\n\n\n\n\nBeveik paruo\u0161ta! Dabar de\u0161im\u010diai reik\u0161mi\u0173 priskirkite reik\u0161mes nuo 1 iki 10 dukart spustel\u0117dami kiekvien\u0105 supergrup\u0119 ir \u012fterpdami reik\u0161mes. Galiausiai spaud\u017eiate \"OK\".<\/p>\n<\/div>\n<\/div>\n\n\n\n
\n\nAtlikta! Duomenis transformavote ir dabar galite juos perkelti \u012f rizikos matricos a\u0161\u012f.<\/p>\n<\/div>\n\n\n\n
\n![\"\"](\"https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/grafik-9.png\")
<\/figure>\n<\/div>\n<\/div>\n\n\n\nQuintiles<\/h2>\n\n\n\n
\n\n![\"\"](\"https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/grafik-11.png\")
<\/figure>\n<\/div>\n\n\n\n\nPirmiausia dar kart\u0105 de\u0161iniuoju pel\u0117s klavi\u0161u spustel\u0117kite lauk\u0105, kur\u012f norite diskretizuoti. M\u016bs\u0173 pavyzdyje tai yra \"Poveikio pavyzdys\". Tada pasirenkame \"New measure\" (nauja priemon\u0117). Vir\u0161 prietais\u0173 skydelio atveriamas DAX redaktorius.<\/p>\n<\/div>\n<\/div>\n\n\n\n
Dabar pridedame \u0161\u012f kod\u0105, pritaikyt\u0105 j\u016bs\u0173 duomen\u0173 rinkinio lentelei ir norimam stulpeliui. Svarbu - \u0161is pavyzdys skirtas kvantiliams. Jei reikia, galite j\u012f pritaikyti procentiliams:<\/p>\n\n\n\n
Kvantilis =\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(lentel\u0117[stulpelis])\nreturn\nIF(HASONEVALUE(Table[Column]),\n\t\tIF(ThisVal FirstQuantile && ThisVal SecondQuantile && ThisVal ThirdQuantile && ThisVal <= FourthQuantile, 4,\n\t\t\t\t5)\n\t\t\t)\n\t\t)\n) )<\/code><\/pre>\n\n\n\n\n\nParuo\u0161ta! Taip diskretizavome ir gavome reik\u0161mes nuo 1 iki 5. Dabar \u0161\u012f lauk\u0105 galime naudoti savo rizikos matricai!<\/p>\n<\/div>\n\n\n\n
\n![\"\"](\"https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/grafik-12.png\")
<\/figure>\n<\/div>\n<\/div>\n\n\n\nPasirinktiniai slenks\u010diai<\/h2>\n\n\n\n
\n\n<\/figure>\n<\/div>\n\n\n\n\nPirmiausia dar kart\u0105 de\u0161iniuoju pel\u0117s klavi\u0161u spustel\u0117kite lauk\u0105, kur\u012f norite diskretizuoti. M\u016bs\u0173 pavyzdyje tai yra \"Poveikio pavyzdys\". Tada pasirenkame \"New measure\" (nauja priemon\u0117). Vir\u0161 prietais\u0173 skydelio atveriamas DAX redaktorius.<\/p>\n<\/div>\n<\/div>\n\n\n\n
Dabar pridedame \u0161\u012f kod\u0105, pritaikyt\u0105 j\u016bs\u0173 duomen\u0173 rinkinio lentelei ir norimam stulpeliui:<\/p>\n\n\n\n
Custom_Thresholds =\nvar FirstThreshold = your_first_threshold_value_here\nvar SecondThreshold = your_second_threshold_value_here\nvar ThirdThreshold = your_third_threshold_threshold_value_here\nvar FourthThreshold = your_fourth_threshold_value_value_here\nvar ThisVal = Min(Table[Column])\nreturn\nIF(HASONEVALUE(Table[Column]),\n\t\tIF(ThisVal FirstThreshold && ThisVal SecondThreshold && ThisVal ThirdThreshold && ThisVal <= FourthThreshold, 4,\n\t\t\t\t5)\n\t\t\t)\n\t\t)\n) )<\/code><\/pre>\n\n\n\n\u017dod\u017eiai \u012f Skai\u010diai<\/h2>\n\n\n\n
\n\n![\"\"](\"https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/grafik-17.png\")
<\/figure>\n<\/div>\n\n\n\n\nPirmiausia meniu spustel\u0117kite \"Transform data\". Taip atidaromas \"Power Query Editor\".<\/p>\n<\/div>\n<\/div>\n\n\n\n
\n\nPasirenkate stulpel\u012f, kur\u012f norite transformuoti. \u0160iame pavyzdyje tai stulpelis \"Tikimyb\u0117s tekstas\". Tada vir\u0161utiniame kairiajame kampe spustel\u0117kite \"Column from Examples\" (stulpelis i\u0161 pavyzd\u017ei\u0173) ir pasirinkite \"From Selection\" (i\u0161 pasirinkimo).<\/p>\n<\/div>\n\n\n\n
\n![\"\"](\"https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/grafik-18.png\")
<\/figure>\n<\/div>\n<\/div>\n\n\n\n\n\n![\"\"](\"https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/grafik-19.png\")
<\/figure>\n<\/div>\n\n\n\n\nPridedamas naujas stulpelis. Spustel\u0117kite pirm\u0105j\u012f naujojo stulpelio langel\u012f ir \u012fterpkite norim\u0105 skaitin\u0119 vert\u0119. M\u016bs\u0173 pavyzdyje \"Remote\" (ma\u017eiausia i\u0161rai\u0161ka) atitinka reik\u0161m\u0119 \"1\". Vis\u0173 ver\u010di\u0173 atskirai keisti nereikia. \"Power BI\" atpa\u017e\u012fsta skai\u010dius ir automati\u0161kai juos atvaizduoja pagal <\/strong><\/em>du<\/strong> j\u016bs\u0173 pavyzd\u017eiai.<\/strong><\/em><\/p>\n<\/div>\n<\/div>\n\n\n\n
\n\nTai pakartokite kiekvienai duomen\u0173 rinkinio i\u0161rai\u0161kai...<\/p>\n<\/div>\n\n\n\n
\n![\"\"](\"https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/grafik-20.png\")
<\/figure>\n<\/div>\n<\/div>\n\n\n\n\n\n![\"\"](\"https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/grafik-21.png\")
<\/figure>\n<\/div>\n\n\n\n\nKai atvaizduosite paskutin\u0119 i\u0161rai\u0161k\u0105, galiausiai spustel\u0117kite \"Gerai\" . \u0160tai taip: \"Tikimyb\u0117\" transformuotas stulpelis. Pakartokite tai su \"Poveikiu\" ir tur\u0117site reikiam\u0105 duomen\u0173 format\u0105. Pasirinkome \u0161i\u0105 logik\u0105 nuo 1 iki 10, nes kiekvienas turi skirting\u0105 penki\u0173 kategorij\u0173 formuluot\u0119.<\/p>\n<\/div>\n<\/div>","protected":false},"excerpt":{"rendered":"
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 … <\/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\/lt\/wp-json\/wp\/v2\/pages\/8499","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.leaplytics.de\/lt\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.leaplytics.de\/lt\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.leaplytics.de\/lt\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.leaplytics.de\/lt\/wp-json\/wp\/v2\/comments?post=8499"}],"version-history":[{"count":2,"href":"https:\/\/www.leaplytics.de\/lt\/wp-json\/wp\/v2\/pages\/8499\/revisions"}],"predecessor-version":[{"id":13647,"href":"https:\/\/www.leaplytics.de\/lt\/wp-json\/wp\/v2\/pages\/8499\/revisions\/13647"}],"wp:attachment":[{"href":"https:\/\/www.leaplytics.de\/lt\/wp-json\/wp\/v2\/media?parent=8499"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
- Nuo 21 iki 40<\/em><\/li>\n\n\n\n