Skip to main content
R
rtaylor-31-Visitor
1-Visitor
October 15, 2015
Solved

Query and Group By

  • October 15, 2015
  • 1 reply
  • 4517 views

Greetings,

I have a requirement for storing some data in a Stream and then providing a service to query that Stream and aggregate the results by certain value columns.

For example, if i had a stream backed by a DataShape containing ID, NumericValue columns, and i wanted to rollup the numeric values to the beginning of each month (using the Stream Timestamp), is this even possible using the Query/filtering API?

Best answer by paic

Use Query to get your slice of data and then use Aggregate (InfoTable Functions) to get the roll up.

1 reply

P
paic1-VisitorAnswer
1-Visitor
October 15, 2015

Use Query to get your slice of data and then use Aggregate (InfoTable Functions) to get the roll up.

R
rtaylor-31-VisitorAuthor
1-Visitor
October 15, 2015

Thanks Pai. I'll give it a try.

R
rtaylor-31-VisitorAuthor
1-Visitor
October 16, 2015

Yep....worked. Thanks.

Terms & ConditionsCookie settingsAccessibility statement