beast mode using rank function

chetan_cricut
chetan_cricut Member
in Beast Mode

I have created a beast mode using rank() and using it to filter a chart. It is able to process the desired chart. But while saving the card domo says "There was a problem saving your card. If the problem persists, contact the Domo support team."

RANK() OVER (PARTITION BY first_day_of_month ORDER BY COUNT(DISTINCT user_id) DESC)

However, it used to work earlier.

error msg.PNG
Tagged:

Best Answer

  • MichelleH
    MichelleH Coach
    Answer ✓

    @chetan_cricut The error is likely because of the COUNT(DISTINCT ) in your order by clause. I've often seen beast mode errors when using aggregates inside of other aggregate/window functions. Are you able to hard-code that count using ETL?

Answers

  • MichelleH
    MichelleH Coach
    Answer ✓

    @chetan_cricut The error is likely because of the COUNT(DISTINCT ) in your order by clause. I've often seen beast mode errors when using aggregates inside of other aggregate/window functions. Are you able to hard-code that count using ETL?

Categories