DROPDOWN not showing all values

[Dinkos]

Hi all,

I have a dropdown menu that uses the exact same query as my table. However, it is not showing all the dynamic values for the field I used (Partner, which is a string). If I export the table, all the values are present, so the search query itself seems to be working correctly.

Any ideas on why this might be happening?

I am using Dashboard Studio

Thanks!! 

[yuanliu]

How many rows does the search return?  Keep in mind that Dashboard Studio has a 1,000 dropdown limit. (Simple XML's limit is 10,000.)

[Dinkos]

Hi @yuanliu ,

yes that was the problem. I inserted a dedup on the field and it works.

Thank you to everyone!!

[gcusello]

Hi @Dinkos ,

to the dropdown search, did you passed also the search or also the time borders?

if you didn't passed the time borders, try to pass them.

Ciao.

Giuseppe

[Dinkos]

Hi @gcusello ,

yes I passed the time boardes.  From the DropBox editing:

Edit the Data sources: 

Thanks !!

[gcusello]

Hi @Dinkos ,

you are using the same time frame, but if you're using a relative timeframe, running the secondary search in a different moment, you are using two different time periods.

I mean: did you tried to pass as tokens the earliest and latest values from your main search to the secondary search?

e.g., if the time picker is called "Time", you should try to pass the tokens:

earliest=$Time.earliest$&latest=$Time.latest$

Ciao.

Giuseppe