Beast Mode Calculation Timing Out in Card

user02485
user02485 Member
in Magic ETL

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: 

 

An issue has occurred during processing. We are unable to complete the request at this time.
 
Any help would be appreciated.  Thanks!! 
 

Comments

  • Godiepi
    Godiepi Coach

    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'
  • n8isjack
    n8isjack Contributor

    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"
  • nj-John-mirc
    nj-John-mirc Member

    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.

Categories