How to set Maximum Items on a bar chart for the series data?
I have a vertical stacked bar chart with date (month/day) on the x-axis and the number of API calls per individual user as the series. Because I have a large number of users with very few API calls and a few users with a large number for each of them, I want the stack bar segments to just reflect the top 10 individual users with highest API call volume and then lump all others outside of the top 10 into an 'Other' bucket.
The Maximum Items setting in General chart properties does not do want I want. It is instead limiting the chart to 10 daily bars with an 11th bar for all other days.
How to I get Top 10 users with highest API call volumes and then all other users as a single segment of the stacked bar?
Answers
-
One way to accomplish this would be to use the rank and window tile in Magic ETL and get your totals and rank them in order. You can then use the rank to show your top 10 and then use a beast mode (or formula tile in Magic ETL) to assign anyone above 10 to the other group. Use this new field as your series.
You can also use window functions in beast modes, but you need to ask your CSM to turn it on and then write a rank and sum window function to do what you would do in the ETL.
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.0 -
I agree with @MarkSnodgrass - You'd need to aggregate / rank the data before pulling it into your card to filter on the rank.
Window functions are available in a beast mode however you can't filter based on an aggregate function in analyzer (unless you have a very alpha option to filter on aggregates but I don't recommend it as it's can have unexpected results and doesn't always work as expected)
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0
Categories
- 10.6K 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
- 100 Apps
- 703 New to Domo
- 84 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 22 お知らせ
- 63 Kowaza
- 296 仲間に相談
- 649 ひらめき共有