Single Value Card Limited to 25,000?
I have a single value card that shows the total tickets we have in our IT Help desk tool which is basically just a count of all the ID's for each ticket, and each row is unique to one specific ticket so the total rows is the same as a count of all of the ID's.
I noticed that the card now has a caution symbol on it and says not all data is shown and is stuck at a nice round number of 25,000. The card has no drilldowns so I'm a little surprised that it's being limited (I understand why you would limit a table card of 25,0000 results)
**Make sure to like any users posts that helped you and accept the ones who solved your issue.**
Best Answer
-
Hi @guitarhero23, it looks like there is a bug in Domo. I found a way around it where it will abbreviate the value if that is ok.
You need to create a beast mode that counts the records... COUNT(field). Use that in both the label name and value name. You could also use a COUNT(DISTINCT field) if needed.
That will give you an abbreviated number. I tested it with a 34M row dataset, so I know it will at least work up to that number. Start opening more tickets ?
2
Answers
-
Hi @guitarhero23, it looks like there is a bug in Domo. I found a way around it where it will abbreviate the value if that is ok.
You need to create a beast mode that counts the records... COUNT(field). Use that in both the label name and value name. You could also use a COUNT(DISTINCT field) if needed.
That will give you an abbreviated number. I tested it with a 34M row dataset, so I know it will at least work up to that number. Start opening more tickets ?
2 -
Odd, when I used it in both the name and value field it showed "1", but when I removed it from the name field and left that blank it displayed the correct number (though it refuses to show a comma even though I told it to). Thanks.
**Make sure to like any users posts that helped you and accept the ones who solved your issue.**0 -
How did you get the card to show you the full 25,000. Normally the cards just show 25k
1
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 296 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive