How can I make a marking option affect the unique values in my dropdown list's column function?

Keywords: update Dropdown list values based on Marking, Marking, Dropdown

Details:

This requirement can be met by creating a data function that sends the marking values to a separate table where we can retrieve the unique values from the updated column.

Please refer to the Sample dashboard that is attached to this article.

The steps are still listed below:
1. Create a Data Function (Data>Data Function Property)

You can create either TERR or Opensource R based on Services available in your organization.

Script:
input -> output

Input Parameter Name:
input

You can select the relative data type:

Output Parameter Name:
output

You can select the Table.

Editing Parameters of a DataFunction.

Providing the Input/Output Parameters.

2. Creating the Property Control

Follow the following steps to create a drop down property control.

1. First, add a Text Area to your page.
2. Right-clickon the Text Area and selectEdit HTML.You can also select Edit Text Area, but once I learned to use HTML and avoid the GUI, I stopped using Edit Text Area.
3. Click theInsert Property Controlbutton.
4. Then, select Drop-down list.
5. Click theNewbutton.
6. Name the property control and set the data type for the data you are working with. I will name mine Sample.
   
   
7. Don’t enter anything in the Value text box.
8. Then, click Ok.
9. In the Set property value through: drop-down, there are several options…(for this example, choose Unique Values from Column)…
10. 
    
11. Unique values in column – choose this if you want the drop-down to populate with the unique values from one column
12. Then, click Ok.
    
    
    

It should work as expected but if there are any problems please contact Support.