Skip to content

    • Connectors

    Connectors

    Switch Dataset Dynamically

    Member
    in Connectors

    Can we switch dataset (not database) dynamically while running report in Domo ? 

    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 ✓

      You can't do this within Vanilla Domo itself however Domo Embed does allow for you to switch datasets with Dataset Switching. You can read more on it here:

      DOMO Developer

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

    Answers

    • Coach

      @vibhusharma2210 How specifically are you running the report? Are you creating a card, running a dataflow, or something else?

    • Coach

      You could append two datasets together and switch back and forth with a filter or a variable - but I agree with @MichelleH, more information is needed.

    • Member

      Hi @MichelleH , just a report or dashboard run (not card) , you can think it like templated report where we can switch input Dataset with exact same UI for multiple versions of dataset

    • Coach
      Answer ✓

      You can't do this within Vanilla Domo itself however Domo Embed does allow for you to switch datasets with Dataset Switching. You can read more on it here:

      DOMO Developer

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

      HI @GrantSmith , ok

    • Coach
      vibhusharma2210

      Could you just copy the card and then switch the dataset? What's the dynamic need?

    • Member
      edited September 2023

      Hi @trafalger , as per my understanding card in Domo means chart however the problem statement I mentioned is with respect to report or dashboard which can have multiple charts or cards

      The dynamic need is with respect to selection of datasets while running report or dashboard because there are multiple datasets created purposely for different time intervals example 6 months, more than 6 months to 1 year etc. All datasets have same physical structure and instead of creating multiple copies of same report for each dataset, I need to create one single report with mechanism to point to different dataset while running that report

    • Member

      This functionality is useful for web analytics where you might have several report suites broken out with different filtering but the same KPIs.

      For functionality reference, its available in other platforms - Data Studio has a Data Control that lets the dashboard user select the dataset that powers the visualizations.

      I don't have too frequent a need for it, but it has come up amongst our Analysts.

      Maybe this goes in the Ideas Exchange?

    • Coach

      Ya I think just append them and then use either a filter or a variable. @vibhusharma2210 @tracy_gamlin

    • Member

      We have a similar requirement where we are embedding 1 dashboard. The requirement is to be able to switch between datasets depending on the combination of drop down options the user has selected from the main website .

      The server side should then be able to send these selections down to a mapped table which will return the dataset that the dashboard should redirect to.

      We can't see how this should be passed to the code found in this article https://developer.domo.com/portal/j83p65ecrjtr1-dataset-switching.

    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

    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