Best Of
Re: sum the value by week and display first/last day of week instead of week no. on x axis
MichelleH Thanks for the response. I think a beast mode like below is able to solve the problem, along with the options you have suggested.
DATE_ADD(`date_id`, INTERVAL (8- DAYOFWEEK(`date_id`)) DAY)
Re: How to display week end date instead of week start date when aggregrating daily sales data to weekly
Hi @EM
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.
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
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
