Just one more for today, I promise!
Now in, SQL it would look like this:
SELECT dateA, COUNT(*) as numDisco FROM ks_table WHERE shoes != '' GROUP BY dateA
but how do I do this in vega-lite?
I’ve tried
data(rawdatanow)
.transform(
vl.filter({“datum”:[‘shoes’]} == 1),
)
and
vl.joinaggregate(vl.sum().field(‘shoes’).as(‘numDisco’)).groupby(‘dateA’)
with no luck. Help?