Beast Mode Calculation Timing Out in Card

Reply
White Belt

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: 

 

Major Red Belt

Re: Beast Mode Calculation Timing Out in Card

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'
Major Blue Belt

Re: Beast Mode Calculation Timing Out in Card

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"
Announcements
Looking for the latest Community solutions? Please visit our accepted solutions board here!