http://forums.visokio.com/discussions/tagged/aggregation_functions/feed.rss Mon, 30 Oct 17 15:44:11 -0400 Tagged with aggregation_functions - Visokio Forums en-CA http://forums.visokio.com/discussion/3171/aggregation-finding-the-row-count Thu, 08 Sep 2016 03:26:00 -0400 medine 3171@/discussions I started to use Visokio to export my reports, but I can not calculate row count when I aggregate data.

Could you assist me?]]> http://forums.visokio.com/discussion/3011/performance-datamanager-aggregation-block-operation-2.9-plus Wed, 07 Oct 2015 16:34:17 -0400 mraburgess 3011@/discussions
It has been running for 2 days now yet is only using 6GB of my 64GB RAM (windows 10 pro, Xeon 8 core processor, Omniscope version 2.9 build 1765 (rc) [plus] x64)

Is there anything i can do to make aggregate use the available RAM more intelligently - i have other files use far more of the RAM, but always have this issue with aggregation.

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/2687/aggregation-calculating-weighted-meanss Fri, 15 Aug 2014 08:40:24 -0400 Alexander 2687@/discussions
I am encountering a problem that I am aggregating a rather large dataset, but I am not able to choose a weight for the fields that I want to result as the average of the aggregated data.

Do you get what I mean?

The same problem is occuring as discussed in http://forums.visokio.com/discussion/2606/aggregation-why-are-some-fields-not-editables.

Please advise.

(Using custom build: Hotfix Function not supported 2.8 b 1276)]]> http://forums.visokio.com/discussion/2600/text-processing-google-analytics-string-aggregationcountss Mon, 16 Jun 2014 11:38:21 -0400 Ben_Owens 2600@/discussions
We currently have some features that pass some details in the URL (below is a very simplified example to illustrate my case)

www.mywebsite.com/fundfactsheets?ISIN=ANUMBER

So I'm getting in my data set

www.mywebsite.com/fundfactsheets?ISIN=0000001; page count 2
www.mywebsite.com/fundfactsheets?ISIN=0000002; page count 2
www.mywebsite.com/fundfactsheets?ISIN=0000003; page count 2
www.mywebsite.com/fundfactsheets?ISIN=0000004; page count 2
www.mywebsite.com/fundfactsheets?ISIN=0000005; page count 2
www.mywebsite.com/fundfactsheets?ISIN=0000006; page count 2
www.mywebsite.com/fundfactsheets?ISIN=0000007; page count 2

I really want this as aggregated data

www.mywebsite.com/fundfactsheets?ISIN* ; page count 14

I've not been able to find any regrex or way to manipulate the data within Visokio (new tool - it could be staring me in the face!!) to achieve this.

I've had a look on the forum but not seen anything there either.

Any ideas? I'm sure it will do this so any help will be gratefully received.

]]> http://forums.visokio.com/discussion/2295/aggregation-function-non-empty-counts Fri, 23 Aug 2013 05:36:37 -0400 Mees 2295@/discussions Is this expected behavior? Will be useful when this is possible.

Thanks, A]]> http://forums.visokio.com/discussion/2179/aggregation-weighted-average-functions Mon, 03 Jun 2013 12:58:40 -0400 peterg_at_aps 2179@/discussions
I want to calculate the mean latitude and longitude weighted by quantity demanded for some customer locations. However as soon as I select the mean for these fields a line appears next to the field with no options.]]> http://forums.visokio.com/discussion/1941/formula-summing-unique-value-countss Mon, 10 Dec 2012 09:07:48 -0500 BlaaackMambaaa1985 1941@/discussions http://forums.visokio.com/discussion/1882/aggregation-dm-block-single-average-record-unweighteds Thu, 01 Nov 2012 14:11:54 -0400 ygulla 1882@/discussions
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]]> 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/547/totals-in-table-view Wed, 08 Dec 2010 17:47:43 -0500 acm 547@/discussions
All numeric fields are are summed in the Totals row, but this is incorrect for the formula field.
Here the formula should work based on the total values in other fields.

Is this possible?]]> http://forums.visokio.com/discussion/1247/what-is-singleton-value-functions- Tue, 24 Jan 2012 09:01:08 -0500 aliceld 1247@/discussions http://forums.visokio.com/discussion/483/finding-maximum-value-over-aggregated-data Fri, 05 Nov 2010 11:55:07 -0400 indranildatta 483@/discussions