zjuul

# From: https://stuifbergen.com/2018/03/cohort-analysis-with-snowplow-and-r/

########## 1: get data 
appname <- "NAME" # used as selection criterium, replace that with the name of your app
q <- paste0("
  SELECT
  user_id,
  TO_CHAR(CONVERT_TIMEZONE('UTC', 'Europe/Amsterdam', derived_tstamp),'YYYY ww') AS yw
  FROM atomic.events
  WHERE app_id = '", appname, "' AND derived_tstamp >= '2018-01-01'

zjuul

Step 1: Download the binaries
https://github.com/Gulden/gulden-official/releases/tag/v2.0.0.9
(choose Gulden-2.0.0.9-arm-linux-eabihf.tar.gz )

Step 2: unpack the binaries on your NAS somewhere, create a data directory
(outside home, outside web root)

Step 3: create Gulden.conf file inside the data directory
https://g-dash.nl/manual/index.html

zjuul

# visualise weather in NL
#
#
# (c) Jules Stuifbergen 2018 - Creative Commons licence CC BY-SA
#
#

library(httr)
library(tidyverse)
library(lubridate)