Forum Discussion
Solved
Help with Mutiple Filter options
Hello, everyone. I downloaded a NetFlix dataset wich contain a lot of movies and shows details. From description, imdb score, imdb votes, production countries, and so on. I've almost finished th...
Hi Lipao255,
I had done something similar longtime back. From your dataset, you could create another table with "imdb_id" and split the production countries which are seperated by comma.
Connect this table to your table (fact) with "imdb_id" as key. you could remove production countries in the fact table.
Below example.
From
Into
Hi lipao255,
Can you use text filter as visual filter?
Let me know if this resolves your issue.
Is there a way to use it as suspended list? I don't think it's suitable for a user to type the genre.
Do you mean as drop down list? if not, you could again use create another table with split column with comma from genre. It is similar to production countries as I mentioned earlier.