General question on data from different datasets on the same card.

I have a card that is on a finished page. There is another metric that I want to add to a specific card that already has data displayed from a single dataset. This new metric is in a completely different different dataset that isn't attached to this page at all. Is there a way to pull in this metric to this card without having to combine that dataset to the one that is feeding the page, that individual card?


Best Answers

  • GrantSmith
    GrantSmith Indiana 🥷
    Answer ✓

    Hi @user048760

    in order for your card to utilize the metric is must be in your dataset. I agree with @Lady_KMac that views are a good option to combine the dataset. Alternatively is it possible for you to add a new card to your page for this metric? That might be a simpler option if you don’t want to combine the dataset together.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • jaeW_at_Onyx
    jaeW_at_Onyx Budapest / Portland, OR 🔴
    Answer ✓

    @user048760 ,

    the short answer is "a card can only be powered by data from ONE dataset". In short, no you cannot create a card that spans two datasets.

    What @Lady and @GrantSmith are suggesting is that you combine your two datasets into one dataset.

    Be careful, instinctively, most people will try to JOIN their data together (in ETL or a Dataset View), but most days of the week that's NOT the way you want to go.

    Instead try to UNION your data such that common columns are aligned.

    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"