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

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
Best 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.**1
Answers
-
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.**1 -
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`
0 -
That worked! Slapping in some arbitrary dates for the 2017 data fixed the issue
0
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 656 Datasets
- 115 SQL DataFlows
- 2.2K Magic ETL
- 811 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 80 App Studio
- 45 Variables
- 771 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 77 Workflows
- 23 Code Engine
- 36 AI and Machine Learning
- 19 AI Chat
- AI Playground
- AI Projects and Models
- 17 Jupyter Workspaces
- 410 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 10 Software Integrations
- 142 Manage
- 138 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive