topic dynamic query for dropddown in Dashboards & Visualizations

dynamic query for dropddown

guillecasco — Fri, 27 May 2016 18:57:15 GMT

I have a Query from 1 index that brings a list of some ID (about 300) they have dedup comand so that it brings me unique values. simple query like this

index= index1 |table partnerId|dedup partnerId

partnerID
aaaa
ssss
ffff
hkfk

I exported table to Excel and check that no value was duplicated.
But when i create a dropdown (so i can filter some results by this ID) to include it in a dashboard, and i put that Query it says: "Duplicate values causing conflict". what can it be causing this? As i said, i exported results in excel and no duplicated value was found (excel usually matches value wheter they are upper or lowercase).
Maybe the list of values is too long ? I don´t know what else to think.

Re: dynamic query for dropddown

ryanoconnor — Tue, 31 May 2016 00:49:26 GMT

Two things you might want to check:

Are you sure you're setting the correct "Field for Value" and "Field for Label"?

Also are you sure that you don't have any "Static Options" set that might be conflicting with the dynamically populating values?

Re: dynamic query for dropddown

thilleso — Tue, 31 May 2016 06:34:10 GMT

Try reversing the order of the table and dedup command index=index1 | dedup partnerId | table partnerId

Might be that Splunk ignores the dedup once you've listed the results with table.

Re: dynamic query for dropddown

guillecasco — Thu, 02 Jun 2016 15:19:12 GMT

That was it The field for label had a space when y pasted it...hehe thanks man