Best Of
Re: showing record with max date
There may be other ways to do this, but I would start by ranking the dates and then filtering the data to only include the max date for each ID.
Re: Participate in a 15 minute survey and receive a complimentary report ($895 Value)!
DONE
amehdad
Re: How to ensure data for each month gets displayed in one row in this table chart instead of2rows
Hi @Abhijith, before the beast mode, in your ETL, add in a 'Group By' tile to group SUM(`Total Charge`) by MonthYear.
amehdad
Re: scheduled Reports - Update email addresses from Dataset?
The API appears to be {}/api/content/v1/reportschedules
It does not appear there is any reference to that API on the datacrew site but I will keep investigating to see if a call to the API is something I can build.
I have also asked my admin to investigate the cost of the Domo Campaigns app.
Thankyou very much for your help @MarkSnodgrass !
I would very much appreciate any more help anyone can offer
Re: How do I turn off an alert on data loads?
In the dataset view there is an icon with three dots and under there is an option for Notifications. You can turn them off from there:
mhouston
Re: Remove weekend days from calculations
If you wanted to do it in a beast mode, it is quite a bit more involved, but you could do this:
CASE WHEN `Start Date` = `End Date` THEN 0 ELSE DATEDIFF( CASE WHEN DAYOFWEEK(`End Date`) = 7 THEN SUBDATE(`End Date`, INTERVAL 1 DAY) WHEN DAYOFWEEK(`End Date`) = 1 THEN SUBDATE(`End Date`, INTERVAL 2 DAY) ELSE `End Date` END , CASE WHEN DAYOFWEEK(`Start Date`) = 1 THEN ADDDATE(`Start Date`,INTERVAL 1 DAY) WHEN DAYOFWEEK(`Start Date`) = 7 THEN ADDDATE(`Start Date`,INTERVAL 2 DAY) ELSE `Start Date` END ) - ((CASE WHEN WEEK(CASE WHEN DAYOFWEEK(`Start Date`) = 1 THEN ADDDATE(`Start Date`,INTERVAL 1 DAY) WHEN DAYOFWEEK(`Start Date`) = 7 THEN ADDDATE(`Start Date`,INTERVAL 2 DAY) ELSE `Start Date` END) = WEEK(CASE WHEN DAYOFWEEK(`End Date`) = 7 THEN SUBDATE(`End Date`, INTERVAL 1 DAY) WHEN DAYOFWEEK(`End Date`) = 1 THEN SUBDATE(`End Date`, INTERVAL 2 DAY) ELSE `End Date` END) THEN 0 ELSE WEEK(CASE WHEN DAYOFWEEK(`End Date`) = 7 THEN SUBDATE(`End Date`, INTERVAL 1 DAY) WHEN DAYOFWEEK(`End Date`) = 1 THEN SUBDATE(`End Date`, INTERVAL 2 DAY) ELSE `End Date` END) END - CASE WHEN WEEK(CASE WHEN DAYOFWEEK(`Start Date`) = 1 THEN ADDDATE(`Start Date`,INTERVAL 1 DAY) WHEN DAYOFWEEK(`Start Date`) = 7 THEN ADDDATE(`Start Date`,INTERVAL 2 DAY) ELSE `Start Date` END) = WEEK(CASE WHEN DAYOFWEEK(`End Date`) = 7 THEN SUBDATE(`End Date`, INTERVAL 1 DAY) WHEN DAYOFWEEK(`End Date`) = 1 THEN SUBDATE(`End Date`, INTERVAL 2 DAY) ELSE `End Date` END) THEN 0 ELSE WEEK(CASE WHEN DAYOFWEEK(`Start Date`) = 1 THEN ADDDATE(`Start Date`,INTERVAL 1 DAY) WHEN DAYOFWEEK(`Start Date`) = 7 THEN ADDDATE(`Start Date`,INTERVAL 2 DAY) ELSE `Start Date` END) END) * 2) END
For a detailed breakdown, you can refer to this article:
https://domohelp.domo.com/hc/en-us/articles/360043428153-Date-Difference-for-Business-Days
Hope all of this helps.
Re: Right string operation to remove the timestamp
That looks correct. Are you looking at the newly named column for your result as it won't affect the original column.
A better option might be to use the Formula tile and use the date function to extract the date from your field. It would look like this:
DATE(`drentlastchanged`)
This will not only produce just the date, but will make it a date column that will be more usable at the card level.
Re: Summary Number - "show more options" drop down is not displaying
Ahh..I see now and got it working. Thank you for your help Mark!
gbrown
Re: Domo Buzz notifications
You can also use @all to mention everyone in the conversation.
mhouston
Re: Convert string to number
you can't really enforce data types using add Formula.
well no that's a lie, you could use the CAST() function. If it were me though, I would use the ALTER COLUMNS tile. This way you have more granular control AND are not mixing and matching tasks. use Formulas to define formulas. use ALTER COLUMNS to set schema properties.
