Best Of

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.

Thanks to you both. These didn't get me where I needed to be HOWEVER they did provide enough info/context to figure it out. As it turns out it was even simpler and only required the DAYOFMONTH ('datecolumn'). Then I setup the beast mode as a range filter and it's perfect.

they only thing out of the box that would handle this correctly is doing a year to date selection. What I recommend is to configure your own date offset dataset to do a more apples to apples comparison. I’ve written up on this method before https://dojo.domo.com/main/discussion/53481/a-more-flexible-way-to-do-period-over-period-comparisons#latest

You can actually do this quite easily with beast mode to ensure that you are only showing the same amount in each month.

(CASE when DAYOFMONTH(`date`) <= DAYOFMONTH(CURRENT_DATE()) THEN 'Include' ELSE 'Exclude' END)

You can then drag this beast mode into your filters and filter on Include. You can let your date range be whatever time period you want, and this beast mode will filter out dates that are past whatever day in the month it is for previous months.

Hope this helps.

@Jones01 Do you have this box checked in your card? I believe the date must be visible in order to be affected by the global date filter.

@Jones01 You can customize your summary number by wrapping it in a CONCAT() function like the examples in this article: https://domohelp.domo.com/hc/en-us/articles/360043430093-Sample-Beast-Mode-Calculations-Card-Element-Transforms#4.

Here is an example of what that could look like:

CONCAT(DATE_FORMAT(MIN(`Date`),'%m/%d/%y'),' - ',DATE_FORMAT(MAX(`Date`),'%m/%d/%y'))

@Jones01

I'm not sure what chart type you are using, but I believe I was able to do this with three beastmodes. One to get the name of the day and another to capture the hour from your datetime field.

HOUR:

HOUR(`DateField`)

Week Day:

DAYNAME(`DateField`)

Avg Total Count:

AVG(SUM(`Count`)) FIXED (BY day(`DateField`))

You can then see the average total for any day of the week. You can also filter to only include certain hours or only values between certain dates.

@RanjitR - you could always try the new FIXED function in beastmodes now.

AVG(SUM(`CY_TRANSACTION`) / COUNT(DISTINCT `STORE_ID`)) FIXED (BY `YEAR_PERIOD_WEEK`)