Best Of
Re: NEW Domo Data Science Resources Guide (help w/ Jupyter, scripting tiles, data science tiles, AutoML)
Thank you for the resources. Scheduling/triggering multiple notebooks within one workspace would be nice. Is that a planned feature or should I just look elsewhere for running our automation scripts?
dp4ge
Re: Schedule App Studio Reports
@Arthi Annadi I don't see an update on my end so I believe not!
Re: What does the publish App do in the App studio?
Here are some KB articles with more information:
https://domo-support.domo.com/s/article/360043441593?language=en_US
Re: Remove null values to make sorting works accordingly
You could correct the nulls by using the following beastmode:
IFNULL(`YourValue`, 0)
You can also sort any values using a beastmode like this:
CASE WHEN `Transaction Month` = 'Jan' THEN 1 WHEN `Transaction Month` = 'Feb' THEN 2 WHEN `Transaction Month` = 'Mar' THEN 3 WHEN `Transaction Month` = 'Apr' THEN 4 WHEN `Transaction Month` = 'May' THEN 5 WHEN `Transaction Month` = 'Jun' THEN 6 WHEN `Transaction Month` = 'Jul' THEN 7 WHEN `Transaction Month` = 'Aug' THEN 8 WHEN `Transaction Month` = 'Sep' THEN 9 WHEN `Transaction Month` = 'Oct' THEN 10 WHEN `Transaction Month` = 'Nov' THEN 11 WHEN `Transaction Month` = 'Dec' THEN 12 Else 13 END
Re: 11/18 PRODUCT RELEASE SNEAK: New Table Element in App Studio (Beta)
Love to see enhancements to tables, this is great!
Re: Group By Issue
Wow - i think that worked, i need to test this out a bit more, but its looking good. I was way off on my first attempt haha thank you for clarifying @rco. I wish I understood better what exactly is happening here, but I'll figure that out.
I'll keep validating this, but I think its working!
Re: New Guy Here - What's the Point of Apps??
I think it also has a lot to do with interactivity. Apps have more capability with workflows, forms, etc.
I agree with @Data_Devon. If dashboards work for you, use them. There's no need to work through apps if you are monitoring/analyzing metrics without more process needs.
Re: Pulling the First Saturday of the previous 6 months
For a date column called "d", the filter formula would be:
dayofweek(d) = 7
and dayofmonth(d) < 8
and (year(today()) * 12 + month(today())) - (year(d) * 12 + month(d)) < (case when dayofweek(today()) = 7 or dayofweek(today()) < dayofmonth(today()) then 7 else 6 end)
This checks three conditions:
1. The day is Saturday
2. The day is in the first week of the month
3. The year*12 + months difference between the current date and the date in question is less than 7 if there has not yet been a Saturday in the month, or 6 if there has been.
The formula is simpler if you want anything in the last 6 months regardless of whether there has already been a Saturday in the current month:dayofweek(d) = 7 and dayofmonth(d) < 8 and d >= today() - interval 6 month
But from your description I think the first formula is what you want.
rco
![[Deleted User]](https://community-forums.domo.com/applications/dashboard/design/images/banned.png)



