Dynamic filtering with large lists

user038587
user038587 Member
edited March 2023 in Scheduled Reports

Is it possible to pate a list of values from a text file or an excel column to filter down a table view or a dashboard? I want to be able to constantly filter for different large lists of ids to only show data for these ids in the dashboard or cards.

Comments

  • Hi @user038587 

    The easier option is to take that excel file upload it to Domo and utilize a dataflow with a join to filter on those values. One caveat to this though is that it will remove the other values and you won't be able to filter on those  values any more in your card.

     

    There isn't a way to filter on a giant list via the card filters currently.

     

    There is a Beta currently for filter page views which would allow you to pre-define (although this would be manual and could take some time) and save those filters. Then a user can just select the pre-defined filter on the page and filter your dataset that way.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • Instead of uploading an excel spreadsheet, i'd use a Webform because then I can alter the values as necessary inside the Domo UI.

     

    Instead of JOINING in ETL, I'd use a Fusion to LEFT JOIN the data.  By using a Fusion you don't have to wait to reprocess the data if you want to add a new filter criteria.  It'll be instantaneous.

     

    You can extend this into Scenario Modeling.

     

    Imagine you have two columns

    Account_ID, Scenario

     

    and you create 6 account_IDs for Scenario  1

    then you can also add 10 account_IDs for Scenario 2.

     

    Super easy in your analyzer because now you cal filter on the Scenario column to show the data by different Scenarios.

    Jae Wilson
    Check out my 🎥 Domo Training YouTube Channel 👨‍💻

    **Say "Thanks" by clicking the ❤️ in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"
This discussion has been closed.