Creating R Data Sets

Use data sets to collect the information that you will use to build charts, tables, and dynamic inputs.

Before You Begin

Configure an R server.
To create an embedded data set, your CommCell user account requires a role with the following permissions and associations:
- Add Report permission and an association with the CommCell entity
- Query Datasource permission and an association with the Data Source entity that you will use
For more information on users, permissions, and associations, see User Administration and Security - Overview.

Procedure

On Web Console, click Reports.
The Reports page appears.
Create a new report, or open an existing report:
- To create a new report, from the navigation pane, click Configuration > Reports and click New Report.
- To open an existing report and add a new data set to it, from the navigation pane, click Configuration > Reports, and next to the Report Name under Actions, click Edit.
On the Report Builder page, in the Report Name box, type a name for the report, and in the Description box, type a short description of the report.
On the Data Sets tab, click Add .
The Add Data Set dialog box appears.
At the top of the dialog box, from the list, select R Script, and in the Data Set Name box, type a name.
In the Source Data Set box, click and add the data set.
In the Data Set Query box, enter the R script on top of the source dataset to create charts and tables.
You can refer the data in the source data set in the script using the format dataset$id, where dataset in the source dataset name and id is the column name in the dataset.

Find below a sample R script for the data set query:

da<-data.frame(x=A$id,y=A$id*2)

da
To create plot charts using R, specify the R script in Plot query box.
Find below a sample R script using ggplot:

p<-ggplot(data=da, aes(x=x,y=y)) +geom_line()

plot(p)
Click Done.
The data set you created appears in the Report Builder under Data Sets.

Last modified: 1/16/2020 11:49:15 AM