There is a lot of installing to do for this:
install R (programming language);
install R Studio;
install rTools (othervise you will get the error: rtools is not installed) simple download and wizard install, no need for R console for this.
Install ggplot2 with R studio…
So one day I woke up and I was like:
So I booted up my free account and started typing:
with test as (select 'ABCD1234' as field)
select regexp_extract(field, '[0-9]{1,3}') as extracted from test --retunrs 123union allselect regexp_extract(field, '[0-9]{1,4}') as extracted from test --…
The situation: let's say I want to know the number of cases in Italy by province first.
The dataset:
Warm-Up queries:
Now, to get the same result with Analytic function, displaying the total sum of the region in every row.
Okay, but this is not so much fun when you have only a few…
The situation: You want to edit an excel file but you don't want to make it xlsm, because other people are also using it, might get sent around.
What you'll need: Notepad++
Set objExcel = CreateObject("Excel.Application")objExcel.visible = true Set objWorkbook =…
The situation: you have some megring/copying to do with some files in a folder, but first you need to figure out the accessing of the folders and it's filenames.
Google Scripts:
function useFolder() {
var app = DriveApp;var folderIter = app.getFoldersByName("coding memes");var folder =…
In this post, I will insert a Googe Data Studio report in a blogpost.
Data source is the public free dataset of Google.