Optional. A map of each value in the data to a longer string of information. For example, a variable with records 0 , 1 , and 2 might have value labels for 0 = No, 1 = Yes, 2 = Don't know.
Value labels will be shown inline on the cells view of a table, alongside the frequency table values in the univariate statistics.
For continuous variables (integer, float, date, dateTime, time): the minimum and maximum of this variable.
For string variables: the minimum and maximum length of all values.
| | **Min lng, Min lat, Max lng, Max lat** | For geography variables: the bounding box containing all geospatial data in a variable | | **μ, σ** | The mean and sample (unbiased) standard deviation of the variable. Only available for continuous variables (integer, float, date, dateTime, time). | ## Univariate plots **Histogram** A frequency chart of observations, sorted into 64 buckets, clamped to three standard deviations of the mean on either side. To switch between a linear and logarithmic y-axis, click on the bottom left corner of the chart. Only shown for continuous variables with more than 64 distinct values. **Box plot** A visual display of the distribution of values by frequency. Shown are the minimum, 25%, median, 75% and maximum value. To include or exclude outliers in the calculations, click on the label on the bottom left corner of the chart. Only shown for continuous variables with a meaningful number of discrete values. {% hint style="info" %} The box plot uses the [APPROX\_QUANTILES](https://cloud.google.com/bigquery/docs/reference/standard-sql/approximate_aggregate_functions#approx_quantiles) BigQuery method, which will estimate quantiles ([±0.57%, 95% CI](https://cloud.google.com/bigquery/docs/reference/standard-sql/hll_functions)) for larger datasets. As such, the box plot values should only be used as an approximation. {% endhint %} **Frequency table** A table showing the frequency of common values for that variable, limited to 10,000 values. If a variable's values are highly heterogenous, no frequency table will be displayed. You can right click on values to get a quick entry point to filter on that value in the query tab. **Map** A table with variable of type `geography` shows a heatmap of the geospatial dispersion of that variable. ## Editing metadata To edit a variable's label, description, or value labels, click the **Edit metadata** button on the right of any table. This will allow you to any of the variables in this table, or you can navigate to the "All tables" tab to edit the same variable across multiple tables. In the metadata editor, you can edit a variable's metadata fields as you would in any spreadsheet, and save changes when you're done. When working in bulk, you can also [upload metadata directly](/reference/datasets/create-and-edit-datasets/populate-metadata.md).  ### Exporting metadata You can export your metadata at any time (in either of the above formats) by clicking **Export file** in the variable metadata editor. Variable metadata is also available in JSON format via the [variables.list](/api/rest-api/variables.md) API endpoint. ## Variable types All variables in Redivis have a type associated with them. All types in Redivis support `NULL` values; that is, an empty cell. ### **String** A string can be used to store any textual data (UTF-8 encoded). Moreover, a string is a "universal" data type — any other type can be converted to a string without error. Size: 2 bytes + UTF-8 encoded string size ### **Integer** A 64-bit signed integer. Supports any integer value between `-9,223,372,036,854,775,808` and `9,223,372,036,854,775,807` . Size: 8 bytes per cell ### **Float** A 64-bit (double precision) [floating point](https://en.wikipedia.org/wiki/Floating-point_arithmetic) decimal value. Size: 8 bytes per cell ### **Boolean** A representation of either `TRUE` or `FALSE` Size: 1 byte per cell ### **Date** Represents a calendar date independent of time zone. Supports any value between `0001-01-01` and `9999-12-31` Size: 8 bytes per cell Format: `'YYYY-[M]M-[D]D'` * `YYYY`: Four digit year * `[M]M`: One or two digit month * `[D]D`: One or two digit day All values in brackets are optional. If your Date is not in this format, you can convert it using [format strings](/reference/workflows/transforms/step-retype.md#reference-format-elements). Redivis will attempt to convert other [common date formats on upload](/reference/datasets/create-and-edit-datasets/import-tabular-data.md#variable-names-and-types), when possible. ### **DateTime** Represents a year, month, day, hour, minute, second, and subsecond, independent of timezone. Supports any value between `0001-01-01 00:00:00` and `9999-12-31 23:59:59.999999` Size: 8 bytes per cell Format: ``` 'YYYY-[M]M-[D]D[( |T)[H]H:[M]M:[S]S[.DDDDDD]]' ``` * `YYYY`: Four digit year * `[M]M`: One or two digit month * `[D]D`: One or two digit day * `( |T)`: A space or a `T`separator * `[H]H`: One or two digit hour (valid values from 00 to 23) * `[M]M`: One or two digit minutes (valid values from 00 to 59) * `[S]S`: One or two digit seconds (valid values from 00 to 59) * `[.DDDDDD]`: Up to six fractional digits (i.e. up to microsecond precision) All values in brackets are optional. If your DateTime is not in this format, you can convert it using [format strings](/reference/workflows/transforms/step-retype.md#reference-format-elements). Redivis will attempt to convert other [common datetime formats on upload](/reference/datasets/create-and-edit-datasets/import-tabular-data.md#variable-names-and-types), when possible. ### **Time** Represents a time, independent of a specific date. Supports values between `00:00:00` and `23:59:59.999999` Size: 8 bytes per cell Format: ``` '[H]H:[M]M:[S]S[.DDDDDD]' ``` * `[H]H`: One or two digit hour (valid values from 00 to 23) * `[M]M`: One or two digit minutes (valid values from 00 to 59) * `[S]S`: One or two digit seconds (valid values from 00 to 59) * `[.DDDDDD]`: Up to six fractional digits (i.e. up to microsecond precision) All values in brackets are optional. If your Time is not in this format, you can convert it using [format strings](/reference/workflows/transforms/step-retype.md#reference-format-elements). Redivis will attempt to convert other [common time formats on upload](/reference/datasets/create-and-edit-datasets/import-tabular-data.md#variable-names-and-types), when possible. ### **Geography** Represents a Point, Multipoint, Linestring, MultiLinestring, Polygon, or MultiPolygon geometry, as specified by the [GeoJSON standard](https://geojson.org/). You can create or manipulate geographic variables using various [methods](/reference/workflows/transforms/step-create-variables.md). Size: 16 logical bytes + (24 logical bytes \* number of vertices) Format: The [WKT format](https://en.wikipedia.org/wiki/Well-known_text_representation_of_geometry) is used to show cell values, though each geography cell can also be viewed on a map by clicking on that cell within a table. ``` '(POINT|MULTIPOINT|LINESTRING|MULTILINESTRING|POLYGON|MULTIPOLYGON)(...)' -- Multiple of above geometries may be wrapped with '(GEOMETRYCOLLECTION)(...)' ``` ## Conversion rules Some types can be implicitly converted within a query (e.g., `1 (integer) < 2.2 (float)`), in other circumstances, you will explicitly need to convert the type of a variable before performing certain operations (e.g., `"1.0" (string) < 2.2 (float)`). Variable types can be converted within the [transform](/reference/workflows/transforms.md) interface in a [workflow](/reference/workflows.md). The following conversions are supported: | From | To | Rule(s) when casting x | | --------- | --------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | Integer | Float | Returns a close but potentially not exact FLOAT64 value. | | Integer | Boolean | Returns `FALSE` if `x` is `0`, `TRUE` otherwise. | | Float | Integer |Returns the closest INT64 value.
Halfway cases such as 1.5 or -0.5 round away from zero.
Returns an approximate string representation.
Returns x as a FLOAT64 value, interpreting it as having the same form as a valid FLOAT64 literal.
Also supports casts from "inf", "+inf", "-inf", and "nan".
Conversions are case-insensitive.
Returns TRUE if x is "true" and FALSE if x is "false"
All other values of x are invalid and throw an error instead of casting to BOOL.
STRINGs are case-insensitive when converting to BOOL.