I am trying StreamInsight for the first time, i am expecting a stream of data that comes from a DB, using many samples I could do it.

My question is, If I need to have some aggregated columns for example sum(price) for each event category - around 200 category exists , but want this sum to be accumulated over the time per category, not just flushed at the window size and rest again, how can i do that?