A dropdown allows the user to directly select values from a data-table. From the selection he will directly create a selection for the whole analysis. In the dropdown settings you can select any data-table of your datamodel. Use the formula editor to define more specific selections.

 

 

 

 

  •  allows to specify if the user is able to select multiple entries of the dropdown or only one.

  • The Function section allows to enter formulas for the dropdown selection. For example entries of a column can be collected with a case when statement to have a smaller range of selections: " CASE WHEN "_CEL_O2C_ACTIVITIES"."SORTING" > 10 THEN '>10' ELSE '<=10' " would group the entries in two groups with the names '>10' and '<=10'.




 

 

 

 

  • No labels