Two Data Sets, Differently Named Fields - Unable to create paired filter for dashboard cards

Domo community - need a hand on this one.

I have two datasets:

a) Client records (note: uses client UNID of "SGId")

b) Events related to the Clients (note: uses client UNID of "ShowGroupID")

Both sets have a common UNID that identifies the clients. One is named SGId and the other ShowGroupID as noted above.

For the B data set, I set up a beast mode calc to rename the field to match (case sensitive) the field for A data set (screenshot below).

I then USED that Beast mode field in the card table on the dashboard (additional screenshot below).

I then joined/paired the filter on the Dashboard (additional screenshot below).

When I then use the filter on the dashboard for a specific Client SGId, I'm unable to find a known client SGId that exists in Dataset A but does NOT exist in Dataset B. This client did not have any events.

Question: How do I resolve this paired filter such that it will allow filtering on all SGId's regardless of whether the client record has no events? I would expect to be able to filter on such a client record and simply have the first table populate with a single row representing that client and then not display anything in the second card.

Thoughts on how to resolve this?

Thank you!!!

Screenshot of Beast Mode Calc Renaming Field in B Dataset

Using the new beast mode field in table configuration:

Paired Filter Screenshot

Answers

  • You should be able to filter on the beast mode if you're saved the beast mode to the dataset. Is it saved to the card only or to the dataset?

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • Grant - thanks for jumping in.

    Yes, it has been saved to the dataset (screenshot below).

    One thing I do notice is that when I go into the Dashboard and hit the "+" Filter to get the data field selection, when I scroll down to the SGId (client UNID), it has the arrow which is the indicates that Domo sees a matching field across both Datasets. When I click on it, the boxes are never checked for the pairing (despite the fact that I've already paired, saved, then saved the actual filter widget on the screen. Not sure if that means anything (second screenshot).

    Lastly, given that the SGId that is not available for selection in the filter is also a Company that has NO events, could that be related to the issuer?