Skip to content

    • Charting

    Charting

    Card data in dashboard doesn't match card data in analyzer

    Member
    in Charting

    I've been trying to combine two surveys performed at two different times (Qualtrics). I added a column called 'Year' before merging so we could filter by year and compare the two.  This works well in the analyzer, but as soon as I leave it DOMO can't seem to find any 2017 data. I've checked the dataset, it's definitely there and the analyzer seems to corroborate that, but the cards are useless since they won't let me look at the 2017 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

    Best Answer

    • Contributor
      Answer ✓

      The issue MAY be with the date chosen as the date field for the card. I'm also wondering why on your last screenshot it shows 1 day worth of time 10/28/19 to 10/28/19.

       

      Can you provide an example dataset with maybe a few results from each year (minus any sensitive data) so I can test myself to get it to what you want?


      **Make sure to like any users posts that helped you and accept the ones who solved your issue.**

    Answers

    • Contributor
      Answer ✓

      The issue MAY be with the date chosen as the date field for the card. I'm also wondering why on your last screenshot it shows 1 day worth of time 10/28/19 to 10/28/19.

       

      Can you provide an example dataset with maybe a few results from each year (minus any sensitive data) so I can test myself to get it to what you want?


      **Make sure to like any users posts that helped you and accept the ones who solved your issue.**
    • Domo Employee

      I have also noticed that Domo cards will behave strangely when using generic field names like YEAR or WEEK, etc.  You may want to try renaming your field to `Year of Survey` or `Survey Year`

    • Member

      That worked! Slapping in some arbitrary dates for the 2017 data fixed the issue

    This discussion has been closed.

    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