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

Find more posts tagged with

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

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