- \n
- 0-20<\/em><\/li>\n\n\n\n
- 21 \u00e9s 40 k\u00f6z\u00f6tt<\/em><\/li>\n\n\n\n
- 41-60<\/em><\/li>\n\n\n\n
- 61-80<\/em><\/li>\n\n\n\n
- 81-100<\/em><\/li>\n<\/ul>\n\n\n\n
Ez teh\u00e1t nem veszi figyelembe az egyes t\u00e1rol\u00f3kon bel\u00fcli kock\u00e1zatok mennyis\u00e9g\u00e9t.<\/strong> Az adattartom\u00e1nyok csak egyenl\u0151en vannak felosztva.<\/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\nAz oldals\u00e1vban el\u0151sz\u00f6r kattintson jobb gombbal az \u00e1talak\u00edtani k\u00edv\u00e1nt mez\u0151re. P\u00e9ld\u00e1nkban a \"Impact Example\" mez\u0151t.<\/p>\n\n\n\n
Ezut\u00e1n v\u00e1lassza az \"\u00daj csoport\" lehet\u0151s\u00e9get balra kattintva. Megny\u00edlik a \"Csoportok\" ablak.<\/p>\n<\/div>\n<\/div>\n\n\n\n
\n\nItt v\u00e1lassza ki a \"L\u00e1d\u00e1k sz\u00e1ma\" opci\u00f3t a \"L\u00e1dat\u00edpus\" eset\u00e9ben. A bal als\u00f3 sarokban a \"Bin Count\" (t\u00e1rol\u00f3k sz\u00e1ma) mez\u0151be a \"10\" \u00e9rt\u00e9ket \u00edrja be. Ezut\u00e1n a program automatikusan kisz\u00e1m\u00edtja a t\u00e1rol\u00f3k sz\u00e9less\u00e9g\u00e9t a \"Bin size\" (t\u00e1rol\u00f3k m\u00e9rete) alatt.<\/p>\n\n\n\n
V\u00e9g\u00fcl kattintson az \"OK\" gombra.<\/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\nAz utols\u00f3 l\u00e9p\u00e9sben kattintson ism\u00e9t az \u00fajonnan l\u00e9trehozott mez\u0151re az oldals\u00e1vban.<\/p>\n\n\n\n
Most ism\u00e9t megjelenik a \"Csoportok\" ablak.<\/p>\n<\/div>\n<\/div>\n\n\n\n
\n\nItt v\u00e1lassza ki a \"Lista\" csoportt\u00edpust a \"Lomt\u00e1r\" helyett. A csoportos\u00edtatlan \u00e9rt\u00e9kek a bal oldali mez\u0151ben jelennek meg.<\/p>\n\n\n\n
Most ind\u00edtsa el \u00e9s jel\u00f6lje ki az egyes \u00e9rt\u00e9keket, majd a \"Csoportos\u00edt\u00e1s\" gomb seg\u00edts\u00e9g\u00e9vel helyezze \u00e1t a jobb oldali oszlopba.<\/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\nMajdnem k\u00e9sz! Most az 1-t\u0151l 10-ig terjed\u0151 \u00e9rt\u00e9keket rendelj\u00fck a t\u00edz \u00e9rt\u00e9khez \u00fagy, hogy dupl\u00e1n kattintunk az egyes szupercsoportokra, \u00e9s beillesztj\u00fck az \u00e9rt\u00e9keket. V\u00e9g\u00fcl kattintson az \"OK\" gombra.<\/p>\n<\/div>\n<\/div>\n\n\n\n
\n\nK\u00e9sz! \u00c1talak\u00edtotta az adatokat, \u00e9s most m\u00e1r r\u00e1h\u00fazhatja azokat a kock\u00e1zati m\u00e1trixunk egyik tengely\u00e9re.<\/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\nEl\u0151sz\u00f6r ism\u00e9t jobb eg\u00e9rgombbal kattintsunk a diszkretiz\u00e1lni k\u00edv\u00e1nt mez\u0151re. P\u00e9ld\u00e1nkban ez a \"Impact Example\". Ezut\u00e1n kiv\u00e1lasztjuk az \"\u00daj int\u00e9zked\u00e9s\" lehet\u0151s\u00e9get. A DAX-szerkeszt\u0151 megny\u00edlik a m\u0171szerfal felett.<\/p>\n<\/div>\n<\/div>\n\n\n\n
Most hozz\u00e1adjuk a k\u00f6vetkez\u0151 k\u00f3dot, az adat\u00e1llom\u00e1ny t\u00e1bl\u00e1zat\u00e1hoz \u00e9s a k\u00edv\u00e1nt oszlophoz igaz\u00edtva. Fontos - ez egy p\u00e9lda a kvintilisekre. Sz\u00fcks\u00e9g eset\u00e9n a percentilisekre is adapt\u00e1lhatja:<\/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(T\u00e1bla[oszlop])\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\nK\u00e9szen \u00e1llunk! \u00cdgy diszkretiz\u00e1ltuk \u00e9s megkaptuk az 1-5 \u00e9rt\u00e9keket. Most m\u00e1r haszn\u00e1lhatjuk ezt a mez\u0151t a kock\u00e1zati m\u00e1trixunkhoz!<\/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\nEgy\u00e9ni k\u00fcsz\u00f6b\u00e9rt\u00e9kek<\/h2>\n\n\n\n
\n\n<\/figure>\n<\/div>\n\n\n\n\nEl\u0151sz\u00f6r ism\u00e9t jobb eg\u00e9rgombbal kattintsunk a diszkretiz\u00e1lni k\u00edv\u00e1nt mez\u0151re. P\u00e9ld\u00e1nkban ez a \"Impact Example\". Ezut\u00e1n kiv\u00e1lasztjuk az \"\u00daj int\u00e9zked\u00e9s\" lehet\u0151s\u00e9get. A DAX-szerkeszt\u0151 megny\u00edlik a m\u0171szerfal felett.<\/p>\n<\/div>\n<\/div>\n\n\n\n
Most hozz\u00e1adjuk a k\u00f6vetkez\u0151 k\u00f3dot, az adat\u00e1llom\u00e1ny t\u00e1bl\u00e1zat\u00e1hoz \u00e9s a k\u00edv\u00e1nt oszlophoz igaz\u00edtva:<\/p>\n\n\n\n
Custom_Thresholds =\nvar FirstThreshold = a te_els\u0151_k\u00fcsz\u00f6b\u00e9rt\u00e9ked_itt_van\nvar SecondThreshold = az \u00f6n_m\u00e1sodik_k\u00fcsz\u00f6b\u00e9rt\u00e9k_itt_van\nvar ThirdThreshold = a_harmadik_k\u00fcsz\u00f6b\u00e9rt\u00e9ked_hol\nvar FourthThreshold = your_fourth_threshold_value_here\nvar ThisVal = Min(Table[oszlop])\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\nSzavak to Sz\u00e1mok<\/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\nEl\u0151sz\u00f6r kattintson a men\u00fcben az \"Adatok \u00e1talak\u00edt\u00e1sa\" men\u00fcpontra. Ezzel megny\u00edlik a Power Query Editor.<\/p>\n<\/div>\n<\/div>\n\n\n\n
\n\nKiv\u00e1lasztja az \u00e1talak\u00edtani k\u00edv\u00e1nt oszlopot. Ebben a p\u00e9ld\u00e1ban ez a \"Val\u00f3sz\u00edn\u0171s\u00e9gi sz\u00f6veg\" oszlop. Ezut\u00e1n a bal fels\u0151 sarokban kattintson a \"P\u00e9ld\u00e1kb\u00f3l sz\u00e1rmaz\u00f3 oszlop\" gombra, majd v\u00e1lassza a \"Kiv\u00e1laszt\u00e1sb\u00f3l\" lehet\u0151s\u00e9get.<\/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\nEgy \u00faj oszlop ker\u00fcl hozz\u00e1ad\u00e1sra. Kattintson az \u00faj oszlop els\u0151 cell\u00e1j\u00e1ra, \u00e9s adja meg a k\u00edv\u00e1nt sz\u00e1m\u00e9rt\u00e9ket. P\u00e9ld\u00e1nkban a \"Remote\" (legalacsonyabb kifejez\u00e9s) az \"1\" \u00e9rt\u00e9knek felel meg. Nem kell minden \u00e9rt\u00e9ket k\u00fcl\u00f6n-k\u00fcl\u00f6n megv\u00e1ltoztatnia. A Power BI felismeri a sz\u00e1mokat, \u00e9s automatikusan hozz\u00e1rendeli \u0151ket a k\u00f6vetkez\u0151k szerint <\/strong><\/em>k\u00e9t<\/strong> p\u00e9ld\u00e1k a ti\u00e9db\u0151l.<\/strong><\/em><\/p>\n<\/div>\n<\/div>\n\n\n\n
\n\nEzt megism\u00e9tli az adathalmaz minden egyes kifejez\u00e9s\u00e9re ...<\/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\nMiut\u00e1n lek\u00e9pezte az utols\u00f3 kifejez\u00e9st, v\u00e9g\u00fcl kattintson az \"OK\" gombra. Meg is van: A \"Val\u00f3sz\u00edn\u0171s\u00e9g\" \u00e1talak\u00edtott oszlopa. Ezt megism\u00e9tli a \"Impact\" (Hat\u00e1s) sorral, \u00e9s m\u00e1ris megvan a k\u00edv\u00e1nt adatform\u00e1tum. Az\u00e9rt v\u00e1lasztottuk ezt az 1-t\u0151l 10-ig tart\u00f3 logik\u00e1t, mert mindenki m\u00e1sk\u00e9nt fogalmazza meg az \u00f6t kateg\u00f3ri\u00e1t.<\/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\/hu\/wp-json\/wp\/v2\/pages\/8499","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.leaplytics.de\/hu\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.leaplytics.de\/hu\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.leaplytics.de\/hu\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.leaplytics.de\/hu\/wp-json\/wp\/v2\/comments?post=8499"}],"version-history":[{"count":2,"href":"https:\/\/www.leaplytics.de\/hu\/wp-json\/wp\/v2\/pages\/8499\/revisions"}],"predecessor-version":[{"id":13647,"href":"https:\/\/www.leaplytics.de\/hu\/wp-json\/wp\/v2\/pages\/8499\/revisions\/13647"}],"wp:attachment":[{"href":"https:\/\/www.leaplytics.de\/hu\/wp-json\/wp\/v2\/media?parent=8499"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
- 21 \u00e9s 40 k\u00f6z\u00f6tt<\/em><\/li>\n\n\n\n