Best Of

Minor edit to @GrantSmith 's suggestion, to re-format the percentage:

CONCAT(SUM(`delivers`), ' delivers ', ROUND((SUM(`delivers`)/SUM(`total`))*100,0), '% delivery rate')

@WillClark My company has a card that does something similar with YTD, MTD, last week, etc. You'll need to write a beast mode for each time period you want to calculate, and use the current date to determine what gets included. A YTD beast mode would look something like this:

case when YEAR('date') = YEAR((date(CONVERT_TZ( now() , 'GMT','your_timezone'))) then 'Amount' end

Then when you add your column just set it to the desired aggregation. Then you'll just go through use the available date functions in Domo to do the comparisons with the current date for the rest of your time periods:

• MTD: mm/yyyy of 'date' = mm/yyyy of current date
• This week: ww/yyyy of 'date' = ww/yyyy of current date
• Last week: ww/yyyy of 'date' + 1 week = ww/yyyy of current date

@Silambarasan_3008 if you haven't watched this walkthrough on building a dashboard, this is helpful. It's probably the nicest dashboard I have seen.

https://www.domo.com/help-center/videos/watch/yXFS2uvD5Es/cat/PLc_JazWEwlVqiRoWcbD5My1Bw0_IpMX8z

Thanks for sharing that @MichelleH

If you're wanting to add an image as a background to the page you can do that but editing the page, selecting the options menu in the upper right, select change background, change Color fill to Image fill and then select the image you wish to use as your page background.