Best Of
Re: Flow for dates
Can I answer awesome 10 times? Thank you so much Mark. This was truly helpful and thanks for making a video so it is even clearer.
mroker
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?”