Rank Beast Mode with Issue

Options
CarH
CarH Member
edited July 7 in Calculations & Variables (Beast Mode)

I´m using this formula to make a RANK

rank () over (order by sum(NET_SALES_CY)desc)

The table show the rank correct.

But as soon as I try to filter my top 10 customers on table using the rank, I receive this error message An issue has occurred during processing. We are unable to complete the request at this time.

what am I doing wrong?

Best Answer

  • ArborRose
    ArborRose Coach
    Answer ✓

    A few possibilities…

    • You may need to use the WHERE clause to select only customers with rank less then equal to 10.
    • Make sure your data doesn't have any issues or missing values that could cause an error.
    • Verify your sum(NET_SALES_CY) aggregation is functioning as expected.

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

Answers

  • MarkSnodgrass
    MarkSnodgrass Coach

    Yours looks like mine and mine works to put in the filter. Do you have a space before desc? It is hard to tell.

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.
  • ArborRose
    ArborRose Coach
    Answer ✓

    A few possibilities…

    • You may need to use the WHERE clause to select only customers with rank less then equal to 10.
    • Make sure your data doesn't have any issues or missing values that could cause an error.
    • Verify your sum(NET_SALES_CY) aggregation is functioning as expected.

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

  • GrantSmith
    GrantSmith Coach

    Are you aggregating anywhere else within your card? If so Domo doesn't know how to handle the results of your window function as it returns a single result for each row.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • DataMaven
    DataMaven Coach

    It's the double sum conundrum. lol

    DataMaven
    Breaking Down Silos - Building Bridges
    **Say "Thanks" by clicking a reaction in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"

Categories