Top 10 totals are wrong

Reply
Yellow Belt

Top 10 totals are wrong

If you have a table with a restricted number of rows (e.g. a top 10) - then there is no way of showing a Total row that includes just that subset of data.


Accepted Solutions
Black Belt

Re: Top 10 totals are wrong

@simontarry76  It would definitely be more complicated, but you might still be able to pull it off with Rank and Window. Depending on how your data looks, it may be more worthwhile to find another way to get the needed information to your users.

 

Is there a particular business question that you want users to be able to answer with this card? Does having the totals for the top 10 results only help them answer that question? If so, and the dynamic filtering is a must, there may be another way to get the users the data they need.

 

All that said, it could still definitely be worth it to submit some feedback or add your use case to someone else's feedback in the Dojo Ideas Exchange http://dojo.domo.com/t5/Ideas-Exchange-suggest-and-vote/idb-p/Ideas. You can search existing ideas and then vote for it if it matches what you have in mind. If you cannot find it, please create a new Idea which can then be voted on by your fellow Dojo members by clicking the white arrow next to the idea.


Thanks,
Jake
**Say "Thanks" by clicking the "heart" in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"

View solution in original post


All Replies
Black Belt

Re: Top 10 totals are wrong

@simontarry76 That is correct. The "Total Row" and "Subtotal Rows" calculate based on the full DataSet, as the row limit is not a filter, it's just a visual change.

 

If you want to be able to look at the totals for just the top ten, ignoring values that fall below that, I would suggest running the DataSet through an ETL and using a Rank and Window tile to do the calculation before it hits your DataSet. This way you can filter based on the rank and your totals will be calculated off of that. Here's the KB article on how they work: https://knowledge.domo.com/Prepare/Magic_Transforms/ETL_DataFlows/03ETL_Actions%3A_Rank_and_Window


Thanks,
Jake
**Say "Thanks" by clicking the "heart" in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"
Yellow Belt

Re: Top 10 totals are wrong

Thanks Jake. I should have mentioned that the page we're doing this on has lots of filters. Users expect to be able to filter the page by a few different metrics and the totals update automatically. So rank and window doesn't help us there. 

Black Belt

Re: Top 10 totals are wrong

@simontarry76  It would definitely be more complicated, but you might still be able to pull it off with Rank and Window. Depending on how your data looks, it may be more worthwhile to find another way to get the needed information to your users.

 

Is there a particular business question that you want users to be able to answer with this card? Does having the totals for the top 10 results only help them answer that question? If so, and the dynamic filtering is a must, there may be another way to get the users the data they need.

 

All that said, it could still definitely be worth it to submit some feedback or add your use case to someone else's feedback in the Dojo Ideas Exchange http://dojo.domo.com/t5/Ideas-Exchange-suggest-and-vote/idb-p/Ideas. You can search existing ideas and then vote for it if it matches what you have in mind. If you cannot find it, please create a new Idea which can then be voted on by your fellow Dojo members by clicking the white arrow next to the idea.


Thanks,
Jake
**Say "Thanks" by clicking the "heart" in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"

View solution in original post

Announcements
Check out these great solution videos! The new iSolveditWithDomoboard is live, share yours and earn higher rankings in Dojo click here!