{"id":14748,"date":"2019-12-11T15:33:47","date_gmt":"2019-12-11T13:33:47","guid":{"rendered":"https:\/\/www.dase-analytics.com\/blog\/?p=14748"},"modified":"2021-10-26T14:39:06","modified_gmt":"2021-10-26T12:39:06","slug":"google-data-studio-praca-s-tabulkami","status":"publish","type":"post","link":"https:\/\/www.dase-analytics.com\/blog\/sk\/google-data-studio-praca-s-tabulkami\/","title":{"rendered":"Google Data Studio: Pr\u00e1ca s tabu\u013ekami"},"content":{"rendered":"<div id=\"toc_container\" class=\"toc_wrap_right toc_white no_bullets\"><p class=\"toc_title\">Obsah \u010dl&aacute;nku<\/p><ul class=\"toc_list\"><li><\/li><li><\/li><li><\/li><li><\/li><li><\/li><li><ul><li><\/li><li><\/li><\/ul><\/li><li><\/li><\/ul><\/div>\n\n<p>V prvej \u010dasti n\u00e1\u0161ho blogov\u00e9ho seri\u00e1lu ste sa dozvedeli, <a href=\"https:\/\/www.dase-analytics.com\/blog\/google-data-studio-sprievodca-pre-zaciatocnikov\/\" target=\"_blank\" rel=\"noopener noreferrer\">ako Google Data Studio prepoj\u00edte s ostatn\u00fdmi slu\u017ebami spolo\u010dnosti Google<\/a>, napr\u00edklad s analytick\u00fdm n\u00e1strojom Google Analytics. Dnes sa pozrieme na jeden zo z\u00e1kladn\u00fdch elementov Data Studia, ktor\u00fdm s\u00fa, ako inak, tabu\u013eky. Po\u010fme na to!<\/p>\n<h2><span id=\"Vytvorenie_prvej_tabulky_v_Google_Data_Studiu\">Vytvorenie prvej tabu\u013eky v Google Data Studiu<\/span><\/h2>\n<p>Nie je ni\u010d \u013eah\u0161ie, ako vytvori\u0165 prv\u00fa tabu\u013eku v\u00a0<a href=\"https:\/\/www.dase-analytics.com\/blog\/category\/google-data-studio\/\" target=\"_blank\" rel=\"noopener noreferrer\">Data Studiu<\/a>. Po prepojen\u00ed s\u00a0<a href=\"https:\/\/www.dase-analytics.com\/blog\/category\/google-analytics\/\">Google Analytics<\/a> sa toti\u017e vytvor\u00ed automaticky. T\u00e1to z\u00e1kladn\u00e1 tabu\u013eka bude zobrazova\u0165 po\u010det zobrazen\u00ed str\u00e1nky pre jednotliv\u00e9 zdroje n\u00e1v\u0161tev.<\/p>\n<p>Ak potrebujete vytvori\u0165 vlastn\u00fa tabu\u013eku, kliknete na tla\u010didlo <em>\u201ePrida\u0165 graf\u201c<\/em> a\u00a0zvol\u00edte prv\u00fa mo\u017enos\u0165 <em>\u201eTabu\u013eka\u201c<\/em>.<\/p>\n<p><a href=\"https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/data-studio-tabulka-e1574697739302.png\" data-rel=\"lightbox-image-0\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone wp-image-14751 size-full\" src=\"https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/data-studio-tabulka-e1574697739302.png\" alt=\"Google Data Studio - vlo\u017eenie tabu\u013eky\" width=\"1278\" height=\"610\" srcset=\"https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/data-studio-tabulka-e1574697739302.png 1278w, https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/data-studio-tabulka-e1574697739302-300x143.png 300w, https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/data-studio-tabulka-e1574697739302-1024x489.png 1024w\" sizes=\"(max-width: 1278px) 100vw, 1278px\" \/><\/a><\/p>\n<h2><span id=\"Zdroj_dat_dimenzie_ametriky\">Zdroj d\u00e1t, dimenzie a\u00a0metriky<\/span><\/h2>\n<p>Po vytvoren\u00ed tabu\u013eky nasleduje najd\u00f4le\u017eitej\u0161ia \u010das\u0165 \u2013 v\u00fdber d\u00e1t, ktor\u00e9 chcete analyzova\u0165. D\u00e1ta s\u00fa tu \u010dlenen\u00e9 v\u00a0troch \u00farovniach:<\/p>\n<ol>\n<li><strong>Zdroj \u00fadajov<\/strong> \u2013 odkia\u013e d\u00e1ta \u010derp\u00e1te. Zdroj ste si vyberali hne\u010f pri vytv\u00e1ran\u00ed reportu, tu si ho v\u0161ak m\u00f4\u017eete zmeni\u0165. Toto nastavenie vyu\u017eijete napr\u00edklad vtedy, ke\u010f u\u017e vytvoren\u00fd report budete chcie\u0165 aplikova\u0165 na in\u00e9ho klienta, pr\u00edpadne na in\u00e9 zobrazenie v\u00a0Google Analytics (testovacie zobrazenie vs. akt\u00edvne zobrazenie).<br \/>\nV\u00a0tomto bode by som dal do pozornosti aj mo\u017enos\u0165 kombin\u00e1cie d\u00e1t (Data Blending), kedy v\u00a0jednom reporte m\u00f4\u017eete porovn\u00e1va\u0165, resp. kombinova\u0165 d\u00e1ta z\u00a0viacer\u00fdch zdrojov. O\u00a0tejto fi\u010d\u00farke sa do\u010d\u00edtate v\u00a0jednom z\u00a0nasleduj\u00facich \u010dl\u00e1nkov k\u00a0Data Studiu.<\/li>\n<li><a href=\"https:\/\/www.dase-analytics.com\/blog\/vyraz\/dimenzia\/\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>Dimenzia<\/strong><\/a> \u2013 ka\u017ed\u00e1 tabu\u013eka m\u00f4\u017ee obsahova\u0165 nieko\u013eko dimenzi\u00ed, av\u0161ak pozor. Ak nakombinujete pr\u00edli\u0161 ve\u013ea dimenzi\u00ed, vznikne ve\u013ek\u00e9 mno\u017estvo segmentov, ktor\u00e9 mo\u017eno nebude d\u00e1va\u0165 zmysel. V\u00a0modelovom pr\u00edklade som pou\u017eil dve dimenzie \u2013 <em>Vstupn\u00e1 str\u00e1nka<\/em> a\u00a0<em>Kampa\u0148<\/em>. Ak chcete zobrazi\u0165 rovnak\u00e9 metriky pre r\u00f4zne dimenzie a\u00a0z\u00e1rove\u0148 nechcete vytv\u00e1ra\u0165 pre ka\u017ed\u00fa dimenziu samostatn\u00fa tabu\u013eku, odpor\u00fa\u010dam pou\u017ei\u0165 vo\u013ebu <em>\u201ePrejdite hlb\u0161ie\u201c<\/em>. Vo v\u00fdslednom reporte si tak budete m\u00f4c\u0165 jednoducho prep\u00edna\u0165 medzi dimenziami.<\/li>\n<li><a href=\"https:\/\/www.dase-analytics.com\/blog\/vyraz\/metrika-metric\/\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>Metriky <\/strong><\/a>\u2013 Data Studio umo\u017e\u0148uje prida\u0165 do jednej tabu\u013eky viacero metr\u00edk, pri\u010dom nie v\u0161etky musia by\u0165 vidite\u013en\u00e9 automaticky. Do z\u00e1kladn\u00e9ho zoznamu metr\u00edk odpor\u00fa\u010dam vlo\u017ei\u0165 metriky, na ktor\u00e9 chcete upriami\u0165 pozornos\u0165. Zvy\u0161n\u00e9 metriky, ktor\u00e9 s\u00fa d\u00f4le\u017eit\u00e9 sk\u00f4r pre \u010diastkov\u00e9 anal\u00fdzy, potom m\u00f4\u017eete vlo\u017ei\u0165 do zoznamu nepovinn\u00fdch metr\u00edk. Vo v\u00fdslednom reporte si ich m\u00f4\u017eete zap\u00edna\u0165 alebo vyp\u00edna\u0165 ako budete potrebova\u0165.<\/li>\n<li><strong>Dostupn\u00e9 polia <\/strong>\u2013 v\u00a0pravom postrannom paneli n\u00e1jdete zoznam dostupn\u00fdch dimenzi\u00ed a\u00a0metr\u00edk s fulltextov\u00fdm vyh\u013ead\u00e1vac\u00edm po\u013eom. Dimenzie a\u00a0metriky aplikujete jednoducho pomocou drag&amp;drop, alebo priamo v\u00a0zozname pou\u017eit\u00fdch dimenzi\u00ed a\u00a0metr\u00edk cez <em>\u201e+ Prida\u0165 dimenziu\/metriku\u201c.<\/em><\/li>\n<\/ol>\n<p><a href=\"https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/dimenzie-metriky-datastudio.gif\" data-rel=\"lightbox-image-1\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone wp-image-14758 size-full\" src=\"https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/dimenzie-metriky-datastudio.gif\" alt=\"GDS - dimenzie a metriky\" width=\"1493\" height=\"669\" \/><\/a><\/p>\n<blockquote><p><em><strong>Upozornenie:<\/strong> pri v\u00fdbere dimenzi\u00ed a\u00a0metr\u00edk mus\u00edte myslie\u0165 na spr\u00e1vny Scope (rozsah \u00fadajov: User, Session, Hit, Product). Viac o rozsahoch sa do\u010d\u00edtate <a href=\"https:\/\/www.dase-analytics.com\/blog\/rozsahy-v-google-analytics-ako-ich-pouzivat\/\" target=\"_blank\" rel=\"noopener noreferrer\">v tomto na\u0161om \u010dl\u00e1nku<\/a>. Kombin\u00e1cia dimenzi\u00ed a\u00a0metr\u00edk z\u00a0rozli\u010dn\u00fdch Scopes v\u00e1m v\u00a0tom lep\u0161om pr\u00edpade vyhod\u00ed chybu, v\u00a0tom hor\u0161om nebude d\u00e1va\u0165 zmysel a\u00a0v\u00a0tom \u00faplne najhor\u0161om v\u00e1s m\u00f4\u017ee navies\u0165 na zl\u00e9 biznisov\u00e9 rozhodnutie.<\/em><\/p><\/blockquote>\n<h2><span id=\"Zobrazenie_azoradenie_udajov\">Zobrazenie a\u00a0zoradenie \u00fadajov<\/span><\/h2>\n<p>V\u00fdborne. Vytvorili ste si tabu\u013eku, vlo\u017eili do nej spr\u00e1vne \u00fadaje a\u00a0teraz ich e\u0161te potrebujete zobrazi\u0165 tak, aby d\u00e1vali zmysel. Google Data Studio umo\u017e\u0148uje nastavi\u0165:<\/p>\n<ol>\n<li><strong>Po\u010det riadkov na stranu<\/strong> \u2013 m\u00e1te mo\u017enos\u0165 vybra\u0165 si rozsah od 1 do 5000. To je s\u00edce kr\u00e1sne, ale ak v\u00a0tabu\u013eke pou\u017e\u00edvate mno\u017estvo dimenzi\u00ed a\u00a0metr\u00edk, vyp\u00edsanie 5000 riadkov na jednu stranu bude \u010dasovo n\u00e1ro\u010dn\u00e9. Zvoli\u0165 si str\u00e1nkovanie po 10, 20, alebo 25 riadkoch bude praktickej\u0161ie, aj ke\u010f pri ka\u017edom prekliknut\u00ed na \u010fal\u0161iu str\u00e1nku nejak\u00e9 \u010dasov\u00e9 opozdenie ur\u010dite nastane.<\/li>\n<li><strong>Riadok s\u00fahrnu<\/strong> \u2013 po za\u0161krtnut\u00ed pol\u00ed\u010dka sa zobraz\u00ed fixn\u00fd riadok so v\u0161etk\u00fdmi metrikami v\u00a0celkovom s\u00fahrne, t.j. nez\u00e1vislom od po\u010dtu riadkov na strane.<\/li>\n<li><strong>Zoradi\u0165<\/strong> \u2013 prim\u00e1rne zoradenie riadkov, zvy\u010dajne pod\u013ea prvej pou\u017eitej metriky.<\/li>\n<li><strong>Sekund\u00e1rne zoradenie <\/strong>\u2013 v\u00a0pr\u00edpade, ke\u010f viac riadkov v\u00a0prim\u00e1rnom zoraden\u00ed obsahuje rovnak\u00fa hodnotu.<\/li>\n<\/ol>\n<p><strong>Rozmer tabu\u013eky<\/strong> a \u0161\u00edrku\u00a0jednotliv\u00fdch st\u013apcov m\u00f4\u017eete <strong>\u013eubovo\u013ene upravova\u0165<\/strong>. Ak v\u00fd\u0161ka tabu\u013eky nebude posta\u010dova\u0165 na vykreslenie v\u0161etk\u00fdch riadkov, Data Studio jednoducho zafixuje hlavi\u010dku tabu\u013eky a\u00a0riadok s\u00fahrnu, pri\u010dom\u00a0jednotliv\u00e9 riadky s\u00a0\u00fadajmi bud\u00fa scrollovate\u013en\u00e9.<\/p>\n<p><a href=\"https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/zobrazenie-zoradenie-google-datastudio.png\" data-rel=\"lightbox-image-2\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone wp-image-14766 size-full\" src=\"https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/zobrazenie-zoradenie-google-datastudio.png\" alt=\"Radenie \u00fadajov v Google Data Studiu\" width=\"1606\" height=\"548\" srcset=\"https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/zobrazenie-zoradenie-google-datastudio.png 1606w, https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/zobrazenie-zoradenie-google-datastudio-300x102.png 300w, https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/zobrazenie-zoradenie-google-datastudio-1024x349.png 1024w\" sizes=\"(max-width: 1606px) 100vw, 1606px\" \/><\/a><\/p>\n<h2><span id=\"Rozsah_datumov\">Rozsah d\u00e1tumov<\/span><\/h2>\n<p>Ak chcete ten ist\u00fd report pou\u017e\u00edva\u0165 na preh\u013eady pre r\u00f4zne \u010dasov\u00e9 \u00faseky, je potrebn\u00e9 pou\u017ei\u0165 vstavan\u00fd filter <em>\u201eRozsah d\u00e1tumov\u201c<\/em>. Ten n\u00e1jdete v\u00a0hornom paneli n\u00e1strojov. Dobr\u00fdm zvykom je <strong>umiestni\u0165 ho do prav\u00e9ho horn\u00e9ho rohu<\/strong> reportu.<\/p>\n<p>Ak rozsah d\u00e1tumov nepou\u017eijete, Data Studio m\u00e1 defaultne nastaven\u00fd rozsah d\u00e1tumov na posledn\u00fdch 28 dn\u00ed s\u00a0vyl\u00fa\u010den\u00edm dne\u0161n\u00e9ho d\u0148a.<\/p>\n<p>\u010eal\u0161ou \u0161ikovnou funkciou je <strong>mo\u017enos\u0165 porovnania \u00fadajov s\u00a0predo\u0161l\u00fdm obdob\u00edm<\/strong>. V\u00a0z\u00e1kladnom nastaven\u00ed sa za predo\u0161l\u00e9 obdobie pova\u017euje tak\u00e9 ist\u00e9 \u010dasov\u00e9 obdobie, ak\u00e9 si zvol\u00edte v\u00a0rozsahu d\u00e1tumov. Ak si teda pri \u010d\u00edtan\u00ed reportu zvol\u00edte posledn\u00fdch 7 dn\u00ed, Data Studio v\u00e1m \u00fadaje porovn\u00e1 s\u00a0t\u00fd\u017ed\u0148om predt\u00fdm. Zmenu oproti predo\u0161l\u00e9mu obdobiu uvid\u00edte pri ka\u017edej jednej metrike pou\u017eitej v\u00a0tabu\u013eke. Ak chcete niektor\u00fd st\u013apec s porovnaniami vynecha\u0165, nastav\u00edte to na karte <em>\u201e\u0160t\u00fdl\u201c.<\/em><\/p>\n<p><a href=\"https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/google-data-studio-rozsah-datumov.png\" data-rel=\"lightbox-image-3\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone wp-image-14769 size-full\" src=\"https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/google-data-studio-rozsah-datumov.png\" alt=\"Google Data Studio - filter d\u00e1tumov, porovnanie s minul\u00fdm obdob\u00edm\" width=\"1826\" height=\"752\" srcset=\"https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/google-data-studio-rozsah-datumov.png 1826w, https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/google-data-studio-rozsah-datumov-300x124.png 300w, https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/google-data-studio-rozsah-datumov-1024x422.png 1024w\" sizes=\"(max-width: 1826px) 100vw, 1826px\" \/><\/a><\/p>\n<h2><span id=\"Filtre_a_segmenty\">Filtre a segmenty<\/span><\/h2>\n<p>V\u00a0niektor\u00fdch pr\u00edpadoch mo\u017eno budete chcie\u0165 vyfiltrova\u0165 z\u00a0kompletnej datab\u00e1zy len niektor\u00e9 \u00fadaje. <strong>Filtrova\u0165 m\u00f4\u017eete dvoma sp\u00f4sobmi<\/strong>:<\/p>\n<ol>\n<li>Vlo\u017e\u00edte do hlavi\u010dky dokumentu okno s\u00a0filtrom, podobne ako v\u00a0pr\u00edpade rozsahu d\u00e1tumov. <strong>Filter<\/strong> n\u00e1jdete op\u00e4\u0165 <strong>v\u00a0hornom paneli n\u00e1strojov<\/strong> a\u00a0je ozna\u010den\u00fd ako \u201eNastavenie filtra\u201c. Takto si bude m\u00f4c\u0165 u\u017e\u00edvate\u013e dynamicky odfiltrova\u0165 len tie \u00fadaje, ktor\u00e9 potrebuje.<\/li>\n<li>Druhou mo\u017enos\u0165ou je pou\u017ei\u0165 <strong>fixn\u00fd filter<\/strong>, aby sa do tabu\u013eky dostali len tie d\u00e1ta, ktor\u00e9 potrebujete. V\u00a0nastaveniach filtra m\u00f4\u017eete pou\u017e\u00edva\u0165 Regex, alebo \u0161tandardn\u00e9 logick\u00e9 oper\u00e1cie a\u00a0podmienky. V\u00a0modelovom pr\u00edklade som vyfiltroval len tie vstupy na web, ktor\u00e9 plynuli z\u00a0kampan\u00ed THINK f\u00e1zy:<\/li>\n<\/ol>\n<p><a href=\"https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/google-data-studio-filter.png\" data-rel=\"lightbox-image-4\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone wp-image-14774 size-full\" src=\"https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/google-data-studio-filter.png\" alt=\"Google Data Studio - filter, nastavenie filtra cez regex, \u00faprava tabu\u013eky, screenshot\" width=\"1914\" height=\"702\" srcset=\"https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/google-data-studio-filter.png 1914w, https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/google-data-studio-filter-300x110.png 300w, https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/google-data-studio-filter-1024x376.png 1024w\" sizes=\"(max-width: 1914px) 100vw, 1914px\" \/><\/a><\/p>\n<p>Data Studio umo\u017e\u0148uje pou\u017e\u00edva\u0165 aj <strong>segmenty<\/strong>, ktor\u00e9 pou\u017e\u00edvate v\u00a0Google Analytics. Na jednu tabu\u013eku \u010di graf v\u0161ak viete aplikova\u0165 len jeden segment. V\u00a0pr\u00edpade, \u017ee potrebujete skombinova\u0165 d\u00e1ta z\u00a0viacer\u00fdch segmentov, mus\u00edte si tak\u00fdto segment najsk\u00f4r vytvori\u0165, pr\u00edpadne pou\u017ei\u0165 pevn\u00fd filter pod\u013ea pr\u00edkladu vy\u0161\u0161ie.<\/p>\n<p>Poslednou fi\u010d\u00farkou je <strong>povolenie interakci\u00ed<\/strong>. Ak m\u00e1te v\u00a0reporte napr\u00edklad graf nadv\u00e4zuj\u00faci na dan\u00fa tabu\u013eku, u\u017e\u00edvate\u013e si po kliknut\u00ed na jeden konkr\u00e9tny riadok tabu\u013eky vie zobrazi\u0165 graf len s prisl\u00fachaj\u00facimi d\u00e1tami.<\/p>\n<h2><span id=\"Vizualna_uprava_tabulky\">Vizu\u00e1lna \u00faprava tabu\u013eky<\/span><\/h2>\n<p>Teraz pr\u00edde na rad t\u00e1 z\u00e1bavnej\u0161ia \u010das\u0165 \u2013 dizajn tabu\u013eky. V\u00a0pravom postrannom paneli si <strong>prekliknete na kartu <em>\u201e\u0160t\u00fdl\u201c<\/em><\/strong>. Ve\u013ea jej \u010dast\u00ed pozn\u00e1te z\u00a0Excelu \u010di z\u00a0Wordu, tak\u017ee ich ur\u010dite netreba bli\u017e\u0161ie vysvet\u013eova\u0165, no na dve \u010dasti sa pozrieme bli\u017e\u0161ie:<\/p>\n<h3><span id=\"1_Podmienene_formatovanie\">1. Podmienen\u00e9 form\u00e1tovanie<\/span><\/h3>\n<p>V\u010faka podmienen\u00e9mu form\u00e1tovaniu <strong>viete nastavi\u0165 farebnos\u0165 buniek \u010di riadkov na z\u00e1klade hodn\u00f4t<\/strong> v jednotliv\u00fdch bunk\u00e1ch. V\u00a0nasleduj\u00facom modelovom pr\u00edklade som rozdelil pre lep\u0161iu preh\u013eadnos\u0165 jednotliv\u00e9 typy PPC kampan\u00ed pod\u013ea farieb: bannerov\u00e9 kampane s\u00fa zn\u00e1zornen\u00e9 zelenou farbou, kampane vo vyh\u013ead\u00e1van\u00ed zelenou a\u00a0remarketingov\u00e9 kampane \u010dervenou. Tu by som dal do pozornosti d\u00f4le\u017eitos\u0165 logick\u00e9ho n\u00e1zvoslovia kampan\u00ed, bez ktor\u00e9ho by tak\u00e9to form\u00e1tovanie tabu\u013eky bolo ove\u013ea zlo\u017eitej\u0161ie.<\/p>\n<p><a href=\"https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/gds-podmienene-formatovanie.png\" data-rel=\"lightbox-image-5\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone wp-image-14776 size-full\" src=\"https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/gds-podmienene-formatovanie.png\" alt=\"Podmienen\u00e9 form\u00e1tovanie pre tabu\u013eky v Google Data Studiu\" width=\"1916\" height=\"853\" srcset=\"https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/gds-podmienene-formatovanie.png 1916w, https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/gds-podmienene-formatovanie-300x134.png 300w, https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/gds-podmienene-formatovanie-1024x456.png 1024w\" sizes=\"(max-width: 1916px) 100vw, 1916px\" \/><\/a><\/p>\n<h3><span id=\"2_Formatovanie_metrik\">2. Form\u00e1tovanie metr\u00edk<\/span><\/h3>\n<p>S\u00fa tri sp\u00f4soby, ak\u00fdmi m\u00f4\u017eete zobrazi\u0165 <strong>hodnoty metr\u00edk \u2013 \u010d\u00edslo, teplotn\u00e1 mapa a\u00a0st\u013apec<\/strong>. Teplotn\u00fa mapu odpor\u00fa\u010dam pou\u017e\u00edva\u0165 len vtedy, ak ste predt\u00fdm neupravili farby buniek cez podmienen\u00e9 form\u00e1tovanie. Podmienen\u00e9 form\u00e1tovanie m\u00e1 toti\u017e pred teplotnou mapou prednos\u0165.<\/p>\n<p>Ak hodnoty v\u00a0tabu\u013eke s\u00fa r\u00e1dovo v\u00a0tis\u00edcoch alebo mili\u00f3noch a\u00a0nepotrebujeme ich reportova\u0165 presne, odpor\u00fa\u010dam pou\u017e\u00edva\u0165 <em>\u201eKompaktn\u00e9 \u010d\u00edsla\u201c<\/em>. \u010c\u00edslo 1310 sa zap\u00ed\u0161e ako 1,3 tis.<\/p>\n<p>Zvolili ste si pri nastaven\u00ed \u00fadajov mo\u017enos\u0165 <strong>porovnania s\u00a0minul\u00fdm obdob\u00edm<\/strong>, ale potrebujete porovn\u00e1va\u0165 len niektor\u00e9 metriky? Pr\u00e1ve tu m\u00f4\u017eete nadbyto\u010dn\u00e9 st\u013apce vypn\u00fa\u0165, pr\u00edpadne percentu\u00e1lnu zmenu nahradi\u0165 absol\u00fatnou. Ak potrebujete zmenu zn\u00e1zorni\u0165 teplotnou mapou, alebo st\u013apcami, budete si musie\u0165 vytvori\u0165 kalkulovan\u00fa metriku \u2013 t\u00e1to vstavan\u00e1 pseudometrika toti\u017e viac nastaven\u00ed neumo\u017e\u0148uje.<\/p>\n<p><a href=\"https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/formatovanie-metrik-datastudio.png\" data-rel=\"lightbox-image-6\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone wp-image-14778 size-full\" src=\"https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/formatovanie-metrik-datastudio.png\" alt=\"Metriky form\u00e1tovanie, Google Data Studio, n\u00e1vod\" width=\"1919\" height=\"701\" srcset=\"https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/formatovanie-metrik-datastudio.png 1919w, https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/formatovanie-metrik-datastudio-300x110.png 300w, https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/formatovanie-metrik-datastudio-1024x374.png 1024w\" sizes=\"(max-width: 1919px) 100vw, 1919px\" \/><\/a><\/p>\n<h2><span id=\"Atabulka_vData_Studiu_je_na_svete\">A\u00a0tabu\u013eka v\u00a0Data Studiu je na svete<\/span><\/h2>\n<p>Ako vid\u00edte, <strong>vytvori\u0165 preh\u013eadn\u00fa tabu\u013eku v\u00a0Google Data Studiu nie je v\u00f4bec zlo\u017eit\u00e9<\/strong>. M\u00e1te e\u0161te st\u00e1le nejak\u00e9 ot\u00e1zky? P\u00fdtajte sa dole v\u00a0koment\u00e1roch, radi v\u00e1m odpovieme.<\/p>\n<p>N\u00e1\u0161 <a href=\"https:\/\/www.dase-analytics.com\/blog\/category\/google-data-studio\/\" target=\"_blank\" rel=\"noopener noreferrer\">seri\u00e1l o\u00a0Data Studiu<\/a> v\u0161ak nekon\u010d\u00ed. V\u00a0\u010fal\u0161om \u010dl\u00e1nku sa do\u010d\u00edtate o\u00a0pr\u00e1ci s\u00a0preh\u013eadmi (Scorecards).<\/p>\n","protected":false},"excerpt":{"rendered":"<p>V prvej \u010dasti n\u00e1\u0161ho blogov\u00e9ho seri\u00e1lu ste sa dozvedeli, ako Google Data Studio prepoj\u00edte s ostatn\u00fdmi slu\u017ebami spolo\u010dnosti&#8230;<\/p>\n","protected":false},"author":70,"featured_media":14828,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[667,639],"tags":[668,372],"_links":{"self":[{"href":"https:\/\/www.dase-analytics.com\/blog\/sk\/wp-json\/wp\/v2\/posts\/14748"}],"collection":[{"href":"https:\/\/www.dase-analytics.com\/blog\/sk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dase-analytics.com\/blog\/sk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dase-analytics.com\/blog\/sk\/wp-json\/wp\/v2\/users\/70"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dase-analytics.com\/blog\/sk\/wp-json\/wp\/v2\/comments?post=14748"}],"version-history":[{"count":22,"href":"https:\/\/www.dase-analytics.com\/blog\/sk\/wp-json\/wp\/v2\/posts\/14748\/revisions"}],"predecessor-version":[{"id":17927,"href":"https:\/\/www.dase-analytics.com\/blog\/sk\/wp-json\/wp\/v2\/posts\/14748\/revisions\/17927"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dase-analytics.com\/blog\/sk\/wp-json\/wp\/v2\/media\/14828"}],"wp:attachment":[{"href":"https:\/\/www.dase-analytics.com\/blog\/sk\/wp-json\/wp\/v2\/media?parent=14748"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dase-analytics.com\/blog\/sk\/wp-json\/wp\/v2\/categories?post=14748"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dase-analytics.com\/blog\/sk\/wp-json\/wp\/v2\/tags?post=14748"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}