Warning: Not all the data is shown | Calendar Card

Hello,
I'm having a problem with the Calendar card. It's supposed to display the count by day using data from the last 6 months. However, I keep getting a warning saying that not all the data is shown.
Does anyone have any ideas on how to handle this? Maybe there's something I'm overlooking in the ETL process that could help filter the data?
Thank you!
Best Answers
-
You may need to pre-aggregate your dataset in an ETL as there's too much data for the chart to display.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1 -
I am having the same issue with a filter card (checkbox selector) and a very small number of possible values (only 8). It seems to be a bug that needs to be fixed, but playing with sorting and group by fields makes a difference. Here are all the options in my list:
If I just put in the list of items, it shows the warning that not all data is shown, although it is.
If I filter out the NULL values, it gives the warning and removes the NULL values.
If I sort it by the channel-platform field as well, even fewer values are displayed.
If I sort it by the COUNT of the channel-platform field, then the error goes away, with all values displayed (although the order might not be what I want in all cases with this method).
If I sort it by the channel-platform field, and group it by the COUNT of the channel-platform field, then the error goes away, with all values displayed (except the NULL values filtered out) and the order is what I want.
So, there are options, but it is not ideal.
1
Answers
-
I've run into this a few times with slicer cards.
One thing you can try (depending on your data) is messing around with the sort. An ascending/descending sort by count or sum of a group sometimes does the trick and doesn't affect the integrity of the card data.
1 -
@MichelleH
This card is powered by a COUNT - but it is a large amount of data as it requires visibility over 6 months:0 -
You may need to pre-aggregate your dataset in an ETL as there's too much data for the chart to display.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1 -
I am having the same issue with a filter card (checkbox selector) and a very small number of possible values (only 8). It seems to be a bug that needs to be fixed, but playing with sorting and group by fields makes a difference. Here are all the options in my list:
If I just put in the list of items, it shows the warning that not all data is shown, although it is.
If I filter out the NULL values, it gives the warning and removes the NULL values.
If I sort it by the channel-platform field as well, even fewer values are displayed.
If I sort it by the COUNT of the channel-platform field, then the error goes away, with all values displayed (although the order might not be what I want in all cases with this method).
If I sort it by the channel-platform field, and group it by the COUNT of the channel-platform field, then the error goes away, with all values displayed (except the NULL values filtered out) and the order is what I want.
So, there are options, but it is not ideal.
1
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
- 657 Datasets
- 115 SQL DataFlows
- 2.2K Magic ETL
- 815 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 81 App Studio
- 45 Variables
- 775 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 81 Workflows
- 23 Code Engine
- 40 AI and Machine Learning
- 20 AI Chat
- 1 AI Playground
- 1 AI Projects and Models
- 18 Jupyter Workspaces
- 410 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 10 Software Integrations
- 144 Manage
- 140 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