Selections - maneeshpal/Drata GitHub Wiki

Selections are the properties you select to visualize in a chart.

1. Autocomplete textbox dropdown:

   All the available properties are mapped to a dropdown textbox combo that helps you find the property you want to select.

2. Dropdown prefix for aggregate function:

   This dropdown has value, count, sum, min and max. By default ‘“value” is selected which means that there is no aggregation. The other options apply aggregate functions to selected property.

3. Compound Selection:

   A that converts simple selection to compound selection which let's you apply arithmetic operation between 2 or more properties.

4. Percent change:

   This option is available on Line, area and trend charts only, since these charts visualize the trend of data over time. With this flag, you have the ability to specify the percentage change for the selections you make. For example, In a line chart, when you may check percentage change for a property "price", then instead of rendering the value of price over time, the chart renders percentage change of the value of "price" over time.

5. Distinct:

   This option when checked, will select distinct values for the property selected. A **Disctinct** clause on one selection **will not** affect other selections in a query.

A sql inspired select statement is dynamically built while you interact with selection boxes.

A selection made using 1 property.

You may have as many nested levels of complex selections as you wish. In the above figure, the complex selection involves calculating "subtotal" from "price" and "discount". Every complex selection should have “Alias name” specified, which will be used for display purposes.