Using the Limit function for a beastmode

user09167
user09167
in Dataflows

Hello,

I'm trying a little work around to get a top 10 list for a domo card based on revenue. To do this, I was planning on organizing each company by most revenue and doing a beast mode to limit the companies by 10. I'm not sure if this is possible, but I see that "limit" is a highlighted function for the beastmode - however, I can't seem to get the syntax right. Is there a way to create a beastmode where the "limit" function would give me only a few results? Thank you!

Comments

  • mpoudel
    mpoudel

    @user09167,

     

    I dont think limit is supported in the beast mode. The other option is to sort the total revenue by descending order and set the data table row to 10.  This will only give you top 10 companies by revenue. 

     

    Let me know if this worked!

     

    data row limit.PNG

Categories