http://forums.visokio.com/discussions/tagged/unique_count/feed.rss Mon, 30 Oct 17 17:31:03 -0400 Tagged with unique_count - Visokio Forums en-CA 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/2586/formulae-counting-records-by-months Tue, 10 Jun 2014 04:41:49 -0400 MattBoxall 2586@/discussions
I'm currently trying to put together a formulae field that will calculate the number of new cases opened (using a field with various dates noted) within the previous calander month. the difference is the core Excel data will be updated monthly and I want to have this automated rather than having to change the formulae field every month to reference a specific date.

I've tried using DATEADD and then an IF but I can't get recommended fomulae to work as GETDATE is not recognised. Any ideas how I can achieve this in Omniscope?

thanks,

Matt]]> http://forums.visokio.com/discussion/1839/subset-functions-non-empty-record-counts Wed, 17 Oct 2012 05:34:17 -0400 mohamed 1839@/discussions
"SUBSET_NONEMPTYCOUNT([Sumofvalue], SUBSET2([Store Description],[Week]))"

Please see attached file and look at the formula "Week Count", the top value should return 34 but it returns 52. I am not sure where I am going wrong.

Please see the Pivot view, it shows the Weeks against all the stores where I see empty record, I would like to discard in the calculations.

Regards, Mohamed]]> http://forums.visokio.com/discussion/1715/subset-function-unique-combinations-of-two-fieldss Fri, 17 Aug 2012 07:37:57 -0400 Alexander 1715@/discussions
I get the following message:

Cannot use field value references. This formula is evaluated in the context of multiple records, without any specific individual record. You must identify the summary function, such as: SUBSET_SUM([locplaats]) or SUBSET_MEAN([locplaats]). If using SUBSET([locplaats]), you must specify at least 2 arguments, such as SUBSET([locplaats], "Required value").

I think this is a bug, or I am doing something completely wrong. Please advise... Thanks! (Running 2.7 b413)
Regards, Alexander]]>