{"id":2612,"date":"2019-10-25T12:13:22","date_gmt":"2019-10-25T09:13:22","guid":{"rendered":"https:\/\/webanalyst.ro\/?p=2612"},"modified":"2019-10-25T12:13:23","modified_gmt":"2019-10-25T09:13:23","slug":"formatare-data-studio","status":"publish","type":"post","link":"https:\/\/webanalyst.ro\/blog\/2019\/formatare-data-studio\/","title":{"rendered":"Formatare condi\u021bional\u0103 \u00een Google Data Studio"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Formatarea pe baza unor condi\u021bii este o func\u021bionalitate pe care o cunoa\u0219tem cu to\u021bii din produsele software de calcul tabelar, a\u0219adar este folosit\u0103 \u00een multe dintre rapoartele care sunt create \u0219i trimise. Cum Google \u00eencearc\u0103 s\u0103 mute raportarea din aceste instrumente spre Data Studio, \u00een urm\u0103 cu c\u00e2teva ore a anun\u021bat introducerea acestei func\u021bionalit\u0103\u021bi \u00een produsul s\u0103u. S\u0103 vedem cum func\u021bioneaz\u0103 \u00een GDS!<\/p>\n\n\n\n<!--more-->\n\n\n\n<p class=\"wp-block-paragraph\">\u00cen primul r\u00e2nd, formatarea condi\u021bionat\u0103 poate fi folosit\u0103 \u00een acest moment doar \u00een tabele \u0219i \u00een cifrele simple (f\u0103r\u0103 grafic), care arat\u0103 \u00een stilul unei tabele de marcaj. De notat c\u0103 \u00een aceste tipuri de obiecte puteam face \u0219i p\u00e2n\u0103 acum compara\u021bii, cum ar fi compara\u021bii cu perioada precedent\u0103, \u00eens\u0103 prin func\u021bionalitatea nou\u0103 putem customiza dup\u0103 propriile reguli.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Dup\u0103 ce select\u0103m un obiect dintre tipurile suportate, vom avea \u00een tab-ul s\u0103u <em>Style<\/em>, ca prim\u0103 op\u021biune <em>Conditional formatting<\/em>, cu posibilitatea de a ad\u0103uga reguli.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">La setarea unei reguli, avem 2 pa\u0219i importan\u021bi:<\/p>\n\n\n\n<ol class=\"wp-block-list\"><li>Regula dup\u0103 care s\u0103 formateze<ol><li>prima dat\u0103 alegem dimensiunea sau metrica \u00een func\u021bie de care s\u0103 se aplice regula<\/li><li>ulterior, avem diverse condi\u021bion\u0103ri, diferite dac\u0103 \u00een c\u00e2mpul anterior am ales un indicator numeric, text sau logic<\/li><li>un pic de aten\u021bie \u00een cazul indicatorilor care sunt exprima\u021bi \u00een procente: regula trebuie setat\u0103 pentru valorile actuale ale numerelor, indiferent de formatere; astfel, o rat\u0103 de conversie de 12% ar trebui setat\u0103 \u00een interiorul regulii ca 0.12<\/li><\/ol><\/li><li>Alegerea stilului (culorilor)<ol><li>aici \u00eei indic\u0103m ce s\u0103 fac\u0103 \u00een cazul \u00een care condi\u021bia de mai sus este \u00eendeplinit\u0103<\/li><li>avem o\u021biunea s\u0103 aplic\u0103m formatarea \u00eentregului r\u00e2nd (\u00een cazul tabelelor) sau numai unei celule (putem s\u0103 alegem dintre toate celulele, nu doar pe cea c\u0103reia i-am aplicat regula mai sus)<\/li><li>ultimul pas este s\u0103 alegem, efectiv, culorile \u00een care s\u0103 formateze (o culoare pentru text \u0219i una pentru background)<\/li><\/ol><\/li><\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"887\" height=\"470\" src=\"https:\/\/webanalyst.ro\/blog\/wp-content\/uploads\/2019\/10\/gds-formatting-rules.png\" alt=\"\" class=\"wp-image-2619\" srcset=\"https:\/\/webanalyst.ro\/blog\/wp-content\/uploads\/2019\/10\/gds-formatting-rules.png 887w, https:\/\/webanalyst.ro\/blog\/wp-content\/uploads\/2019\/10\/gds-formatting-rules-150x79.png 150w, https:\/\/webanalyst.ro\/blog\/wp-content\/uploads\/2019\/10\/gds-formatting-rules-300x159.png 300w, https:\/\/webanalyst.ro\/blog\/wp-content\/uploads\/2019\/10\/gds-formatting-rules-768x407.png 768w\" sizes=\"auto, (max-width: 887px) 100vw, 887px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Op\u021biunile sunt simpliste \u00een acest moment, dar cred c\u0103 vor fi ad\u0103ugate \u0219i altele \u00een viitor, cum ar fi ad\u0103ugarea de mai mult de o condi\u021bie \u00eentr-o regul\u0103 sau ad\u0103ugarea \u0219i altor stiluri de formatare, pe l\u00e2ng\u0103 culori.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">De notat c\u0103 avem \u0219i o alt\u0103 limit\u0103. \u00centr-un grafic (obiect) putem ad\u0103uga \u00een acest moment maxim 10 reguli. , Pe m\u0103sur\u0103 ce utilizatorii le vor cere, cred c\u0103 \u0219i aici vor ridica num\u0103rul \u00een timp, cel pu\u021bin pentru clien\u021bii suitei pl\u0103tite GA 360.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Nu \u00een ultimul r\u00e2nd, trebuie \u0219tiut c\u0103 atunci c\u00e2nd folosim mai multe reguli \u00eentr-un tabel, conteaz\u0103 \u0219i ordinea acestora. Regulile de sus pot fi rescrise de cele de mai jos, deci \u00eencepe\u021bi cu cele generaliste \u0219i termina\u021bi cu cele specifice! Folosind mai multe reguli \u00eempreun\u0103 se pot crea ni\u0219te combina\u021bii interesante, aplic\u00e2nd o regul\u0103 care s\u0103 coloreze \u00eentr-un stil tot r\u00e2ndul \u0219i apoi una care s\u0103 coloreze diferit o celul\u0103 a acestuia (un exemplu este \u00een imaginea de la \u00eenceputul articolului).<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Data Studio este \u00eenc\u0103 un produs nou, dar este actualizat frecvent cu noi func\u021bionalit\u0103\u021bi. Multe dintre op\u021biunile ad\u0103ugate sunt mici, ca \u0219i cele de formatare condi\u021bionat\u0103, dar asta nu \u00eenseamn\u0103 cu nu pot fi folosite cu impact \u00een rapoarte \u0219i dashboard-uri.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Formatarea pe baza unor condi\u021bii este o func\u021bionalitate pe care o cunoa\u0219tem cu to\u021bii din produsele software de calcul tabelar, a\u0219adar este folosit\u0103 \u00een multe dintre rapoartele care sunt create \u0219i trimise. Cum Google \u00eencearc\u0103 s\u0103 mute raportarea din aceste instrumente spre Data Studio, \u00een urm\u0103 cu c\u00e2teva ore a anun\u021bat introducerea acestei func\u021bionalit\u0103\u021bi \u00een [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":2613,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[867,11],"tags":[894,896],"class_list":["post-2612","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-data-studio","category-noutati","tag-conditional-formatting","tag-editare-tabel"],"_links":{"self":[{"href":"https:\/\/webanalyst.ro\/blog\/wp-json\/wp\/v2\/posts\/2612","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=2612"}],"version-history":[{"count":6,"href":"https:\/\/webanalyst.ro\/blog\/wp-json\/wp\/v2\/posts\/2612\/revisions"}],"predecessor-version":[{"id":2621,"href":"https:\/\/webanalyst.ro\/blog\/wp-json\/wp\/v2\/posts\/2612\/revisions\/2621"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/webanalyst.ro\/blog\/wp-json\/wp\/v2\/media\/2613"}],"wp:attachment":[{"href":"https:\/\/webanalyst.ro\/blog\/wp-json\/wp\/v2\/media?parent=2612"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/webanalyst.ro\/blog\/wp-json\/wp\/v2\/categories?post=2612"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/webanalyst.ro\/blog\/wp-json\/wp\/v2\/tags?post=2612"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}