Federated

Federated

All cards using federated data sets and using filters are broken

I woke up this morning and all of my embedded dashboards were broken. After some analysis it looks like any card on a federated dataset that is also using a filter is not rendering. These are embedded cards using programmatic filters below and none of them are currently rendering. They were all rendering properly yesterday.

When I log into Domo directly, most of these cards are rendering, unless there is any filter applied to the card. (Don't worry, this is demo data)

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

Answers

  • Domo Product Manager

    @DatAIBrain - Have you logged a case with Domo Support for this yet? This sounds like something that Domo Engineering may need to look at.

  • Yes I did submit a support ticket as well.

  • It looks like the issue only occurs when the filter is a measure. I can cast a measure as a string and then it seems to work.

  • Contributor

    @DatAIBrain here is a screen recording of exactly what you are talking about.

    LoomSite faviconAll cards using federated data sets and using filters are broken — Domo Community Forum - 1 July 2024



    The issue is that the data that is being filtered is being filtered on a column that doesn't exist or all of the data has been filtered in such a way that no data exists when the iframe is recalled.

    ** Was this post helpful? Click 💡/💖/👍/😊 below. **
    ** If it solved your problem. Accept it as a solution! ✔️ **

    Or do you need more help? https://calendly.com/matthew-kastner/15-minute-chat
    Did I help you out? Feedback is priceless and will help me more than you know.Write a review!

  • I wish that was the case. The filters were working fine one day, and the next day none of them were working. When I cast the measure column as a string, the filters work so it is not a case of filtering out all of the data.

    In your example, are you using federated data sets? This issue only seems to be happening on federated data sets.

  • Domo Product Manager

    @DatAIBrain can you share the support case number? I'll look into this from my end.

  • Contributor

    @DatAIBrain the example I showed is not federated, but I just tried with a federated dataset (I would have shown it but I only have production data), but had no issues embedding it.

    Two follow-up questions:
    1.) What is the federated source?
    2.) What is the filter that you are trying to apply?

    ** Was this post helpful? Click 💡/💖/👍/😊 below. **
    ** If it solved your problem. Accept it as a solution! ✔️ **

    Or do you need more help? https://calendly.com/matthew-kastner/15-minute-chat
    Did I help you out? Feedback is priceless and will help me more than you know.Write a review!

  • Yeah thanks! Here is the case number: 05880995

  • Thanks for digging into this @MattTheGuru!

    1. The federated source is BigQuery.

    2. I am trying to filter on an organization id or a facility id. In my instance, I am unable to filter on any numeric column though.

  • Contributor

    @DatAIBrain I think the issue is just the name of the column that is attempting to be filtered against.

    Here is a federated dataset from Google Sheets (I know it's not BigQuery, but I can get the same error to replicate that you are seeing).

    Loom: Site faviconDomo - 2 July 2024

    ** Was this post helpful? Click 💡/💖/👍/😊 below. **
    ** If it solved your problem. Accept it as a solution! ✔️ **

    Or do you need more help? https://calendly.com/matthew-kastner/15-minute-chat
    Did I help you out? Feedback is priceless and will help me more than you know.Write a review!

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