Loading...

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

  1. On Web Console, click Reports.

    The Reports page appears.

  2. 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.
  3. 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.
  4. On the Data Sets tab, click Add .

    The Add Data Set dialog box appears.

  5. At the top of the dialog box, from the list, select R Script, and in the Data Set Name box, type a name.
  6. In the Source Data Set box, click and add the data set.
  7. 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

  8. 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)

  9. Click Done.

    The data set you created appears in the Report Builder under Data Sets.

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