Skip to content

    • Charting

    Charting

    Filter cards: Search one value, filter on another?

    Member
    in Charting

    We use a client ID system where each client gets a long number string as an identification number. On one of my dashboards, I would like to be able to search a client name, but have the dashboard filter by its corresponding client ID (because we can have multiple records of the same client). Is this a possibility using filter cards - to be able to search one value, but filter by a different value? Thanks!

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Best Answer

    • Coach
      Answer ✓

      Hi @user067324 

       

      Right now you can't filter other cards based on a different field than the one you selected. It would be a great feature enhancement but currently isn't possible based on how Domo is designed.

      **Was this post helpful? Click Agree or Like below**
      **Did this solve your problem? Accept it as a solution!**

    Answers

    • Coach
      Answer ✓

      Hi @user067324 

       

      Right now you can't filter other cards based on a different field than the one you selected. It would be a great feature enhancement but currently isn't possible based on how Domo is designed.

      **Was this post helpful? Click Agree or Like below**
      **Did this solve your problem? Accept it as a solution!**
    • Member

      Thank you @GrantSmith!! 

    • Coach

      Just JOIN the CLIENT_ID and the CLIENT_LegibleText to your dataset ... then build a filter using CLIENT_LegibleText.

       

      Am i not understanding something?

      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"
    • Coach

      My understanding was to filter based on the ID when selecting a client name because there's the possibility of duplicate names for different records. So selecting one column (name) and filtering based on a different column (ID) wasn't possible.

      **Was this post helpful? Click Agree or Like below**
      **Did this solve your problem? Accept it as a solution!**
    • Member

      I have the same question and a bit more of a reasoning. I have a federated mapping dataset (cannot be stored in Domo and thus can't be used in ETL or joined directly) that has item_id, item_name. All of my other cards are from tables that have item_id in them. 

       

      Currently, I can click on item_id in any of the cards, and it will filter both the federated and regular datasets. Right now, clicking on an item_id gives back just the row with the item_name. The problem is that users generally know the item_name they are responsible for and not the item_id. I'd like a user to be able to search item_name in the federated dataset and when they make a selection have that apply a filter to the rest of the dashboard with the corresponding item_id.

    This discussion has been closed.

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Quick Links

    Categories