Best Of

Re: Handle NULL in Magic

If the NULL values exist in the input dataset, you can configure that fields settings in the "Input DataSet" tile.

Not as easy as a tile to handle it for all fields at once but it is easier than a formula tile.

TheLookout

3

Re: Help with Beastmode on Count with Condition

Hi @user077529

You can use a CASE statement to conditionally count values in a beast mode. You're close but yours is only counting everything if isRegistered is true. You want something like this:

Registered count

COUNT(CASE WHEN `isRegistered` = 'True' THEN `OrderNo` END)

Non-Registered.

COUNT(CASE WHEN `isRegistered` = 'False' THEN `OrderNo` END)

GrantSmith

1

Re: How to delete data of a domo dataset

This was an amazing find.
I had duplicate data appended.

I was going to blow away the entire dataset and spend days doing another incremental upload.

This was such a gift.

Sambo_Servicer

2

Re: Identifying all datasets connected to a credentials account

I had to set the Account_ID to floating decimal in the datasets configuration so the data type would match, but that was it.

MarkSnodgrass

2

Re: Group by Percentage

@user17774 Glad that worked for you. If you can accept any answers that helped you, that will help others in the community.

MarkSnodgrass

2

Re: Can you find a Beast mode by it's function?

Hi @IanMaddrell

You can pull in the Beast Mode metadata using the Domo Governance Datasets Connector and select Beast Mode from the report list. It'll have all the beast modes and the formulas used for you to do a filter on.

GrantSmith

1

Re: Group by Percentage

I would suggest adding another group by that aggregates by body part and then join it back to your initial group by. You can then use the formula tile to calculate the percentage. If you are unaware, you can have multiple lines go out from any tile so that you can perform different operations such as this and then join them back together.