Getting Distinct Values

(new in Alpana 2020 R1)

Most Widgets show aggregated data, and so they necessarily display distinct values.
For example, in Charts, data queries are grouped in order to have a single Y value for each separate point on the X Axis.

However, some widgets allow to meaningfully display redundant values.
For example, in a Grid, you may want to list all values of “produced diameter”, displaying multiple rows even if there is the same value multiple times.

This is possible by un-checking Distinct Values Only :

Example with Distinct Values Only enabled (default) :

Only distinct values are displayed.

Example with Distinct Values Only disabled :

Now all values are displayed, including several times the same value (if the data contains such occurrences).

Code192 2020 All rights reserved