In the Data settings of Arcadia Enterprise, you can do any of the following:
To get to the options in the Data menu, follow these steps:
On the right side of Visual Designer, click the Settings menu.
In the Settings menu, click Data.
To disable incremental queries for this visual, navigate to the Data menu, and select Disable incremental queries.
To change the data display of NULL values in the visual, navigate to the Data menu, and change the mask under the heading Display null value as.
By default, this value is null. This is how the visual appears:
If the value is cleared (a blank), this is how the visual appears:
If the value is set to a few dashes (---), this is how the visual appears:
To change the order in which NULL values appear in the visual, navigate to the Data menu, and select one of styles under the heading Show data with NULL values: Default, First, or Last.
Default NULL ordering shows NULL data 'as is', without sorting the results.
First NULL ordering shows NULL data first, after the sort of the specified column.
Last NULL ordering shows NULL data last, after the sort of the specified column.
To change the number of maximum rows fetched, navigate to the Data menu, and change the value under the heading Maximum number of rows to fetch.
By default, the system fetches 5,000 rows at a time.
Note that for table visuals only, the value on the Limit shelf overrides this setting.
To change the number of maximum rows downloaded during CSV export, navigate to the Data menu, and change the value for the option Number of rows downloaded during CSV export and Detailed Data.
This setting overrides the Maximum number of rows to fetch option in the Data menu. For table visuals only, it also overrides the value on the Limit shelf.
If the Number of rows downloaded during CSV export and Detailed Data option is not specified, the setting of the Maximum number of rows to fetch option specifies the number of rows to download. For table visuals only, the value of the Limit shelf is used first, but if no value is specified in this option, then the Maximum number of rows to fetch value applies. See Changing Maximum Number of Rows Fetched.
To render values that contain usable http addresses as navigation links, navigate to the Data menu, and select Show values starting with http(s):// as links.
Compare the appearance of the table visual with http...
content before
and after the preceding selection.
The Gauge visuals use the Qualitative Ranges shelf to define the fit of the main value (on the Measure shelf) relative the value specified by the Compare To shelf. An alternate approach is to specify these ranges as percentages.
To use the percentage option, navigate to the Data menu, and select Qualitative ranges as percent of target. Then specify the percentage value for the Lowest, Middle, and Highest ranges. By default, these are 60, 80, and 100, respectively.