Using the Data Table Analytics module

Once a table is selected (or if you’re in the detail view) an option is shown in the side bar called “Analyse data”; selecting this will open the Data Table Editor and the analytics modules will be shown on the right of the screen. Note, you can also run the analytics models in the same way by selecting a csv file.

Once the table opens, you can run a module in one of two ways.

Selecting the module you are interested in

From the list on the right hand side, select the module you are interested in and the module will open on the right half of the screen. Use the drop-down boxes to select the table columns you are interested in analysing. When the mandatory boxes are filled, your chart will be generated and shown. You can change the columns by selecting different columns in the drop-down boxes and using the “play” button beside the module name. You can select a different module by clicking on the module name.

Selecting the data

From the data table editor, you can select the columns of data you are interested in analysing by clicking on the column names. As you select more columns, the compatible modules will be shown in the module list on the right side of the screen. Once you see a module you are interested in, click on the module and the visualisation will open. Again, you can change the data by selecting different columns from the drop-down boxes and then clicking the “play” button.

Reusing the data

Below the generated image is a button called </> Show code, hovering your mouse over this button gives you two options, Copy to clipboard and Send to R console. Using the Copy to clipboard option will copy the R code used to generate your image to your clipboard so that you can use it elsewhere. Using the Send to R Console button will copy the code to an existing R console if you already have one running or it will open a new session and copy the code there.

Troubleshooting

Please note that analytics modules will only be able to be run on tables which have 100 columns or less or 10,000 rows or less; there is no maximum data size limit (as long as the data fits in the table size 100×10,000) For CSV files, there is no column limit but there is a row limit of 10,000 rows and the modules will only run on csv files which are 10mb or smaller.

Updated on December 1, 2020

Was this article helpful?

Related Articles

Not the solution you were looking for?
Click the link below to submit a support ticket
CONTACT SERVICE DESK