Beast Mode Calculation Timing Out in Card
Have you guys had any problems with a Card Timing out using a Beast Mode calculation.
I wonder if my dataset is too large (338M rows). I'm doing a Count Distinct on a CustomerID. The card spins and then generates an error message:
Comments
-
Hi , can you post the actual beastmode formula you are using as well as what type of chart it is and the fields you are including and time period selected. a screenshot would help , of course you can hide numbers and sensitive data before posting it.
Domo Arigato!
**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'0 -
I know Domo has a time limit for calculations. If the query can't run quickly they kill it to keep all other cards/dashboards loading.
COUNT(DISTINCT) is probably the worst performant aggregate function. It is just so awesome. I can imagine that if anything was going to kill a card it would be COUNT(DISTINCT).
Sometimes I've had to restructure my data to only have one row for each thing I am counting to avoid the need for the distinct. Then when you drill in I have the drill paths using a different dataset that still has all the granular rows of data. So the TOP card is simple and performant, and the drill cards usually are filtered by something you clicked on the top card and so they still work.
**Say "Thanks" by clicking the "heart" in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0 -
I'm getting the same error after I apply the beastmode to my card
An issue has occurred during processing. We are unable to complete the request at this time.
0
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