Aggregation: Number of records is always '1' ?

naruemon · February 20, 2012 12:47AM

In Graph view with field aggregations set, if I add one more line with 'Number of records', it always show that it has only 1 record. How could I get the total number of record (group by company name)? In the attached picture, one company has 34 records with highest summary but showing only 1 record.

steve · February 20, 2012 4:09AM

Naruemon,

When you use the "Aggregate" button on a view's toolbar, you are effectively transforming the data prior to supplying it to the view.

So the result is identical to aggregating the source data in DataManager. As such, "1 record" will show, meaning "1 aggregated record". This is demonstrated by the view toolbar barometer showing 1 aggregated record selected, contrasted with the main toolbar barometer showing 34 granular records selected.

Unlike the Graph view, the Bar/line view doesn't usually need you to use "Aggregate" in most situations. Think of it as an "auto-aggregating view". Since you have "Split: Comp_Name", you don't need to also "Aggregate: Comp_Name". Just remove the Aggregate option to resolve this.

(Separately, in your screenshot, the numbers on the left scale appear corrupted. Is this visible on your screen? Can you email the file privately to support@visokio.com?)

Steve

naruemon · February 21, 2012 1:16AM

Thank you very much for suggestion ^_^
For the left scale, it is not corrupted and is visible. No need to worry about it.
Anyway, thanks again for your concern :D

Welcome!

Categories

Ideas Parade

Tagged