market share over time with maximum slices

Reply
Highlighted
Yellow Belt

market share over time with maximum slices

Hello,

 

I'm trying to find a card or a way to build a card that shows me our market share over time and our main competitors market share over time (say top 6 competitors) and will group all the other smaller competitors into an "all other competitor category". The pie chart has a nice feature where you can pick your maximum slices and when I change the product category, the top competitors change and so to does the competitors under "all other". I would like to do something similar, just over time.

Highlighted
Major Red Belt

Hi @user17569 

 

There isn't a chart available to allow you to dynamically switch between competitors displayed (and others absorbed into the Other group) over time. The closest you could get would be a 100% area or stacked bar chart but it wouldn't be able to group competitors into an "Other" group if they're not in the top X. If you absolutely need to group them into an "Other" category you'd need to calculate the rank in an ETL prior to using it in a card and then set the name conditionally based on your ranking.



**Was this post helpful? Click the heart icon**

**Did this solve your problem? Accept it as a solution!**
Highlighted
Black Belt

https://www.youtube.com/watch?v=39VHAQEYHAc&feature=youtu.be

 

when the video finishes uploading, here's how you can accomplish your requirement using dataset views.  in the absence of DSVs, you can aggregate your data using Magic or any other ETL tool. 


Jae Wilson
Check out my Domo Training YouTube Channel

**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"
calculate "market share over time with maximum slices" using the recently updated Dataset Views beta and #windowFunctions in #Domo #Analyzer Original post: h...
Announcements
Domopalooza 2021 Call for Presenters: We want to hear how Domo is revolutionizing the way you do business!

Click here to submit your story.