Doing stuff
Published
Edited
May 28, 2021
1 fork
3 stars
raw = FileAttachment("tableau-source@1").text()
secondaryInfo = raw
.split(/\d{2,10};(?={.+})/) // parse out non-JSON pieces
.filter(s => s.length) // get rid of empty strings
.map(t => JSON.parse(t)) // JSON.parse
.find(d => d.secondaryInfo).secondaryInfo // where the good stuff is
root = secondaryInfo.presModelMap
dataColumns = root.dataDictionary.presModelHolder
.genDataDictionaryPresModel.dataSegments[0].dataColumns
dataLookup = new Map(dataColumns.map(d => [d.dataType, d.dataValues]))
presModelMap = root.vizData.presModelHolder.genPresModelMapPresModel
.presModelMap
columns1 = presModelMap[sheet].presModelHolder.genVizDataPresModel
.paneColumnsData.paneColumnsList[0].vizPaneColumns
columns2 = presModelMap[sheet].presModelHolder.genVizDataPresModel
.paneColumnsData.paneColumnsList[1].vizPaneColumns
columns1[1].aliasIndices.length
uniqueValues = new Set(columns1[1].aliasIndices)
positives = {
const indices = columns1[1].aliasIndices;
const values = dataLookup.get('integer');
return indices.map(idx => values[idx]);
}
uniqueDates = new Set(columns1[2].valueIndices)
dates = {
const indices = columns1[2].valueIndices;
const values = dataLookup.get('datetime');
return indices.map(idx => values[idx].replace(' 00:00:00', ''));
}
data = d3.zip(dates, positives).map(([date, positive]) => ({ date, positive }))
Inputs.table(data)
uniqueLineLabels = new Set(columns2[2].aliasIndices)
lineCategories = {
const indices = columns2[2].aliasIndices;
const values = dataLookup.get('cstring');
return indices.map(idx => values[idx]);
}
lineValues = {
const indices = columns2[3].valueIndices;
const values = dataLookup.get('real');
return indices.map(idx => values[idx]);
}
lineDates = {
const indices = columns2[1].valueIndices;
const values = dataLookup.get('datetime');
return indices.map(idx => values[idx].replace(' 00:00:00', ''));
}
lineData = d3
.zip(lineCategories, lineValues, lineDates)
.map(([label, value, date]) => ({ label, value, date }))
d3 = require('d3-array@2')
Purpose-built for displays of data
Observable is your go-to platform for exploring data and creating expressive data visualizations. Use reactive JavaScript notebooks for prototyping and a collaborative canvas for visual data exploration and dashboard creation.
