What are you struggling with?
2- Can you apply a filter to multiple columns like an 'Or' for example: column1 'or' column2 $eq "blue"
Ok. I’m not sure I’d really recommend that, but neither here nor there. With Reductio, you’d just do what you are doing. You have access to the Crossfilter. Reductio just creates group reducer functions for you. With Universe, I’m not sure if you can get the Crossfilter back out.
On 2, I’m not sure. I think not. You would have to do a custom filter function in Universe.
^in crossfilter of course.... Does universe allow to you create a query that returns all the values?
This message was deleted
It also sends back the crossfilter, group, and dimension after a query, so you could probably just call
dimension.top on that returned dimension object.
columnName - Creates a nested column with the name provided
from the docs says it just creates a column.. lol I am lost with this... Thanks for the help
I do believe you need to explicitly tell it both the aggregates and columns you want back. Not sure though.
allData = this.universe.column.find('ID').dimension.top(Infinity);
and then I setup the onfilter listener to update allData based on the same dimension.top(Infinity)
I have no idea if its correct but I found this method from : http://codepen.io/christophe-g/pen/ALqvQZ
Hello all. Something I'm missing and I can't find mention of in the various docs for crossfilter, reductio or universe is how to handle sorting on specific column value. If I pre-sort my data, the sorting appears to be undone by crossfilter when I access it via a dimension that is then grouped and the all method invoked. Can anyone point me to docs on this or relieve my confusion somehow ?
I understand the order method on a group in crossfilter but the data only comes back ordered via the top(k) method. How do you sort the entire data along a single column value?
Also I was thrown by the fact that in the order function the arg is the value so :
return d not return d.value
Hey all, I'm using universe and I struggle getting multiple aggregation from a single query. I've created a small pen to make it easier: https://codepen.io/anon/pen/VWBoOB?editors=0011
This piece of code works fine as is but if I uncomment the "total" line, I don't get any aggregation: it works either for tip or total but I can't get both
Can anyone tell me what I'm doing wrong ?
async function spendByMonth(parent, level) {
//parent = 'Spine';
//level = 1;
console.log(parent);
console.log(level);
var levelKey = hierarchyLevels[level+1];
var monthlySpend = await allData.query({
groupBy: function(d) {
return [d.month, d[levelKey]];
},
select: {
$count: true,
total_spend: {
$sum: 'spend'
}
}
});
console.log(monthlySpend);
if ( parent != 'root') {
await allData.filter(hierarchyLevels[level], parent, false, true);
}
var filteredSpend = monthlySpend.data.filter(function(d) {
return Math.floor(d.value.total_spend.sum) > 0;
});
var pivotedSpend = pivotArray(filteredSpend);
console.log(pivotedSpend);
return pivotedSpend;
}
I call this function whenever the user interacts with the UI — they're drilling up and down through a hierarchy, and I want to render a chart that shows spend by month at each level of the hierarchy.
The parameters that the function takes are the identifier of the parent (the thing they clicked on), and the level, which represents the column of the data that I want to group by. Each level has a distinct column.
However, if I pass in the exact same parameters dynamically via the UI,
monthlySpend returns the correct values for total_spend, but not at the appropriate level of the hierarchy.
I'm calling
filterAll on allData before I call this function each time.
But I suspect something isn't being reset properly on subsequent runs of the function. Do I need to do something differently in order to make each run's query unique?
newb question - after running query, is there a way to get the complete objects from the universe that remain after filtering? I see in the result of the query that query.data is a list of key/values and values contains the count (in my case it appears count of 1 if it should be included, 0 if not). i was unclear if the appropriate way to get the set is to iterate on that object or if there was an automagic way
Like this link for lucene: https://github.com/thoward/lucene-query-parser.js
