topic Re: drop down filter issue in Dashboards & Visualizations

drop down filter issue

Keerthi — Sun, 25 Feb 2024 10:52:16 GMT

Hi, I dont understand the issue . the drop down filter is showing duplicate issues. can anyone pls help me how to resolve?

Re: drop down filter issue

gcusello — Sun, 25 Feb 2024 10:59:50 GMT

Hi @Keerthi,

in the results of the search you are using to populate the dropdown, there are some duplicated values, so you have to dedup your results fo the field that you're using for displaying.

If you could share your dropdown search I could be more detailed.

Ciao.

Giuseppe

Re: drop down filter issue

Keerthi — Sun, 25 Feb 2024 11:02:51 GMT

sure , this is what i see in search string inside. pls refer screenshot.

pls let me know if you need more information?

Re: drop down filter issue

gcusello — Sun, 25 Feb 2024 11:34:40 GMT

Hi @Keerthi,

you have to dedup for the firld that you display, in the first search you dedup for two fields. so it could be possible that you have duplicated values for the displayed field.

Insteda in the second search, I don't see any dedup command.

Add a dedup row dedupping for the field to display.

Ciao.

Giuseppe

Re: drop down filter issue

Keerthi — Mon, 26 Feb 2024 11:13:10 GMT

Hi,
are you telling me to write dedup command again. pls check the screenshot below:

Re: drop down filter issue

gcusello — Mon, 26 Feb 2024 14:35:51 GMT

@Keerthi ,

you need only the dedup for the field to listù, the other dedup isn't required.

in few words, you should run something like this:

<your_search> | dedup Time | sort Time | table Time

Ciao.

Giuseppe