Forum Discussion
Data filter based on a value to the main data set column
Hi,
you can create support table to handle it, and make relation within tha two table, but you need to add index/unix column for that, example,
| Main table column | id |
| One Two | 1 |
| Two | 2 |
| One Three Four | 3 |
| Three Four | 4 |
than you can create new table from query editor base from old table and split it, it;s oke if the create new row for this because it's not the main table,
the new table will be looks like this
| Split | ID |
| One | 1 |
| Two | 1 |
| Two | 2 |
| One | 3 |
| Three | 3 |
| Four | 3 |
| Three | 4 |
| Four | 4 |
so you just need create relation betwen this two table and make a slicer filter from second table..
Interesting approach! but my main data set is dynamic, it keeps changing every hour. And also I would need to use the main data column as I need to filter the rest of the table.
ok, Good luck.
my experience with this methode can handle my project with 30milion raw data, and the second table will automaticaly generate up to 80milion raw, and refresh automatically when data refreshed.
