Single value card displays blank if specific date is selected in date range with existing data
Howdy,
I'm still pretty new to Domo so bear with me. I created a single value card to display a sum of completed tasks for a specific shift and office (2 filters) for a productivity dash. The issue I am having is that the card displays blank if a specific date (feb 15) is selected within a date range under my 2nd shift filter. The card will display the correct data if previous month, current quarter/year are selected as well as if I change the shift to another shift but not in a date range if feb 15 is within the range. I’ve checked all of my date data as well as the shift data and everything seems correct. Any clue on what I could be doing wrong here?
Answers
-
are you applying this date filter, under the filters tab? If so I would recommend remove that filter and then select the specific date from domo provided date selector.
0 -
I am using the domo provided date selector to filter the dates. The filters I am using under the filters tab are text filters and not date filters.
0 -
Hi @Slapo
Have you tried viewing your data as a table in analyzer and applying filters to see if your rows still show up? What happens when you lift some of your filters?
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1 -
Hi @GrantSmith
When I change it over to a table it shows the correct data with both of the filters on. If I grab all of the data and perform the same calculation in excel as I did in the beast mode I created it gives me the correct number (with the filters on.)
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 747 Beast Mode
- 60 App Studio
- 41 Variables
- 687 Automate
- 177 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 397 Distribute
- 114 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 126 Manage
- 123 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive