Count rows in large objects

[frello]

Hi everyone,

We try to show the number of rows for an object in a Workshop application (expected results is around 2M objects). The only thing we found is an approximate count, which is not correct because just beneath we show a graph and numbers don’t match. We tried to build a typescript function to compute the right number but we didn’t succeed, too many buckets/rows. Is there an alternative we didn’t think of ?

Thanks

[Ben]

Hi,

count should be exact, are you sure you haven’t selected approximate cardinality? Otherwise, how have you got your objects and variable set up (eg synced to os2v, integer variable with object set aggregation etc)?

[frello]

Yes sorry, my fault, I wrote this a bit too quickly this morning. In fact we don’t want to just count the rows, but instead count the number of distinct values for a column in particular.
We tried a groupBy and count on the objectSet passed in parameter in a TS function but this results in a “too many buckets” error.