- \n
- 0 till 20<\/em><\/li>\n\n\n\n
- 21 till 40 \u00e5r<\/em><\/li>\n\n\n\n
- 41 till 60 \u00e5r<\/em><\/li>\n\n\n\n
- 61 till 80<\/em><\/li>\n\n\n\n
- 81 till 100<\/em><\/li>\n<\/ul>\n\n\n\n
Detta tar d\u00e4rf\u00f6r inte h\u00e4nsyn till m\u00e4ngden risker i de enskilda soptunnorna.<\/strong> Dataintervallen \u00e4r bara j\u00e4mnt f\u00f6rdelade.<\/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\nI sidof\u00e4ltet h\u00f6gerklickar du f\u00f6rst p\u00e5 det f\u00e4lt som du vill omvandla. I v\u00e5rt exempel \u00e4r det f\u00e4ltet \"Impact Example\".<\/p>\n\n\n\n
V\u00e4lj sedan \"Ny grupp\" med ett v\u00e4nsterklick. F\u00f6nstret \"Grupper\" \u00f6ppnas.<\/p>\n<\/div>\n<\/div>\n\n\n\n
\n\nH\u00e4r v\u00e4ljer du alternativet \"Antal fack\" f\u00f6r \"Typ av fack\". L\u00e4ngst ned till v\u00e4nster anger du v\u00e4rdet \"10\" som \"Antal fack\". D\u00e4refter ber\u00e4knas fackens bredd automatiskt under \"Fackstorlek\".<\/p>\n\n\n\n
Klicka slutligen p\u00e5 \"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\nI det sista steget klickar du p\u00e5 det nyskapade f\u00e4ltet i sidof\u00e4ltet igen.<\/p>\n\n\n\n
Nu visas f\u00f6nstret \"Grupper\" igen.<\/p>\n<\/div>\n<\/div>\n\n\n\n
\n\nH\u00e4r v\u00e4ljer du grupptypen \"List\" i st\u00e4llet f\u00f6r \"Bin\". De ogrupperade v\u00e4rdena visas i den v\u00e4nstra rutan.<\/p>\n\n\n\n
Du b\u00f6rjar nu med att markera varje v\u00e4rde och flytta det till den h\u00f6gra kolumnen med hj\u00e4lp av knappen \"Gruppera\".<\/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\nN\u00e4stan klart! Du tilldelar nu v\u00e4rdena 1 till 10 till de tio v\u00e4rdena genom att dubbelklicka p\u00e5 varje supergrupp och infoga v\u00e4rdena. Slutligen klickar du p\u00e5 \"OK\".<\/p>\n<\/div>\n<\/div>\n\n\n\n
\n\nNu \u00e4r det klart! Du har omvandlat uppgifterna och kan nu dra dem till en axel i v\u00e5r riskmatris.<\/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\nVi h\u00f6gerklickar f\u00f6rst igen p\u00e5 det f\u00e4lt som vi vill diskretisera. I v\u00e5rt exempel \u00e4r det \"Impact Example\". Sedan v\u00e4ljer vi \"New measure\". DAX Editor \u00f6ppnas ovanf\u00f6r instrumentpanelen.<\/p>\n<\/div>\n<\/div>\n\n\n\n
Vi l\u00e4gger nu till f\u00f6ljande kod, anpassad till tabellen och \u00f6nskad kolumn i ditt dataset. Viktigt - detta \u00e4r ett exempel f\u00f6r kvintiler. Du kan anpassa detta till percentiler om det beh\u00f6vs:<\/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(Tabell[Kolumn])\nretur\nIF(HASONEVALUE(Tabell[Kolumn]),\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\nKlart! Vi har allts\u00e5 diskretiserat och f\u00e5tt v\u00e4rdena 1 till 5. Vi kan nu anv\u00e4nda detta f\u00e4lt f\u00f6r v\u00e5r riskmatris!<\/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\nAnpassade tr\u00f6sklar<\/h2>\n\n\n\n
\n\n<\/figure>\n<\/div>\n\n\n\n\nVi h\u00f6gerklickar f\u00f6rst igen p\u00e5 det f\u00e4lt som vi vill diskretisera. I v\u00e5rt exempel \u00e4r det \"Impact Example\". Sedan v\u00e4ljer vi \"New measure\". DAX Editor \u00f6ppnas ovanf\u00f6r instrumentpanelen.<\/p>\n<\/div>\n<\/div>\n\n\n\n
Vi l\u00e4gger nu till f\u00f6ljande kod, anpassad till tabellen och den \u00f6nskade kolumnen i din dataset:<\/p>\n\n\n\n
Anpassade_Tr\u00f6sklar =\nvar FirstThreshold = ditt_f\u00f6rsta_tr\u00f6skelv\u00e4rde_h\u00e4r\nvar SecondThreshold = ditt_andra_tr\u00f6skelv\u00e4rde_h\u00e4r\nvar Tredje tr\u00f6skelv\u00e4rdet = ditt_tredje_tr\u00f6skelv\u00e4rdet_v\u00e4rde_h\u00e4r\nvar FourthThreshold = din_fjerde_tr\u00f6skel_v\u00e4rde_h\u00e4r\nvar ThisVal = Min(Tabell[Kolumn])\nretur\nIF(HASONEVALUE(Table[Column]),\n\t\tIF(ThisVal FirstThreshold && ThisVal SecondThreshold && ThisVal ThirdThreshold && ThisVal ThirdThreshold && ThisVal <= FourthThreshold, 4,\n\t\t\t\t5)\n\t\t\t)\n\t\t)\n) )<\/code><\/pre>\n\n\n\nOrd till siffror<\/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\nF\u00f6rst klickar du p\u00e5 \"Transform data\" i menyn. D\u00e5 \u00f6ppnas Power Query Editor.<\/p>\n<\/div>\n<\/div>\n\n\n\n
\n\nDu v\u00e4ljer den kolumn som du vill transformera. I det h\u00e4r exemplet \u00e4r det kolumnen \"Sannolikhetstext\". Klicka sedan p\u00e5 \"Kolumn fr\u00e5n exempel\" i det \u00f6vre v\u00e4nstra h\u00f6rnet och v\u00e4lj \"Fr\u00e5n urval\".<\/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\nEn ny kolumn l\u00e4ggs till. Du klickar p\u00e5 den f\u00f6rsta cellen i den nya kolumnen och anger \u00f6nskat numeriskt v\u00e4rde. I v\u00e5rt exempel motsvarar \"Remote\" (l\u00e4gsta uttrycket) v\u00e4rdet \"1\". Du beh\u00f6ver inte \u00e4ndra alla v\u00e4rden individuellt. Power BI k\u00e4nner igen siffrorna och mappar dem automatiskt enligt <\/strong><\/em>tv\u00e5<\/strong> exempel p\u00e5 dina.<\/strong><\/em><\/p>\n<\/div>\n<\/div>\n\n\n\n
\n\nDu upprepar detta f\u00f6r varje uttryck i din dataupps\u00e4ttning ...<\/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\nN\u00e4r du har mappat ditt sista uttryck klickar du slutligen p\u00e5 \"OK\" . Och s\u00e5 har du det: En transformerad kolumn f\u00f6r \"Probability\". Du upprepar detta med \"Impact\" och du har det dataformat som kr\u00e4vs. Vi valde den h\u00e4r 1 till 10-logiken eftersom alla har olika formuleringar f\u00f6r de fem kategorierna.<\/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\/sv\/wp-json\/wp\/v2\/pages\/8499","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.leaplytics.de\/sv\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.leaplytics.de\/sv\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.leaplytics.de\/sv\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.leaplytics.de\/sv\/wp-json\/wp\/v2\/comments?post=8499"}],"version-history":[{"count":2,"href":"https:\/\/www.leaplytics.de\/sv\/wp-json\/wp\/v2\/pages\/8499\/revisions"}],"predecessor-version":[{"id":13647,"href":"https:\/\/www.leaplytics.de\/sv\/wp-json\/wp\/v2\/pages\/8499\/revisions\/13647"}],"wp:attachment":[{"href":"https:\/\/www.leaplytics.de\/sv\/wp-json\/wp\/v2\/media?parent=8499"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
- 21 till 40 \u00e5r<\/em><\/li>\n\n\n\n