{"id":3849,"date":"2024-06-16T17:39:38","date_gmt":"2024-06-16T14:39:38","guid":{"rendered":"https:\/\/webanalyst.ro\/?p=3849"},"modified":"2024-06-16T18:07:14","modified_gmt":"2024-06-16T15:07:14","slug":"containere-data-studio","status":"publish","type":"post","link":"https:\/\/webanalyst.ro\/blog\/2024\/containere-data-studio\/","title":{"rendered":"Containere \u00een Looker Studio"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Zilele trecute, Google Looker Studio a venit cu mai multe actualiz\u0103ri legate de vizualizarea datelor \u00een grafice.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Noile func\u021bionalit\u0103\u021bi ne permit s\u0103 grup\u0103m datele (<em><strong>Group Others<\/strong><\/em>), s\u0103 decidem pragurile care sunt afi\u0219ate (<em><strong>Bin calculated field type<\/strong><\/em>), s\u0103 personaliz\u0103m <em><strong>Data label<\/strong><\/em> prin mai multe op\u021biuni noi \u0219i chiar s\u0103 ne alegem culoarea cu care apar barele \u00een Timeline Chart dup\u0103 alt\u0103 dimensiune dec\u00e2t cele prezente deja \u00een grafic (<em><strong>Color by tooltip<\/strong><\/em>).<\/p>\n\n\n\n<!--more-->\n\n\n\n<h2 class=\"wp-block-heading\">Group Others<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Este o func\u021bionalitate care ne permite s\u0103 limit\u0103m num\u0103rul de observa\u021bii care pot ap\u0103rea \u00eentr-un grafic sau \u00eentr-un tabel.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">A\u0219a cum se poate vedea \u00een imaginea de deasupra articolului, am bifat s\u0103 am 7 elemente \u00een grafic, \u00eentre care \u0219i unul pentru&#8230; restul. \u00cen cazul meu, este vorba de toate ora\u0219ele care nu sunt \u00een top 6 ca num\u0103r de utilizatori unici.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Op\u021biunea de <em>Group Others<\/em> apare \u00een tabul Style, pentru urm\u0103tarele tipuri de vizualiz\u0103ri:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Table charts<\/li>\n\n\n\n<li>Time series charts<\/li>\n\n\n\n<li>Bar charts and column charts<\/li>\n\n\n\n<li>Pie charts<\/li>\n\n\n\n<li>Line charts and combo charts<\/li>\n\n\n\n<li>Area charts<\/li>\n\n\n\n<li>Pivot table charts<\/li>\n\n\n\n<li>Treemap charts<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Bin calculated field type<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u00cen vizualizarea datelor, <em>bins<\/em> reprezint\u0103 un fel de containere care grupeaz\u0103 puncte de date cu caracteristici comune. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Concret, putem edita graficele, \u00een a\u0219a fel \u00eenc\u00e2t s\u0103 \u00eei spunem exact ce fel de date s\u0103 includ\u0103 \u00een fiecare element. Anterior, se putea face acest lucru folosind formulele <code>CASE WHEN<\/code> sau din SQL. Prin introducerea acestei noi func\u021bionalit\u0103\u021bi, avem aceast\u0103 posibilitate \u00een interfa\u021ba grafic\u0103.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Pentru a crea un <em>bin<\/em> \u00een sursa de date, trebuie s\u0103 o edit\u0103m pe cea din urm\u0103. Acest lucru se face din meniul <em>Resuources<\/em>, de unde vom alege op\u021biunea <em>Manage added data sources<\/em>. Urm\u0103torul pas este s\u0103 ad\u0103ug\u0103m un c\u00e2mp, unde vom avea mai multe op\u021biuni, printre care \u0219i <em>Add bin<\/em>.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"977\" height=\"545\" src=\"https:\/\/webanalyst.ro\/blog\/wp-content\/uploads\/2024\/06\/looker-studio-bins.png\" alt=\"\" class=\"wp-image-3853\" srcset=\"https:\/\/webanalyst.ro\/blog\/wp-content\/uploads\/2024\/06\/looker-studio-bins.png 977w, https:\/\/webanalyst.ro\/blog\/wp-content\/uploads\/2024\/06\/looker-studio-bins-300x167.png 300w, https:\/\/webanalyst.ro\/blog\/wp-content\/uploads\/2024\/06\/looker-studio-bins-150x84.png 150w, https:\/\/webanalyst.ro\/blog\/wp-content\/uploads\/2024\/06\/looker-studio-bins-768x428.png 768w\" sizes=\"auto, (max-width: 977px) 100vw, 977px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">  Se pot crea dou\u0103 tipuri de <em>bins<\/em>:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Equal Sized<\/strong> &#8211; va \u00eemp\u0103r\u021bi datele \u00een game de m\u0103surare egale<\/li>\n\n\n\n<li><strong>Custom Sized<\/strong> &#8211; ne putem crea propriile game de m\u0103surare<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Un exemplu la care m\u0103 g\u00e2ndesc acum este \u00eemp\u0103r\u021birea utilizatorilor \u00een func\u021bie de num\u0103rul de comenzi. Pot fi cei cu o comand\u0103, cu dou\u0103 sau cu mai multe comenzi \u00eentr-un interval de timp. \u00cen exemplul de mai sus, pentru c\u0103 am ales 2 \u0219i 5, el ne va ar\u0103ta num\u0103rul persoanelor care au \u00eentre 2 \u0219i 5 comenzi.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Data label<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">C\u00e2teva dintre cele mai populare tipuri de grafice din Looker Studio, au \u00een tab-ul <em>Style<\/em> op\u021biunea de <em>Show data labels<\/em>, care va afi\u0219a \u0219i cifrele respective pe grafic. \u00cen func\u021bie de tipul de grafic, numele afi\u0219at pentru aceast\u0103 func\u021bionalitate poate diferi pu\u021bin.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Aplic\u00e2nd datele pe grafic, de acum avem posibilitatea de a edita \u0219i modul \u00een care apar acestea. Putem s\u0103 ne alegem tipul de font, culoarea, m\u0103rimea dar \u0219i stilul acestuia. De asemenea, ne putem alege culoarea din background, opacitatea \u0219i chiar set\u0103rile chenarului (care poate ap\u0103rea pentru anumite backgrounds).<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Noile op\u021biuni din <em>data label<\/em> sunt disponibile pentru urm\u0103toarele grafice:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Area charts<\/li>\n\n\n\n<li>Bar charts<\/li>\n\n\n\n<li>Column charts<\/li>\n\n\n\n<li>Line charts<\/li>\n\n\n\n<li>Combo charts<\/li>\n\n\n\n<li>Time series charts<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Color by tooltip<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u00cen urm\u0103 cu aproximativ o lun\u0103, scriam c\u0103 Looker Studio a lansat un nou tip de grafic, numit <a href=\"https:\/\/webanalyst.ro\/blog\/2024\/looker-studio-titluri-si-grafice-noi\/\" target=\"_blank\" rel=\"noreferrer noopener\">Timeline Chart<\/a>. Iat\u0103 c\u0103 deja avem actualiz\u0103ri la acesta!<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Dac\u0103 ini\u021bial aveam op\u021biunile <em>Color by row label<\/em> \u0219i <em>Color by bar label<\/em>, acum avem \u0219i <em><strong>Color by tooltip<\/strong><\/em>. Op\u021biunea cea nou\u0103 ne ajut\u0103 dac\u0103 vrem s\u0103 distingem barele din tabel \u00een func\u021bie de o alt\u0103 dimensiune fa\u021b\u0103 de cele folosite deja la <em>Row label<\/em> sau la <em>Bar label<\/em>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Partea util\u0103 este aceea c\u0103 putem folosi mai multe dimensiuni pentru graficul din Timeline Chart.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Noile tipuri de containere sau grup\u0103ri pentru date, precum \u0219i detaliile pentru grafice sunt foarte utile \u0219i m\u0103 bucur s\u0103 v\u0103d c\u0103 echipa de la Looker Studio are timp s\u0103 intre \u0219i \u00een astfel de detalii, dup\u0103 mul\u021bi ani \u00een care s-au ocupat mai mult de elementele de baz\u0103 pentru raportare \u0219i vizualizare de date.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Zilele trecute, Google Looker Studio a venit cu mai multe actualiz\u0103ri legate de vizualizarea datelor \u00een grafice. Noile func\u021bionalit\u0103\u021bi ne permit s\u0103 grup\u0103m datele (Group Others), s\u0103 decidem pragurile care sunt afi\u0219ate (Bin calculated field type), s\u0103 personaliz\u0103m Data label prin mai multe op\u021biuni noi \u0219i chiar s\u0103 ne alegem culoarea cu care apar barele [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":3850,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[867,11],"tags":[810,922,869,716],"class_list":["post-3849","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-data-studio","category-noutati","tag-data-studio","tag-dataviz","tag-grafic","tag-grupare"],"_links":{"self":[{"href":"https:\/\/webanalyst.ro\/blog\/wp-json\/wp\/v2\/posts\/3849","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/webanalyst.ro\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/webanalyst.ro\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/webanalyst.ro\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/webanalyst.ro\/blog\/wp-json\/wp\/v2\/comments?post=3849"}],"version-history":[{"count":4,"href":"https:\/\/webanalyst.ro\/blog\/wp-json\/wp\/v2\/posts\/3849\/revisions"}],"predecessor-version":[{"id":3855,"href":"https:\/\/webanalyst.ro\/blog\/wp-json\/wp\/v2\/posts\/3849\/revisions\/3855"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/webanalyst.ro\/blog\/wp-json\/wp\/v2\/media\/3850"}],"wp:attachment":[{"href":"https:\/\/webanalyst.ro\/blog\/wp-json\/wp\/v2\/media?parent=3849"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/webanalyst.ro\/blog\/wp-json\/wp\/v2\/categories?post=3849"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/webanalyst.ro\/blog\/wp-json\/wp\/v2\/tags?post=3849"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}