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
- 300 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 738 Beast Mode
- 56 App Studio
- 40 Variables
- 685 Automate
- 176 Apps
- 452 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 123 Manage
- 120 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