Create sentences and paragraphs to describe the results from your data. Multiple lines of custom text can be created based on one or more tables, calculations, or variables.
Method
- Add the object by selecting from the menu Automate > Browse Online Library > Data > Dynamic Text Box
- Choose a Data Source.
- Select the Input data.
- Surround the text in commentary by typing into Text before and Text after.
- Once you have chosen your first result to display, additional sections of the menu will open up to allow you to add to the text by selecting other data sources and entering additional text.
- The format of the text may be changed using Properties > Appearance and wrapping of the text is controlled using Properties > Layout > Wrap text output.
Example
In this example, the Dynamic Text Box has been connected to a table showing the NPS for major tech brands, and a calculation of Displayr's NPS (done using R).
Options
As you make selections, additional sections of the menu will be added. Each has the following options:
Data source Choose what type of data source you want to use to obtain the number. The choices are:
- Type or paste value Enter the number you wish to show.
- Table Obtain the number from a table of data.
- Use an Existing Calculation Obtain the number from a calculation that has been done using R.
- Variable - Average/Sum/Percentage Compute the number you wish to show directly from a variable.
- Combo Box or List Box Show the selection in a combo box or list box.
Input data Select the data you wish to use. Options will be shown based on the type of Data source that has been selected.
Number Type Choose to format the number as it is, or convert it to a percentage.
Decimals shown Choose the number of decimal places to display.
Separate thousands with commas Choose whether or not larger numbers should have their thousands shown with commas. For example, show 1000> as 1,000.
Text before The text to display before the number.
Text after The text to display after the number.
Blank lines after Increase this to 1 to begin the next section of text on a new line, or increase it to 2 or more to add extra line spaces before the next section of text.