Creating groups in Domo Cards

HJShewell

We have a quick question using the summary features of the cards. Is there a way to group data elements without creating additional columns in the datatables?

For example if I have Companies A – F in my data table and want to group them:

(Company A, Company B, Company C) = B2B

(Company D, Company E, Company F) = B2C

For summary purposes in a card. Is there a way to do this? Would I use beast mode to create a formula?

GrantSmith

You can use a case statement in a beast mode to conditionally bucket your values

CASE WHEN `Compsny` IN ('A','B','C') THEN 'B2B'
WHEN `Compsny` IN ('D','E','F') THEN 'B2C'
END

MarkSnodgrass

You could also create groups using Segments. Here's the KB article.

https://domo-support.domo.com/s/article/4403089503383?language=en_US

GrantSmith

You can use a case statement in a beast mode to conditionally bucket your values

CASE WHEN `Compsny` IN ('A','B','C') THEN 'B2B'
WHEN `Compsny` IN ('D','E','F') THEN 'B2C'
END

MarkSnodgrass

You could also create groups using Segments. Here's the KB article.

https://domo-support.domo.com/s/article/4403089503383?language=en_US

DashboardDude

I need some popcorn when I watch @GrantSmith and @MarkSnodgrass going to battle over these points.