Filtering 2 different data sets with one filter on a dashboard

kav_100
kav_100 Member
in Charting

Hi there, I have 2 different data sets (orders in and orders out) which both contain customer name. I want to be able to filter on both however domo wont recognise them as one column.

Screenshot (8).png
Tagged:

Best Answer

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    Are the columns the same data type? Do you have extra / trailing whitespace in the column names? Domo should recognize them as one column if they're named exactly the same.

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

Answers

  • Jamie
    Jamie Domo Employee

    Hi,

    Could you confirm that there is no trailing or extra white space in the naming of the columns.

    I have seen this cause this problem before, often there is a 'space' character at the end of the column name causing them to be registered as two unique column names.

    You should see the option like the image below when named the same, where you can select which dataset drives the list of filter values / options.

    image.png
  • GrantSmith
    GrantSmith Coach
    Answer ✓

    Are the columns the same data type? Do you have extra / trailing whitespace in the column names? Domo should recognize them as one column if they're named exactly the same.

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

Categories