Provide Statistical Analysis from R Analytics

The R Integration Pack is in maintenance development status as of March 2024. No new features are planned. Only critical security updates will be provided.

You can perform statistical analysis in MicroStrategy Workstation using R analytics. Once an R script is deployed to MicroStrategy Workstation as a derived metric, the statistical analysis can be added to and analyzed on visualizations. An example of trend analysis is shown below.

MicroStrategy Workstation supports the deployment of R analytics from the R statistical environment as derived metrics. R is an open-source language and environment for statistical computing and graphics. The third-party R environment is freely available, as a separate download.

1. Open the dashboard you want to modify.
2. At the top of the Datasets panel, click More and choose Create Metric. The Metric Formula Editor opens.
3. Type a name for the metric in the Metric Name field.
4. Copy the metric expression, that describes the R script, from the deployR utility of the R Integration Pack.
5. Paste the metric expression into the Formula field.
6. Map all of the inputs for the metric expression, which are included in parentheses and separated by commas at the end of the metric expression, to metrics available in the dashboard. Each input must map to one metric in the dashboard.
7. Click Save.

Related Topics

Metrics in Dashboards

Derived Metrics: Metrics Based on Existing Objects

Create a Derived Metric Using the Metric Function Editor

Create a Derived Metric On a Grid Using a Shortcut

Create a Derived Metric by Combining Two Metrics with an Operator

Create a Derived Metric by Combining Multiple Metrics

Create a Derived Metric by Selecting the Aggregation Function

Create a Derived Metric from an Attribute

Create a Derived Metric from Scratch Using the Metric Formula Editor

Add Conditional Calculations to a Derived Metric Using the If and Case Functions

Change the Aggregation and Subtotal Behavior for a Derived Metric

Edit Derived Metrics from the Dashboard

Rename Derived Metrics from the Dashboard

Delete Derived Metrics from the Dashboard