Tagged with R-analytics - Visokio Forums

Setting up R for Omniscope 2.9

glen — Mon, 01 Jun 2015 09:30:43 -0400

Omniscope integrates with open source analytics libraries written in the R language, making R-based analytics more accessible and productive since data scientists and business users can work together, each doing what each does best.

Installing R is a simple process, but is required for use within Omniscope. This Forum post details how the user does this by completing the following simple steps.

Select the link below which corresponds to your current operating system to install R. The process is similar to installing a normal piece of software. It is particularly important to note where R has been installed (the R binary path) if the default location is not used.

http://cran.r-project.org/bin/windows/base/

http://cran.r-project.org/bin/linux/

http://cran.r-project.org/bin/macosx/

Each of these links also has helpers for installing R in each of the operating systems.
Now the R binary path needs to be configured in Omniscope. This is done by selecting:

Data > R statistics > R settings…

This will open the following window:

The default location for R is already entered into the R binary file path. If you have installed R to a different location then this will need to be entered manually. Once this step has been completed click “Check now” to ensure that Omniscope is able to use R’s functionality. This will open the following dialog box:

If this is displayed then you are ready to use R functionality inside Omniscope.

Scripting: Converting Hexadecimal string to Decimal number?

sherriff — Sat, 16 May 2015 15:03:55 -0400

I need to convert a Hexadecimal string into Decimal

Any suggestions as to how to do this?

R Analytics: "K-means clustering" option of "R statistics operation" block broken?

joshlk — Thu, 07 May 2015 12:21:53 -0400

When executing the "K-means clustering" option of "R statistics operation" block an error is raised:

"Error executing R operation.

Error in data.frame(input_data, cluster) :
arguments imply differing number of rows: 139, 61
Execution halted"

I had a look at the underlying R code and it looks like the data is first filtered for null values:

"subset<-na.omit(subset)"

But the last operation tries to remerge the original dataset with the clustering results even though some of the original lines where omitted.

Versions -
Omniscope: 2.9 build 1593 x64
R version: 3.2.0

Formulae: EMA (Exponential Moving Average) self-referencing formula: R solution

Oke369 — Wed, 30 Apr 2014 05:01:18 -0400

Good day

Kindly assist, Please see attached Excel Sheet, The formula I'm calculating is self referencing.
Cell H15 is average formula, Cell H16 is the start of the new formula where it references the cell above.

Please advise if any more information is needed.

thank you