Aggregation: DM block - single average record unweighted?

ygulla · November 1, 2012 2:11PM

Hi, I've encountered a problem with the DataManager aggregation block.

I need to aggregate all records into one "total" row. Field A needs to aggregate as an average weighted by Field B.

When I drop in an Aggregation block, don't select any splits and the choose function for Field A to be mean and the weight to be Field B. The resulting value is unexpected... the result seems to be an unweighted mean?

NB: to make it work I had to add a constant field One (equals 1 for all records) and "split" by it.

See attached file for a trivial example.

Edit: I use 2.7 b441 x64

chris · November 2, 2012 11:06AM

Hi,

Thanks for letting us know about this. We are in the process of updating the aggregation engine, so we will ensure that this issue is also fixed. I'll post again once the fix is in place.

chris · November 12, 2012 5:17AM

Hi,

This bug has now been fixed. The fix will be available in tonight's Omniscope 2.8 release (b396).

Welcome!

Categories

Ideas Parade

Tagged