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').

Recently, we've received a request from one of our clients to convert the built-in Description field from one of their taxonomies into a mandatory field. Sounds easy, right?

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.

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ě.

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ů.