Google Data Studio and GA4 - Recreating the Month of Year dimension properly

kvě 13 2022

2023-09-08 UPDATE: It is no longer necessary to create custom Month of Year dimension. The new version of Google Data Studio (renamed to Looker Studio) now contains dimension called Year month. Additionally, my function is broken due to internal changes of Year dimension data formatting.

Updated formula that works - Credit to Manuel Garcia:

PARSE_DATE('%Y-%m', CONCAT(SUBSTR(Year, 1, 4), '-', IF(Month < 10, CONCAT('0', Month), CAST(Month AS TEXT ) ) ) )


It is not TODATE(Date, '%Y-%m').

Getting mysql-workbench to work on Debian 11

srp 09 2021

UPDATE: Some people have reached out to me that the guide does not work for them. I've decided to re-do the guide with a clean install of Debian 11 Bullseye (stable as of August 2021).

MySQL Workbench is currently unavailable on Debian 10 and 11. Ubuntu packages seem to be incompatible. The only two remaining options for installation are: getting a Snap package or building the Workbench from source. This blog post deals with the latter.

Rozvoz z W Restaurant

dub 02 2020

Rozhodl jsem se doma vybočit z cyklu vaření v karanténě. Už mi začaly docházet nápady, co dalšího si udělat a měli jsme chuť na něco, co jiné restaurace nerozváží. Oběd jsme si proto objednali z [W Restaurant](https://www.wrbmprague.cz), což je nová restaurace v centru Prahy na Josefově.

Přípravy na stěhování vrcholí

pro 17 2019

S Novým rokem přichází také změna u nás ve WebMedea Services a Triton IT. Stěhujeme se z naší současné adresy ve Viktora Huga do větších prostor. Od ledna nás tak naleznete na Praze 1 v ulici Křemencova, hned vedle známé restaurace U Fleků.

Time to move to NFTables

pro 03 2019

The time has come for us in WebMedea to move away from the iptables firewall. While the software remains actively maintained by Netfilter, I've set my eyes upon the more recently developed nftables as it seems easier to administer and maintain rules. Nftables unifies all the separate utilities of arptables, ebtables, iptables and ip6tables into a single one. It has slightly different rule writing syntax, which can greatly shorten rules, but the principles of filtering practically remain the same.

While poking internet for a quick-to-explain guide, I've arrived (quite obviously) to the nftables wiki 10 minute guide. It literally takes 10 minutes for anyone with previous knowledge of iptables to adapt to the new syntax with this guide.