Applying the data table row limit to the summary number function
I would like to apply the data table row limit to the summary number function as an option. Basically showing only the limited rows measures sum as one of the summary numbers. For example, we sorted (descending / ascending  either or) one of the measures and then we limited the data table a limit was set to 50 rows to display on the chart. We want that sum of the 50 rows of data to show as the Summary number and not the entire data sets measure as the summary number. This may also be done by a rank funciton in beast mode but there is no rank f function also.
Thanks!
Comments

Additional notes with Domo team member:
Hello Victor,
I am not sure how you are limiting the number of rows in the data table, so I can’t comment on why the summary number isn’t changing. I do know that if you use filters on the page, the summary number will change according to the filter set. Even though we don’t have a rank function in beast mode, there is a rank and window function available in Magic ETL. Perhaps that could help?
Tasleema  Sr Product Manager
Tasleema,Thank you for your response. We are limiting the data table rows in analyzer. Limit 50 rows on a calculated field. The calculated field is then sorted in descending order. We want to see the top 50 rows in that order. Since this is a calculated the row the top 50 will change daily because it is calculated / derived. So the filter on the page will not filter properly because it is a moving target to get the top 50. A greater than value or set 50 named values does not work either, the moving target. Hence I mentioned the ranking to identify the 50.We can look at Magic ETL but if a power user wants to do this for reporting it would really help having the limit row option in relation to the Summary number function. Or having a ranking also.Thanks again,Vic0
Categories
 10.7K All Categories
 1 APAC User Group
 12 Welcome
 36 Domo News
 9.6K Using Domo
 1.9K Dataflows
 2.4K Card Building
 2.2K Ideas Exchange
 1.2K Connectors
 339 Workbench
 252 Domo Best Practices
 11 Domo Certification
 461 Domo Developer
 47 Domo Everywhere
 101 Apps
 705 New to Domo
 84 Dojo
 Domopalooza
 1.1K 日本支部
 4 道場日本支部へようこそ
 23 お知らせ
 63 Kowaza
 296 仲間に相談
 649 ひらめき共有