Best Of

When you want to exclude something that contains a certain string, you need to use NOT LIKE. So your beast mode would look like this:

case when `EVENT_NAME` like '%Add-To-Cart%' and `EVENT_PARAMS_PAGE_LOCATION` not like '%/shop/%' then 'Add to Cart from XXX' end

CASE WHEN COALESCE(TRIM(`field`), '') = '' THEN 'Blank' ELSE 'Not Blank' END

COALESCE will return the first non-null value it finds, used in this case it's saying if the field is null return an empty string. I've wrapped the field in a trim to remove any leading or trailing whitespaces in case someone has a value of all spaces to ignore. Then it is compared to an empty string after it's been converted.

A more verbose way would be:

CASE WHEN `field` IS NULL or TRIM(`field`) = '' THEN 'Blank' ELSE 'Not Blank' END

NULL is a very specific value. The only way to check for null is to use IS NULL or a COALESCE / IFNULL function to default it to a specific value and compare that value.

Most functions you use on NULL or comparison will result in a NULL value back because NULL represents the absence of data.

The period over period chart types are pretty limited, which is why people often create other ways to compare periods. Here is a link to a video I did showing another way just by creating a few beast mode fields:

https://youtu.be/mDwSQGAjIrs

@GrantSmith has also created this post that walks you through creating a date dimension dataset to create the comparison cards.

https://dojo.domo.com/main/discussion/53481/a-more-flexible-way-to-do-period-over-period-comparisons#latest

Hope this helps.

@Musetti, Since you're looking to make a percentage, try removing the 100* from your beast mode and then change the format of your value to be a percentage.

The image can only be a certain size, and Domo will automatically crop the image to fit. It doesn't appear that there's an option for gradients, so that may be something to post on the idea exchange.

To set the background image for a Page,

1. On the Page you want to change the background color of, select Edit Dashboard in the 

 menu in the top right corner of the Page.

1. In the Options menu at the top of the screen, select Change background.
2. (Conditional) If Color Fill is selected in the menu at the top of the dialog, choose Image Fill.
3. Click Choose Image.
4. Locate and select your image on your machine.
5. (Optional) To change the default background color (which is only used before the image has loaded on the Page), click Change then choose the new color from the palette (or enter a hexadecimal code in the field at the bottom of the palette).
6. (Optional) To change the default text color used on the Page, select the new color in the menu under "Default text color." 
7. Currently only black and white are available as text colors.

If you want to change your background image, click Choose New Image at the bottom of the dialog then locate and select the new image on your machine.

https://domohelp.domo.com/hc/en-us/articles/360043428433-Creating-Domo-Stories#8.