Filter doesn't work with the right type of data

Bug reports
1

Hello,

The filter on one column is set on checkbox, and sometimes it becomes a text field. And then it reappears as check boxes. Would you know why it happens, and if yes, could you fix it?
Thanks!

Capture d’écran 2024-02-13 à 13.31.24
Capture d’écran 2024-02-13 à 13.31.241893×363 51.6 KB

Capture d’écran 2024-02-13 à 16.36.16
Capture d’écran 2024-02-13 à 16.36.16682×1556 66.7 KB

2

How many distinct values does the field have?

3

There are 64 distinct values

4

Hello,

Are you sure that partstore_persistedoffer.distributor has been recognized by the right type ? You can check in "parcourir les données" -> "nom de votre base de donnée" -> "apprendre au sujet de cette table" on partstore_persistedoffer -> "champs de cette table" -> "type de champ" on distributor

I don't know if it's will help you, but I know that the type identified has a real impact on filter.

PS : sorry for luiggi I put indications in french :smile:

5

Thanks for the advice. I checked and the type of the field is "Catégorie", so it should work as checkbox right?

6

Yes I think... But as you can see in the Metabase documentation it's depend of the quantity of data, the exact quantity isn't specified so, maybe, you're next to the limit and sometimes it's to much for the system and sometimes it's ok

image
image542×778 83 KB

I'm sorry, I think I can't help you more...

Here the link to the documentation page used for the screenshot : SQL parameters

1 Like
7

Ok thank you very much!!

1 Like