Hi team,
I work for Walmart and we build looker reports on item data which goes into a million records at a time. i love the speed and efficiency of using looker for such large data sets but one of the functionality that the team would like to have is to be able to filter for 100s and 1000s of Items at a time and at the moment it is difficult to add in so many items into one filter and even after doing so, the looker dashboard breaks
Can this feature be implemented or enhanced?
Hi,
Not sure I understand your question or not. So you want to filer items from #100 to #1000 (only see data for this rows). If this is is what you are looking for, you can create one more dimension and in your SQL, using rank() or row_number () function and providing a rank # for the row.
Later on you can use that rank as a filer and set the filer to be “advance option” which allow you to choose “is equal to ”, “is greater than” etc and input your #.
Thanks
Hi @Karen_Yu
Let me give more details - so there are products within walmart which are identified by a product id which is a numeric value. the data has over 10M rows of distinct product IDs
The use case is that the user would like to filter for 100K product IDs at a time and view the info - how would they do that?
Also consider that there are other users who would like to hit the same looker dashboard for a different set of 100K IDs - so the dashboard should be able to take in the input dynamically and adjust the report as needed
You can copy as much filter entries as you want, from f.e. a excel spreadsheet