Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

A dropdown  dropdown component creates a dropdown menu on your analysis sheet to select values directly from a data source. This data source is taken directly from your data model.

By selecting a value from the dropdown, the user will automatically create Selectiona selection.

This can (for example) be used to filter for various suppliers or customers.The upcoming example will focus on vendors.

 Image Removed

Image Added 

Users can select any items from the dropdown list. According to the Multiselect option in the configuration, they might even select multiple items. 

After they confirmed their selection with Image Removed, a selection is applied.

 

The following configuration options are available:

 

Image Removed

 

Expand
titlePlaceholder text

The dropdown component allows to create selections based on data within your datamodel:

  1. Click on the dropdown to expand it.
  2. Select all or none with the top checkbox.
  3. Search for values.
  4. Select from the data entries.

Image Added 

In the dropdown settings you can define:

  1. The placeholder text on the dropdown.
  2. The PQL statement to get the dimension to choose from.

The Placeholder text is displayed in the dropdown field:

Image Removed

 

It will also show up, after you or a user of your analysis has made his selection in the dropdown menu:

Image Removed

 

Expand
titleDropdown items
Expand
titleMultiselect

If you activate the Multiselect checkbox, users can select multiple items from the dropdown list.

Image Removed

 
  1. This is where we can set the content of our dropdown list.

You can enter any PQL statement or use the well known Formula Editor.

 

Image Removed

 

  1. Set if the user can select multiple or only single values from the dropdown.