Getting a table's column value to use in a custom filter

[jcraocolici]

I have a column in one of my tables called "Campaigns". I would like to use the distinct values in this column to create a custom filter dropdown. Is this possible with the javascript API? I'm stumped.

Thanks!

[Eric_Zhang]

---

@jcraocolici wrote:

I have a column in one of my tables called "Campaigns". I would like to use the distinct values in this column to create a custom filter dropdown. Is this possible with the javascript API? I'm stumped.

Thanks!

---

@jcraocolici

As far as I know, it is not possible to get the distict value of one column when loading the report. A custom filter demo for your reference.

[shzyincu]

Very easy, follow the steps

1. Load the dataset using IMPORT from the table.

2. Left sidebar in your dataset window right click on the query and choose refrence.

3. Goto the refrence query and remove all other columns leave the column where you want distinct values. 

4. Right click the column and select remove duplicates. Close and apply.

Drag the column name from the refrence query on the slicer component and use first query fields on any other visual component. it will work.