I have a dashboard that I created for the business to research certain events that happen on our accounts. The dashboard has three datasets, one is basically all transactions, one is for rewards transactions, both have between 1.7 and 1.8 million rows. The other we call Remediations, which has about 450K rows.
The dashboard has multiple sheets, and uses the new cross-sheet filter feature AND Cross-dataset to filter across both datasets.
What the business has noticed is that some account numbers, cannot be searched. Meaning, if I type it into the search box under the top of sheet filter, it will return “no results”. But I have confirmed that the account number IS in the data set. I can get to it by narrowing down a different way (by store, for example).
Is there a limit to how many values a search box can index? There are a lot of account numbers (about 125K in the remediations dataset, and possible 5-6x that in the transactions dataset)… Or is there maybe a limitation in how it indexes in a cross-dataset filter?
Hello @TRube, I do believe you are running into a limitation here, but I think it is different than what you mentioned. I was not finding a limitation to the number of options regarding the search box, but are there certain accounts numbers that would only exist on one of the 3 datasets? If so, your filter is only going to reference values in the options dropdown related to the initial dataset it was created from.
The dropdown will only search through the values from the source dataset, but then the cross-dataset allows it to apply that value to a matching column across datasets. I see you mentioned having a dataset that is basically all transactions, I would recommend creating your filter, or your parameter dropdown options with that dataset. I think that may resolve the issue.