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
- 310 Workbench
- 7 Cloud Amplifier
- 9 Federated
- 3K Transform
- 113 SQL DataFlows
- 650 Datasets
- 2.2K Magic ETL
- 4K Visualize
- 2.5K Charting
- 792 Beast Mode
- 78 App Studio
- 44 Variables
- 754 Automate
- 187 Apps
- 479 APIs & Domo Developer
- 71 Workflows
- 17 DomoAI
- 40 Predict
- 17 Jupyter Workspaces
- 23 R & Python Tiles
- 407 Distribute
- 118 Domo Everywhere
- 279 Scheduled Reports
- 10 Software Integrations
- 141 Manage
- 137 Governance & Security
- 8 Domo Community Gallery
- 47 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 113 Community Announcements
- 4.8K Archive