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
- 11K All Categories
- 5 Private Company Board
- 2 APAC User Group
- 12 Welcome
- 42 Domo News
- 9.9K Using Domo
- 2K Dataflows
- 2.5K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 349 Workbench
- 266 Domo Best Practices
- 11 Domo Certification
- 474 Domo Developer
- 51 Domo Everywhere
- 110 Apps
- 725 New to Domo
- 85 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 28 お知らせ
- 65 Kowaza
- 301 仲間に相談
- 662 ひらめき共有