31:T4a9,{ const deltaUsers = lastWeekReportData.diffFromAverage const isLargerThanStandardDeviation = Math.abs(deltaUsers) > lastWeekReportData.standardDeviation const isPositiveChange = deltaUsers > 0 const color = (() => { if (isLargerThanStandardDeviation) { if (isPositiveChange) return 'green' else return 'red' } return 'gray' })() const prefix = isPositiveChange ? '+' : '' return html`

Last week

${lastWeekReportData.lastWeekWau} users

Average (Prior ${PREVIOUS_PERIOD_LENGTH} weeks)

${Math.floor(lastWeekReportData.avgWau)} users

(Standard deviation: +/-${Math.floor(lastWeekReportData.standardDeviation)} users)

Last week compared to average

${prefix}${Math.floor(deltaUsers)} users

` } 32:[] 2f:{"title":"Fun Fun Forum Active Users Dashboard (version 5)","cells":[{"id":660,"value":"md`# Fun Fun Forum Active Users Dashboard (version 5)\nActive user = User that made at least one post.\n\n## Weekly active users`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1303,"value":"$31","pinned":false,"hidden":false,"mode":"ojs"},{"id":435,"value":"wau_chart = baseChart([\n ['x'].concat(wau.map(x => x.date)),\n ['Active users'].concat(wau.map(x => x.value))\n], {\n yOpts: {\n label: 'Active users'\n },\n xOpts: {\n label: 'Week Number',\n tick: { format: x => dateFormat(x, 'W'), culling: false}\n }\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1156,"value":"mau_md = md`## Monthly active users`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1151,"value":"mau_chart = baseChart([\n ['x'].concat(mau.map(x => x.date)),\n ['Active Users'].concat(mau.map(x => x.value))\n], {\n yOpts: {\n label: 'Active users'\n },\n xOpts: {\n label: 'Month',\n tick: {\n format: x => dateFormat(x, 'mmmm')\n }\n }\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1713,"value":"md`## Average active users per weekday\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1625,"value":"avg_dau_chart = baseChart([\n ['x'].concat(averageUsagePerWeekDay.map(x => x.day)),\n ['users'].concat(averageUsagePerWeekDay.map(x => x.value))\n], {\n xOpts: {\n type: 'line',\n tick: { format: intAsWeekDayString },\n label: 'Weekday',\n },\n yOpts: {\n label: 'DAU'\n }\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1092,"value":"md`# Data extraction\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1268,"value":"lastWeekReportData = {\n const previousPeriodPlusThisWeek = R.slice(0, PREVIOUS_PERIOD_LENGTH + 1)(R.reverse(wau))\n const lastWeekWau = R.head(previousPeriodPlusThisWeek).value\n const previousPeriod = R.tail(previousPeriodPlusThisWeek)\n const avgWau = previousPeriod.reduce((sum, x) => x.value + sum,0) / previousPeriod.length\n const diffFromAverage = lastWeekWau - avgWau\n const delta = lastWeekWau / avgWau \n const standardDeviation = math.std(previousPeriod.map(d => d.value))\n return {\n lastWeekWau,\n avgWau,\n delta,\n diffFromAverage,\n standardDeviation\n }\n \n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1572,"value":"averageUsagePerWeekDay = Promise.resolve(dau)\n .then(R.groupBy(x => dateFormat(x.date, 'N')))\n .then(R.mapObjIndexed(R.map(R.prop('value'))))\n .then(R.mapObjIndexed(R.mean))\n .then(R.toPairs)\n .then(R.map(([ day, value ]) => ({ day, value })))","pinned":false,"hidden":false,"mode":"ojs"},{"id":900,"value":"wau = {\n const lastSunday = addDays(new Date(), -(new Date()).getDay())\n const rangeStart = addDays(lastSunday, (-7 * WEEK_SPAN) + 1)\n const url = \n `https://funfunautomator.herokuapp.com/wau` +\n `?start=${dateIso8601(rangeStart)}&end=${dateIso8601(lastSunday)}`\n return fetch(url)\n .then(response => response.json())\n .then(rows => rows.map(row => ({value: row[0], year: row[1], week: row[2] })))\n .then(weeks => weeks.reduce((weekMap, week) => {\n const key = firstDateOfWeekISO8601(week.year, week.week)\n weekMap[key] = weekMap[key] ? weekMap[key] + week.value : week.value\n return weekMap\n }, {}))\n .then(weekMap => Object.keys(weekMap).map(key => ({\n date: key,\n value: weekMap[key]\n })))\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":1594,"value":"dau = {\n const lastSunday = addDays(new Date(), -(new Date()).getDay())\n const rangeStart = addDays(lastSunday, (-7 * WEEK_SPAN) + 1)\n const url = \n `https://funfunautomator.herokuapp.com/dau` +\n `?start=${dateIso8601(rangeStart)}&end=${dateIso8601(lastSunday)}`\n return fetch(url)\n .then(response => response.json())\n .then(rows => rows.map(row => ({\n value: row[0], \n date: row[1]\n })))\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1147,"value":"mau = {\n const lastDayLastMonth = new Date((new Date()).getFullYear(),(new Date()).getMonth(), 0)\n const rangeStart = addDays(lastDayLastMonth, (-7 * WEEK_SPAN) + 1)\n const url = `https://funfunautomator.herokuapp.com/mau?start=${dateIso8601(rangeStart)}&end=${dateIso8601(lastDayLastMonth)}`\n return fetch(url)\n .then(response => response.json())\n .then(rows => rows.map(row => ({\n value: row[0], \n date: row[1] + '-' + leftpad(row[2], 2) + '-01' \n })))\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":1040,"value":"md`# Configuration`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1289,"value":"PREVIOUS_PERIOD_LENGTH = 8","pinned":false,"hidden":false,"mode":"ojs"},{"id":1026,"value":"WEEK_SPAN = 32","pinned":false,"hidden":false,"mode":"ojs"},{"id":1061,"value":"md`# Helper functions`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1700,"value":"function intAsWeekDayString(i) {\n i = parseInt(i)\n if (i === 1) return 'Monday'\n if (i === 2) return 'Tuesday'\n if (i === 3) return 'Wednesday'\n if (i === 4) return 'Thursday'\n if (i === 5) return 'Friday'\n if (i === 6) return 'Saturday'\n if (i === 7) return 'Sunday'\n throw new Error('invalid week int '+i)\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1344,"value":"function dateIso8601(date) {\n return `${date.getFullYear()}-${leftpad(date.getMonth()+1,2)}-${leftpad(date.getDate(),2)}`\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1340,"value":"function addDays(date, days) {\n var dat = new Date(date.valueOf())\n dat.setDate(dat.getDate() + days)\n return dat\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1336,"value":"function firstDateOfWeekISO8601(year, week) {\n const day = DateInfo.week(year, week).days.get(0)\n return `${day.year}-${leftpad(day.month,2)}-${leftpad(day.date,2)}`\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":961,"value":"// Shows a graph of a given time series. Accepts C3 columns as argument\nbaseChart = {\n // force dependencies\n d3;\n css;\n return async function* (columns, {yOpts, xOpts} = {}) { \n const divId = 'tsg' + Math.floor(Math.random()*100000000)\n const div = html`

`\n yield div\n \n const defaultXOpts = {\n type: 'timeseries',\n tick: { format: '%Y-%m-%d' }\n }\n const defaultYOpts = {\n label: {\n text: 'DEFAULT LABEL'\n }\n }\n c3.generate({\n bindto: '#' + divId,\n data: {\n x: 'x',\n columns\n },\n legend: {\n show: false\n },\n axis: {\n x: {\n ...defaultXOpts,\n ...xOpts\n },\n y: {\n ...defaultYOpts,\n ...yOpts\n }\n }\n })\n\t}\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":1048,"value":"md`# Dependencies`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1670,"value":"dateFormat = browserify('dateformat')","pinned":false,"hidden":false,"mode":"ojs"},{"id":1449,"value":"math = browserify('mathjs')","pinned":false,"hidden":false,"mode":"ojs"},{"id":710,"value":"DateInfo = browserify('date-info')","pinned":true,"hidden":false,"mode":"ojs"},{"id":733,"value":"leftpad = browserify('leftpad')","pinned":false,"hidden":false,"mode":"ojs"},{"id":227,"value":"R = require('ramda')","pinned":false,"hidden":false,"mode":"ojs"},{"id":122,"value":"d3 = require(\"https://cdnjs.cloudflare.com/ajax/libs/d3/3.5.17/d3.js\")","pinned":true,"hidden":false,"mode":"ojs"},{"id":135,"value":"c3 = require(\"https://cdnjs.cloudflare.com/ajax/libs/c3/0.4.18/c3.js\")","pinned":true,"hidden":false,"mode":"ojs"},{"id":141,"value":"css = {\n var link = document.createElement(\"link\");\n link.type = \"text/css\";\n link.rel = \"stylesheet\";\n link.href = \"https://cdnjs.cloudflare.com/ajax/libs/c3/0.4.18/c3.css\";\n return document.getElementsByTagName(\"head\")[0].appendChild(link); \n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1126,"value":"// use browserify-cdn to browserify commonjs dependencies\nbrowserify = dep => require('https://funfunbrowserify.herokuapp.com/standalone/' + dep)","pinned":false,"hidden":false,"mode":"ojs"},{"id":1234,"value":"qs = browserify('qs')","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W32","stdlib":"1","titling":"auto"}