Quiver - Allow for calculated fields in object sets > 50k

[pedro]

When doing aggregations on object sets for analysis in Quiver, a very standard use case that all relevant BI tools allow for is to have pre-aggregation calculated fields.

If I have an object set over 50k, I currently can’t do something as simple as AVG( X - Y), where X and Y are two numerical properties of my object set.

If the standard Expression transforms are not an option due to in-browser memory limitations, formula metrics of both charts and pivot tables should at least be extended to support this capability.

[zschadt]

Hey @pedro,

This is a good idea, I will bring this to the Quiver team!

A workaround in the meantime could be to use Quiver materializations which enable working past the 50k object scale limit!

Best,
Zach

[pedro]

Thank you @zschadt !

I tried the materializations but you can’t do anything other than super basic charting on them in Quiver. And you can’t even have timestamp fields in the X axis of those charts. So not enough for my current goals

[jbaird]

@pedro

And you can’t even have timestamp fields in the X axis of those charts

Hey @pedro could you clarify what you mean by “you can’t even have timestamp fields in the X axis of those charts”? The “Categorical chart from materialization” card allows choosing a timestamp column in the “Group by” section.

[pedro]

I don’t have a materialization to test it on right now but when I did it seemed that it treated the timestamp as a categorical variable, not as a time variable that could be grouped into different granularities. Is this not the case?