topic Re: Duplicate values on dropdown multiselect input in Dashboards & Visualizations

Duplicate values on dropdown multiselect input

MeMilo09 — Wed, 28 Apr 2021 00:37:35 GMT

Hello All,

I keep getting duplicates on my values for multiselect dropdown. I made sure my fields were correct the - field for name and field for values and query on the search. Not sure what else I need to check for. My source below... Any advise is welcome.

<input type="multiselect" token="tok_space_name" searchWhenChanged="true"> <label>Select Space</label> <choice value="*">All</choice> <default>*</default> <prefix>(</prefix> <suffix>)</suffix> <valuePrefix>space_name="</valuePrefix> <valueSuffix>"</valueSuffix> <delimiter> OR </delimiter> <fieldForLabel>Select Space</fieldForLabel> <fieldForValue>space_name</fieldForValue> <search> <query>index="lll_soruceIdx.idx" | stats values(space_name) as space_name | mvexpand space_name</query> <earliest>$time_range.earliest$</earliest> <latest>$time_range.latest$</latest> </search>

Re: Duplicate values on dropdown multiselect input

vikasjha001 — Wed, 28 Apr 2021 02:28:01 GMT

Could you try adding below command as well in the end of the search query. This should remove any duplicate entries for space_name

| dedup space_name

Regards,

Vikas Jha

Re: Duplicate values on dropdown multiselect input

bowesmana — Wed, 28 Apr 2021 05:46:50 GMT

Your '<fieldForLabel> should be a field in the data from your search to use as the visible dropdown, not the text

'Space Label', so change it to space_name

Also your search is probably better as

index="lll_soruceIdx.idx" | stats count by space_name

so you don't first collapse all spaces and then expand them again.