http://forums.visokio.com/discussions/tagged/aggregation-in-views/feed.rss Mon, 30 Oct 17 16:10:13 -0400 Tagged with aggregation-in-views - Visokio Forums en-CA http://forums.visokio.com/discussion/2904/table-view-different-behaviors-of-details-pop-upss Fri, 10 Apr 2015 06:36:05 -0400 fcavalieri 2904@/discussions In the 2.9 release, in Table View, I have different random behaviors of details links (i.e. in attachment).

I'd need always get the unaggregated data, when I open details in an aggregated table view (like in details3).

Thanks!]]> http://forums.visokio.com/discussion/2864/table-view-in-view-aggregation-unique-value-sort-orders Tue, 10 Mar 2015 08:24:47 -0400 rng 2864@/discussions
The comma separated unique values displayed in those columns are being auto-sorted which is misaligning the sequence of values & potentially misrepresenting the list value mapping. Could I prevent this sorting of the unique-value-lists?

Thanks, Rohan]]> http://forums.visokio.com/discussion/2826/bar-view-exporting-aggregated-data-as-tables Thu, 22 Jan 2015 05:35:22 -0500 alex7thompson 2826@/discussions
For instance consider the attached image. It would be useful to be able to get the percentages per month as just 25 rows of data rather than only being able to export raw data.

Thanks

Alex]]> http://forums.visokio.com/discussion/1947/performance-multi-field-in-view-aggregations Wed, 12 Dec 2012 10:57:34 -0500 aknotts 1947@/discussions
Thanks, Andy

]]> http://forums.visokio.com/discussion/1832/aggregation-formula-result-option-for-viewss Sun, 14 Oct 2012 23:46:58 -0400 shaji_o 1832@/discussions
However I can't see this option for graphs. Is this option available for a line/bar graph? Or any other graph for that matter?]]> http://forums.visokio.com/discussion/1711/aggregation-how-to-aggregate-averages-correctlys Fri, 17 Aug 2012 02:46:41 -0400 shaji_o 1711@/discussions http://forums.visokio.com/discussion/1694/aggregation-weighting-optionss Mon, 06 Aug 2012 12:41:04 -0400 kmatrix999 1694@/discussions http://forums.visokio.com/discussion/1320/aggregation-number-of-records-is-always-1-s Mon, 20 Feb 2012 00:47:42 -0500 naruemon 1320@/discussions http://forums.visokio.com/discussion/891/aggregation-viewing-multiple-record-detailss Tue, 26 Jul 2011 04:07:28 -0400 steve 891@/discussions http://forums.visokio.com/discussion/19/table-view-difference-between-aggregation-and-groupings Thu, 04 Dec 2008 09:06:39 -0500 Guy_Cuthbert 19@/discussions
Aggregation allows the Omniscope to work on a reduced data set - so the chosen view (including a Table View) is displaying a different set of data - whereas Grouping is a means of hiding or revealing some of the rows in the data set. It is quite possible to use both techniques together to hide/reveal (Grouping) summarised data rows (Aggregation). The essential difference can be though of as this:

* Aggregation is a data-level summarisation technique which causes data to be summarised before it is presented to the user in one of many views
* Grouping is presentation-level Table View (only) summarisation technique which allows rows to be "rolled up" to a summary level and then expanded by the user to get back to the underlying detail in the Table

When data is aggregated, Omniscope will combine rows based on the options selected - typically this is used to create a summary level of data which can then be manipulated as if it were the base data set in Omniscope. The user selects one or more fields to aggregate by, and Omniscope generates a summarised data set where the values of the selected fields are retained, but all non-selected fields are either ignored (shown as an aggregation value of none) or summarised in some manner (e.g. sum, mean, maximum etc.).The resultant summary data set can be manipulated in Omniscope exactly as if it were the base data held in the Omniscope IOK model. For more information on Aggregation search the FAQ for additional examples.

Grouping allows the user to "roll up" rows within a Table View and then "drill down" into detail within the rows. Grouping is a presentation-level technique and, as such, alters the way in which Table View data is displayed. Once Grouping is active, on one or more fields, Omniscope places an expansion arrow next to each summarised row to allow the user to expand the rolled up row and see the individual data rows beneath (subject to the Grouping > Settings > Expandable tree options being ticked). Grouped data cannot be sorted (the underlying rows are sorted, but not the grouped totals) which can cause confusion - if you need to sort columns of summarised data then use Aggregation.]]>