- \n
- 0 l\u012bdz 20<\/em><\/li>\n\n\n\n
- 21 l\u012bdz 40<\/em><\/li>\n\n\n\n
- 41 l\u012bdz 60<\/em><\/li>\n\n\n\n
- 61 l\u012bdz 80<\/em><\/li>\n\n\n\n
- 81 l\u012bdz 100<\/em><\/li>\n<\/ul>\n\n\n\n
T\u0101p\u0113c taj\u0101 nav \u0146emts v\u0113r\u0101 risku daudzums atsevi\u0161\u0137os konteineros.<\/strong> Datu diapazoni ir sadal\u012bti vien\u0101di.<\/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\nS\u0101nu josl\u0101 vispirms ar peles labo pogu noklik\u0161\u0137iniet uz lauka, kuru v\u0113laties p\u0101rveidot. M\u016bsu piem\u0113r\u0101 tas ir lauks \"Ietekmes piem\u0113rs\".<\/p>\n\n\n\n
P\u0113c tam ar kreiso peles pogu noklik\u0161\u0137iniet uz \"Jauna grupa\". Atveras logs \"Grupas\".<\/p>\n<\/div>\n<\/div>\n\n\n\n
\n\n\u0160eit izv\u0113lieties opciju \"Bin type\" (tvert\u0146u veids). Apak\u0161\u0113j\u0101 kreisaj\u0101 pus\u0113 k\u0101 \"Bin Count\" (Grozu skaits) ievadiet v\u0113rt\u012bbu \"10\". P\u0113c tam sada\u013c\u0101 \"Bin size\" autom\u0101tiski tiek apr\u0113\u0137in\u0101ts tvert\u0146u platums.<\/p>\n\n\n\n
Visbeidzot noklik\u0161\u0137iniet uz \"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\nP\u0113d\u0113j\u0101 sol\u012b v\u0113lreiz noklik\u0161\u0137iniet uz jaunizveidot\u0101 lauka s\u0101nu josl\u0101.<\/p>\n\n\n\n
Tagad atkal tiek par\u0101d\u012bts logs \"Grupas\".<\/p>\n<\/div>\n<\/div>\n\n\n\n
\n\n\u0160eit izv\u0113lieties grupas veidu \"List\", nevis \"Bin\". Kreisaj\u0101 lodzi\u0146\u0101 par\u0101d\u0101s nesagrup\u0113t\u0101s v\u0113rt\u012bbas.<\/p>\n\n\n\n
Tagad varat s\u0101kt un atlas\u012bt katru v\u0113rt\u012bbu un p\u0101rvietot to uz labo kolonnu, izmantojot pogu \"Grupa\".<\/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\nGandr\u012bz gatavs! Tagad desmit v\u0113rt\u012bb\u0101m pie\u0161\u0137iriet v\u0113rt\u012bbas no 1 l\u012bdz 10, divreiz klik\u0161\u0137inot uz katras virsgrupas un ievietojot v\u0113rt\u012bbas. Visbeidzot j\u016bs noklik\u0161\u0137in\u0101t uz \"OK\".<\/p>\n<\/div>\n<\/div>\n\n\n\n
\n\nPaveikts! J\u016bs esat p\u0101rveidojis datus un tagad varat tos vilkt uz ass m\u016bsu riska matric\u0101.<\/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\nVispirms v\u0113lreiz ar peles labo pogu noklik\u0161\u0137iniet uz lauka, kuru v\u0113lamies diskretiz\u0113t. M\u016bsu piem\u0113r\u0101 tas ir \"Ietekmes piem\u0113rs\". P\u0113c tam izv\u0113lamies \"Jauns pas\u0101kums\". Virs pane\u013ca tiek atv\u0113rts DAX redaktors.<\/p>\n<\/div>\n<\/div>\n\n\n\n
Tagad pievienojam \u0161\u0101du kodu, kas piel\u0101gots j\u016bsu datu kopas tabulai un v\u0113lamajai kolonnai. Svar\u012bgi - \u0161is ir piem\u0113rs kvintil\u0113m. Vajadz\u012bbas gad\u012bjum\u0101 to var piel\u0101got procentil\u0113m:<\/p>\n\n\n\n
Kvantilis =\nvar FirstQuantile = CALCULATE(PERCENTILE.INC(Table[Column], .2), ALL(Table[Column]))\nvar SecondQuantile = CALCULATE(PERCENTILE.INC(Table[Kolonna], .4), ALL(Table[Kolonna]))\nvar ThirdQuantile = CALCULATE(PERCENTILE.INC(Table[Kolonna], .6), ALL(Table[Kolonna]))\nvar Ceturtais kvartils = CALCULATE(PERCENTILE.INC(Tabula[Kolonna], .8), ALL(Tabula[Kolonna]))\nvar ThisVal = Min(Tabula[Kolonna])\nreturn\nIF(HASONEVALUE(Tabula[Kolonna]),\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\nGatavs! T\u0101d\u0113j\u0101di esam diskretiz\u0113ju\u0161i un ieguvu\u0161i v\u0113rt\u012bbas no 1 l\u012bdz 5. Tagad m\u0113s varam izmantot \u0161o lauku m\u016bsu riska 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\nPiel\u0101gotie sliek\u0161\u0146i<\/h2>\n\n\n\n
\n\n<\/figure>\n<\/div>\n\n\n\n\nVispirms v\u0113lreiz ar peles labo pogu noklik\u0161\u0137iniet uz lauka, kuru v\u0113lamies diskretiz\u0113t. M\u016bsu piem\u0113r\u0101 tas ir \"Ietekmes piem\u0113rs\". P\u0113c tam izv\u0113lamies \"Jauns pas\u0101kums\". Virs pane\u013ca tiek atv\u0113rts DAX redaktors.<\/p>\n<\/div>\n<\/div>\n\n\n\n
Tagad pievienojam \u0161\u0101du kodu, kas piel\u0101gots j\u016bsu datu kopas tabulai un v\u0113lamajai kolonnai:<\/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(Tabula[Kolonna])\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\nV\u0101rdi uz Skait\u013ci<\/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\nVispirms izv\u0113ln\u0113 noklik\u0161\u0137iniet uz \"P\u0101rveidot datus\". T\u0101d\u0113j\u0101di tiek atv\u0113rts Power Query Editor.<\/p>\n<\/div>\n<\/div>\n\n\n\n
\n\nAtlasiet kolonnu, kuru v\u0113laties p\u0101rveidot. \u0160aj\u0101 piem\u0113r\u0101 t\u0101 ir sleja \"Teksts par varb\u016bt\u012bbu\". P\u0113c tam kreisaj\u0101 aug\u0161\u0113j\u0101 st\u016br\u012b noklik\u0161\u0137iniet uz \"Kolonna no piem\u0113riem\" un izv\u0113lieties \"No atlases\".<\/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\nTiek pievienota jauna sleja. Noklik\u0161\u0137iniet uz jaun\u0101s kolonnas pirm\u0101s \u0161\u016bnas un ievietojiet v\u0113lamo skaitlisko v\u0113rt\u012bbu. M\u016bsu piem\u0113r\u0101 \"Remote\" (zem\u0101k\u0101 izteiksme) atbilst v\u0113rt\u012bbai \"1\". Visas v\u0113rt\u012bbas nav j\u0101maina atsevi\u0161\u0137i. Power BI atpaz\u012bst skait\u013cus un autom\u0101tiski att\u0113lo tos atbilsto\u0161i <\/strong><\/em>divi<\/strong> piem\u0113ri no j\u016bsu.<\/strong><\/em><\/p>\n<\/div>\n<\/div>\n\n\n\n
\n\nAtk\u0101rtojiet \u0161o darb\u012bbu katrai datu kopas izteiksmei...<\/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\nKad esat kart\u0113jis p\u0113d\u0113jo izteiksmi, noklik\u0161\u0137iniet uz \"OK\" . L\u016bk, tas ir tas, kas jums j\u0101dara: P\u0101rveidota kolonna \"Iesp\u0113jam\u012bba\". Atk\u0101rtojiet to pa\u0161u ar \"Ietekmi\", un jums ir vajadz\u012bgais datu form\u0101ts. M\u0113s izv\u0113l\u0113j\u0101mies \u0161o lo\u0123iku no 1 l\u012bdz 10, jo katram ir at\u0161\u0137ir\u012bgs formul\u0113jums piec\u0101m kategorij\u0101m.<\/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\/lv\/wp-json\/wp\/v2\/pages\/8499","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.leaplytics.de\/lv\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.leaplytics.de\/lv\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.leaplytics.de\/lv\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.leaplytics.de\/lv\/wp-json\/wp\/v2\/comments?post=8499"}],"version-history":[{"count":2,"href":"https:\/\/www.leaplytics.de\/lv\/wp-json\/wp\/v2\/pages\/8499\/revisions"}],"predecessor-version":[{"id":13647,"href":"https:\/\/www.leaplytics.de\/lv\/wp-json\/wp\/v2\/pages\/8499\/revisions\/13647"}],"wp:attachment":[{"href":"https:\/\/www.leaplytics.de\/lv\/wp-json\/wp\/v2\/media?parent=8499"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
- 21 l\u012bdz 40<\/em><\/li>\n\n\n\n