Series counts

All,

I have a data set of accounts that are considering some of our future products.  The account list has a multi-valued field, <product>, and I'd like to show the number of accounts considering each product.  

 

Is there a beast mode that can split this out and count the products or should I just bite the bullet and create something new for the total products list?  You can see the products in the X-axis of the card below.  

 

PROD Emerging Accounts in the program.jpg

Best Answer

  • AS
    AS Coach
    Answer ✓

    Hi Matt

    There's another thread out there about similar multi-value columns and how to split them, but I couldn't find it.  That said, there isn't a single beast mode that can split these values.  You can create a beast mode for each product in the value set (CASE WHEN `product` like '%DRaaS%' THEN...) , and use each of those product beast modes as a series in your card.  Your card would have a bunch of products individually added.  That might be a hassle to maintain, but it might work for you.

    Or, rearchitect the data as you suggest and bring in a fresh dataset that's easier to work with in Domo.

    Aaron
    MajorDomo @ Merit Medical

    **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"

Answers

  • AS
    AS Coach
    Answer ✓

    Hi Matt

    There's another thread out there about similar multi-value columns and how to split them, but I couldn't find it.  That said, there isn't a single beast mode that can split these values.  You can create a beast mode for each product in the value set (CASE WHEN `product` like '%DRaaS%' THEN...) , and use each of those product beast modes as a series in your card.  Your card would have a bunch of products individually added.  That might be a hassle to maintain, but it might work for you.

    Or, rearchitect the data as you suggest and bring in a fresh dataset that's easier to work with in Domo.

    Aaron
    MajorDomo @ Merit Medical

    **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"
This discussion has been closed.