Best Of
Re: Flow for dates
@mroker LOL! I wish you could hit awesome 10 times! Glad it helped you and will hopefully help others.
Re: Year over year cumulative average
You can use a window function to keep a running total and then divide them
SUM(SUM(`Cases Closed`)) OVER (ORDER BY `Year`, `Month`) / SUM(SUM(`Total Cases`)) OVER (ORDER BY `Year`, `Month`)
Re: Rank based on 2 metrics?
More like Mark BAD@SS. That did the trick. Only took my caveman brain a few tries to get it humming.
If anyone reading this needs a hand with the syntax, here's an example. In my case I needed to sum up two different metrics, one for count (Field) and a tiebreaker for size (Field 2).
Thanks again @MarkSnodgrass!
Re: What is the best way to parse URLs?
@MarkSnodgrass - This is one of those times that I wish Domo's documentation kept up with Domo's updates. There is no SPLIT_PART() function listed in the beastmode function list, but it definitely works! I was just able to clean up some really nasty substring() beastmodes :)
Re: 12k beast modes and counting...
Hi Jae! Your videos have saved me countless times! I love the series you did on recursive dataflows! Your an inspiration!
I think our issue is that folks AREN'T sharing it to a dataset, and that causes 3 analysts to make 3 beast modes that do very similar things, if not identical. Instead of a training issue, perhaps it should be a Domo UI feature where Domo makes the Share to Dataset box checked by default? Seems like something that at the very least should be up to the Major Domo and put a toggle in the admin section to choose what the default is for the instance?
I have no less than 1000000 good ideas on how domo could improve their software, happy to discuss this further if you're interested.
Re: Workbench Restarts when "Source File Doesn't Exist"
Have you updated to the latest version of workbench and rebooted the server or in the famous words of the IT Crowd: “Have you tried turning it off and on again?”
Re: Empty plug in top left
Hi @Joshua98, welcome mate. So that 'M' logo seen in those videos is an example of a company logo of the instance users use. For your Domo instance, you can add in your company logo in place of that empty slot through Admin and then following the steps here: https://domohelp.domo.com/hc/en-us/articles/360043439053-Specifying-Your-Company-Name-and-Logo
amehdad
Re: How does the dashboard level filter work?
Hi @NathanDorsch, yes the 'Choose Date' filter applies to any card on the dashboard where the dataset has some date field. In terms of a dataset with multiple data fields, it may take the field that is most common across the other datasets involved in the dashboard or a date field with the largest range.
amehdad
Re: Foreign Currency Conversion Help
Hi @RichYute, there's a connector called Open Exchange Rates that you can use. Have a read of this [https://domohelp.domo.com/hc/en-us/articles/360043432893-Open-Exchange-Rates-Connector] before setting it up it in your ETL.
amehdad




