Customizing Data

In the Data settings of Arcadia Instant, you can do any of the following:

To get to the options in the Data menu, follow these steps:

  1. On the right side of Visual Designer, click the Settings menu.

    Settings menu of Visual Designer
  2. In the Settings menu, click Data.

    data settings

Disabling Incremental Queries

To disable incremental queries for this visual, navigate to the Data menu, and select Disable incremental queries.

disable incremental queries

Displaying NULL Rows

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.

null data masking

By default, this value is null. This is how the visual appears:

displaying null masking

If the value is cleared (a blank), this is how the visual appears:

displaying null masking

If the value is set to a few dashes (---), this is how the visual appears:

displaying null masking

Ordering NULL Rows

Availability Note. This feature is only available on Arcadia Engine, Impala, or PostgreSQL connections.

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.

null ordering of data
  • Default NULL ordering shows NULL data 'as is', without sorting the results.

    default null ordering
  • First NULL ordering shows NULL data first, after the sort of the specified column.

    first null ordering
  • Last NULL ordering shows NULL data last, after the sort of the specified column.

    last null ordering

Changing Maximum Number of Rows Fetched

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.

change max number of rows fetched

Changing Number of Rows to Download

To change the number of maximum rows downloaded, navigate to the Data menu, and change the value under the heading Number of rows downloaded during CSV export and Detailed Data.

change max number of rows downloaded

Specifying Qualitative Range as Percentages

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.

specifying qualitative ranges as percentages