market share over time with maximum slices

user17569
user17569 Member
in Charting

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.

Comments

  • GrantSmith
    GrantSmith Coach

    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 Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • jaeW_at_Onyx
    jaeW_at_Onyx Coach

    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 ❤️ in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"
This discussion has been closed.

Categories