How to group smaller valued groups into one single OTHER group?

Hi,

 

I have a dataset where some of the groups are in Millions while there are several others which are in 1000s.

So these smaller groups appear really small in the stacked bar visualization.

I want to group these smaller groups into a single OTHERS group.

How do I achiece that in DOMO?

 

Regards,

Prajwal

Best Answer

  • Valiant
    Valiant Coach
    Answer ✓

    In the card analyzer, you could use a BeastMode (Calculated Field) like this for the series of your stacked bar:

    CASE WHEN `Amount` < 100000 THEN 'Others' ELSE `GroupName` END

    Obviously tweak it to fit your own data and threshold, but that should get you the results you're looking for.

     

    Sincerely,

    Valiant

Answers

  • Valiant
    Valiant Coach
    Answer ✓

    In the card analyzer, you could use a BeastMode (Calculated Field) like this for the series of your stacked bar:

    CASE WHEN `Amount` < 100000 THEN 'Others' ELSE `GroupName` END

    Obviously tweak it to fit your own data and threshold, but that should get you the results you're looking for.

     

    Sincerely,

    Valiant

This discussion has been closed.