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
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 744 Beast Mode
- 58 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 395 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 6 Software Integrations
- 125 Manage
- 122 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive