Creating a group.

Mirnes · 2023-04-24T15:00:48+00:00

There was an error rendering this rich post.

So I wanted to generate custom groups based on the first word being pulled from a data field.

Example:

System | Application | Client | Problem

Say I wanted to pull whatever system app would be and generate a group for it to display on cards via beast mode.

Also, would the same concept be possible if I combined two work groups(Team A and Team B) into a custom team? Is that possible?

Thanks ahead of time!

Find more posts tagged with

Accepted answers

GrantSmith

Assuming you're wanting a bucket for your applications and not an actual user group here you can utilize a magic ETL to enhance your data.

With a formula tile and a CASE statement you can then create your groupings:

CASE WHEN `Application` like 'STARTSWITHFORGROUP1%' THEN 'Group 1'
WHEN `Application` like 'STARTSWITHFORGROUP2%' THEN 'Group 2'
WHEN `Application` like 'STARTSWITHFORGROUP3%' THEN 'Group 3'
WHEN `Application` like 'STARTSWITHFORGROUP4%' THEN 'Group 4'
ELSE 'OTHER'
END

I do it in a magic ETL as the resulting field isn't dependent on filtering of values and will allow cards to render faster since it's being preprocessed in an ETL and not attempting to process it when a card is rendered.

All comments

Mirnes

Also if the app I'm pulling aren't the specific ones how do I get those labeled as Other?

GrantSmith

Assuming you're wanting a bucket for your applications and not an actual user group here you can utilize a magic ETL to enhance your data.

With a formula tile and a CASE statement you can then create your groupings:

CASE WHEN `Application` like 'STARTSWITHFORGROUP1%' THEN 'Group 1'
WHEN `Application` like 'STARTSWITHFORGROUP2%' THEN 'Group 2'
WHEN `Application` like 'STARTSWITHFORGROUP3%' THEN 'Group 3'
WHEN `Application` like 'STARTSWITHFORGROUP4%' THEN 'Group 4'
ELSE 'OTHER'
END

Mirnes

https://community-forums.domo.com/main/discussion/comment/64685#Comment_64685

Thanks for the speedy feedback! I will give this a shot.

Mirnes

So I'm running into a bit of a snag and it may be due to my wrong wording, let me try again. Say if I wanted to just do the Beast Mode element and pull just what's in the title for example:

All this info is in the Title separated by a | if I wanted to pull the System name from the title and then group it along with others that come in with the same format but create a group for them to be displayed on the card.

System | Application | Client | Problem

Just need a way to take that split after and create a specific group for them, it's no more than 6 and everything else can be other.