Best Of

Re: How to display week end date instead of week start date when aggregrating daily sales data to weekly

You can utilize DAYOFWEEK and some simple math to get the last day of the week.

`Date` + INTERVAL (7 - DAYOFWEEK(`Date`)) DAY

The DAYOFWEEK function returns a number between 1 (Sunday) and 7 (Saturday). Subtracting that from 7 gives us the number of days until the end of the week which we just add that number of days to the exiting `Date` value.

GrantSmith

1

Re: Applying a color rules conditionally based values in columns.

Upvoting, agree and posted about this last week. Glad I'm not the only one. ^_^

https://dojo.domo.com/main/discussion/56737/can-you-paint-with-all-the-colors-of-the-web#latest

G_Grey

2

Re: Combining 2 datasets together

@zuchu I suggest joining your datasets by Quote # rather than appending so that the corresponding quote and sale are on the same row. Then you can create a simple formula like the one below to check whether that quote generated a sale:

case when `Sales.Quote#` is null then 'No' else 'Yes' end

MichelleH

2

Re: REPOST: Dojo Forum for Beta Testing

@mdixonii

You'll need to reach out to Chuck Irwin (@chucki) to get access to the beta features and the Dojo Beta Forum.

GrantSmith

1

Re: REPOST: Dojo Forum for Beta Testing

Hi @Sam1

There actually is a forum for beta features - https://dojo.domo.com/categories/beta-group. You may not have access and might want to reach out to @chucki

GrantSmith

2