ProblemIn some cases, you want to capture a series of R commands in a text file, and you want to execute them from Sisense (edit formula).SolutionWrite script that will handle and manipulate the arguments you send from Sisense Open RGui or RStudio. W...
Problem You want to create a Control Chart in Sisense to study how a process changes over time. A control chart always has a central line for the average, an upper line for upper control limit and a lower control limit. By comparing current data to t...
ProblemYou want to determine if there are any problems with your dataset from the ElastiCube and whether the question you are asking for Sisense with R integration can be answered by the data that you have.SolutionInstalling the Sisense ODBC driver D...
Anomaly Detection with Sisense using RAnomaly DetectionAnomalyDetection is an open-source R package to detect anomalies which is robust, from a statistical standpoint, in the presence of seasonality and an underlying trend.The AnomalyDetection packag...
ProblemYou want to establish the connection between Sisense server console to the R server.SolutionInstalling Rserve Open an R console window. Run the command prompt: > install.packages("Rserve")Running Rserve Open an R console window. Load the Rserv...
Use caseImagine you're Jeff Bezos and you own a few servers. You sell compute on these servers to customers and you want to make sure that you always have enough computer power to meet demand. This means when overall RAM consumption approaches the ma...
Problem You want to create a Pareto Chart in Sisense from a collection of numbers that represent frequencies (or counts) of events or outcomes that fall into different categories. Solution R script (Copy paste to Sisense Formula) counts<-c(do.call('c...
To learn about how Sisense pipes data in and out of R and onto the display for visualization, we will review basic demos to make you say "aha!". Then we'll get a basic understanding of the underlying technologies that make this possible. Once you’ve ...
ARIMA Model ForecastingARIMA Model Forecasting Mean and Upper 95% LimitOVERVIEWIn this article, we tackle how to produce a robust forecast by using the Sisense and R integration.UNDERSTANDING THE NUANCE OF RFor forecasting functionality, we must cons...
ARIMA Model ForecastingARIMA Model Forecasting Mean and Upper 95% Limit OverviewIn this article, we tackle how to produce a robust forecast by using the Sisense and R integration. This use-case specifically focuses on a scenario where we only have da...
polynomial regression where x = day, y = cost polynomial regression degrees 2-4 Method The polynomial regression can be generated by the RDOUBLE formula below. The function in the example below is for a polynomial regression of the third degree. If y...
By default Rserve accepts no remote connections if no config file is supplied. By running the following R script from the R console on the Remote R Server you can enable remote connections: library(Rserve); Rserve(args = "–vanilla --RS-enable-remote"...
Recommended quick links to assist you in optimizing your community experience:
Developers Group:
Product Feedback Forum:
Need additional support?:
The Legal Stuff
Have a question about the Sisense Community?
Email community@sisense.com
