- \n
- 0 do 20<\/em><\/li>\n\n\n\n
- 21 do 40<\/em><\/li>\n\n\n\n
- 41 do 60<\/em><\/li>\n\n\n\n
- 61 do 80<\/em><\/li>\n\n\n\n
- 81 do 100<\/em><\/li>\n<\/ul>\n\n\n\n
To torej ne upo\u0161teva koli\u010dine tveganj v posameznih zabojnikih.<\/strong> Razponi podatkov so razdeljeni enako.<\/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\nV stranski vrstici najprej z desno tipko mi\u0161ke kliknite polje, ki ga \u017eelite preoblikovati. V na\u0161em primeru je to polje \"Primer u\u010dinka\".<\/p>\n\n\n\n
Nato z levim klikom izberite \"Nova skupina\". Odpre se okno \"Skupine\".<\/p>\n<\/div>\n<\/div>\n\n\n\n
\n\nTukaj za \"Tip ko\u0161a\" izberete mo\u017enost \"\u0160tevilo ko\u0161ev\". Na spodnji levi strani vnesete vrednost \"10\" kot \"Bin Count\". Nato se \u0161irina ko\u0161ar samodejno izra\u010duna v razdelku \"Bin size\" (Velikost ko\u0161are).<\/p>\n\n\n\n
Na koncu kliknite \"V redu\".<\/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\nV zadnjem koraku ponovno kliknite na novo ustvarjeno polje v stranski vrstici.<\/p>\n\n\n\n
Zdaj se znova prika\u017ee okno \"Skupine\".<\/p>\n<\/div>\n<\/div>\n\n\n\n
\n\nPri tem izberete vrsto skupine \"Seznam\" namesto \"Ko\u0161\". V levem polju se prika\u017eejo nepogrupirane vrednosti.<\/p>\n\n\n\n
Sedaj za\u010dnete in izberete vsako vrednost ter jo premaknete v desni stolpec z gumbom \"Skupina\".<\/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\nSkoraj pripravljen! Vrednosti od 1 do 10 zdaj pripi\u0161ite desetim vrednostim tako, da dvakrat kliknete na vsako nadskupino in vstavite vrednosti. Na koncu kliknete \"V redu\".<\/p>\n<\/div>\n<\/div>\n\n\n\n
\n\nKon\u010dano! Podatke ste preoblikovali in zdaj jih lahko povle\u010dete na os v na\u0161i matriki tveganj.<\/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\nNajprej ponovno kliknemo z desno tipko mi\u0161ke na polje, ki ga \u017eelimo diskretizirati. V na\u0161em primeru je to \"Primer u\u010dinka\". Nato izberemo \"New measure\" (Novo merilo). Nad nadzorno plo\u0161\u010do se odpre urejevalnik DAX.<\/p>\n<\/div>\n<\/div>\n\n\n\n
Zdaj dodamo naslednjo kodo, prilagojeno tabeli in \u017eelenemu stolpcu v va\u0161em naboru podatkov. Pomembno - to je primer za kvantile. Po potrebi ga lahko prilagodite za percentile:<\/p>\n\n\n\n
Kvantil =\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(Tabela[Stolpec])\nvrni\nIF(HASONEVALUE(Tabela[Stolpec]),\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\nPripravljen! Tako smo diskretizirali in dobili vrednosti od 1 do 5. To polje lahko zdaj uporabimo za na\u0161o matriko tveganja!<\/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\nPragovi po meri<\/h2>\n\n\n\n
\n\n<\/figure>\n<\/div>\n\n\n\n\nNajprej ponovno kliknemo z desno tipko mi\u0161ke na polje, ki ga \u017eelimo diskretizirati. V na\u0161em primeru je to \"Primer u\u010dinka\". Nato izberemo \"New measure\" (Novo merilo). Nad nadzorno plo\u0161\u010do se odpre urejevalnik DAX.<\/p>\n<\/div>\n<\/div>\n\n\n\n
Zdaj dodamo naslednjo kodo, prilagojeno tabeli in \u017eelenemu stolpcu v va\u0161em naboru podatkov:<\/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_value_here\nvar FourthThreshold = your_fourth_threshold_value_here\nvar ThisVal = Min(Tabela[Stolpec])\nvrni\nIF(HASONEVALUE(Tabela[Stolpec]),\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\nBesede v \u0161tevilke<\/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\nNajprej v meniju kliknite \"Transform data\". To odpre urejevalnik poizvedb Power Query Editor.<\/p>\n<\/div>\n<\/div>\n\n\n\n
\n\nIzberete stolpec, ki ga \u017eelite preoblikovati. V tem primeru je to stolpec \"Besedilo verjetnosti\". Nato v levem zgornjem kotu kliknite na \"Stolpec iz primerov\" in izberite \"Iz izbora\".<\/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\nDodan je nov stolpec. Kliknite na prvo celico novega stolpca in vstavite \u017eeleno \u0161tevil\u010dno vrednost. V na\u0161em primeru \"Remote\" (najni\u017eji izraz) ustreza vrednosti \"1\". Ni vam treba spreminjati vseh vrednosti posebej. Power BI prepozna \u0161tevilke in jih samodejno prika\u017ee glede na <\/strong><\/em>dva<\/strong> primeri va\u0161ega.<\/strong><\/em><\/p>\n<\/div>\n<\/div>\n\n\n\n
\n\nTo ponovite za vsak izraz v podatkovnem nizu...<\/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\nKo preslikate zadnji izraz, kliknite \"V redu\" . To je to: spremenjen stolpec za \"Verjetnost\". To ponovite tudi za \"U\u010dinek\" in dobili boste zahtevano obliko podatkov. Izbrali smo to logiko od 1 do 10, ker ima vsakdo druga\u010dno formulacijo za pet kategorij.<\/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\/sl\/wp-json\/wp\/v2\/pages\/8499","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.leaplytics.de\/sl\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.leaplytics.de\/sl\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.leaplytics.de\/sl\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.leaplytics.de\/sl\/wp-json\/wp\/v2\/comments?post=8499"}],"version-history":[{"count":2,"href":"https:\/\/www.leaplytics.de\/sl\/wp-json\/wp\/v2\/pages\/8499\/revisions"}],"predecessor-version":[{"id":13647,"href":"https:\/\/www.leaplytics.de\/sl\/wp-json\/wp\/v2\/pages\/8499\/revisions\/13647"}],"wp:attachment":[{"href":"https:\/\/www.leaplytics.de\/sl\/wp-json\/wp\/v2\/media?parent=8499"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
- 21 do 40<\/em><\/li>\n\n\n\n