Best Of
Card Alerts
It would be nice to set up Alerts on cards on the fields used in the card. The only option currently is setting up an Alert on the Summary Number.
ShaneB
Notification Prior to Scheduled Report Expiration
Currently the Scheduled Reports list only allows sorting by Title, Start Date, and Next Delivery, but not Expiration Date. This makes it difficult to see at a glance which report schedules are about to expire, which is especially important since users are required to set an end date to the report schedule.
It would be helpful have some sort of notification when a report schedule is about to expire so we can assess whether or not to extend the schedule. This could be managed via Buzz, email, a Domo Governance report, etc.
Re: Redshift vs. MySQL vs. ETL
DDalt,
Thank you for reaching out with your question. Redshift is great for many use cases, especially those that require SQL transformations on larger data. The downside is that the Redshift service and resources alotted to processes are managed by Amazon and remove some environment controls that Domo otherwise has for MySQL and Magic ETL.
MySQL will generally present less variance in DataFlow run times, but it does not automatically index data as Redshift does, so it is better suited to smaller input row counts. MySQL doesn't share all of the same functionality as Redshift, as is the case with windowed functions available in Redshift. Otherwise, to get the best performance out of mySQL DataFlows, you should employ indexes for joins and consider other optimizations discussed here:
http://knowledge.domo.com?cid=optimizingdataflow
Magic ETL is well suited to larger input DataSets, and could be considered as an alternative to Redshift for many use cases. It will begin to process data through the transformations as the input data comes in, rather than waiting for all of the input data to load completely, as Redshift does.
To summarize, while Redshift is good for larger data, mySQL should be used for smaller Data inputs. Magic ETL is good for small and large data inputs. Each use case will determine what tool is the best fit, but they all have their place in your toolbox for data manipulation and additional data preparation for various use cases.
Regards,
Darius
Enhance Scheduled Reports
Currently we have the ability to add a csv to a scheduled report. I'd love the ability to also include a PowerPoint or PDF of my page/dashboard.
Ashleigh
Some useful Regex statements
ToDo:
Use an Edit Data --> Replace Text action in the workflow.
Select Regex option and replace by empty string.
You can also replace the match with any string you require.
Get Handles:
Example: Hi @Something how are @you doing David.
Result: @Something @you
Get Hastags:
(^|\s|[^#\w])+[^#\s]+
Example: Hi #Something how are #you doing David.
Result: #Something #you
Remove Handles:
(?=(@\w+\b))
Example: Hi @Something how are @you doing David.
Result: Hi how are doing David.
Remove Hashtags:
(?=(#\w+\b))
Example: Hi #Something how are #you doing David.
Result: Hi how are doing David
Get a word or phrase:
\b(?!cat\b)\w+
Example: This cat is beautiful!!
Result: cat
Except a word or phrase:
\b(?=cat\b)\w+
Example: This cat is beautiful!!
Result: This is beautiful!!
Get Character(s):
Get 1st four characters (including space)
(?<=.{4}).+
Example: This cat is beautiful!!
Result: This
Get last four characters (including space)
.+(?=.{4})
Example: This cat is beautiful!!
Result: ul!!
** I will append more Regex scenario as I go through them. Please feel free to add or comment on the scenarios you go through more frequently and I will try to append it asap.
NFSharma