Best Of
Re: Identify a duplicate
Ah, you can't use it within a formula tile. That's just the format for a beast mode. If you're looking to use Magic ETL take your data and feed it into a Group By tile. Group based on the loan_id and COUNT the loan_id to get the total number of records then join that back to your original dataset based on the loan_id. That will get you the number of co-borrowers.
Re: What is the best password policy for Encryption on Workbench
You can't use 30 different passwords to encrypt the data unless you have 30 different datasets which I highly recommend against as that's quite a bit of management overhead.
Typically using a password manager where you can grant or revoke access to the different accounts / passwords is good practice so you don't have passwords floating out in the wild.
Re: Trigger Frequency Option - When All Datasets Updated
Looks like I can't edit or delete my post but wanted to correct the post. The category split should be
When selected datasets have been updatedAfter each dataset has been updatedWhen all datasets have been updatedAfter all datasets have been updated
It' would be awesome to have dataflow wait until all selected datasets have run before the it kicks off.
Micah209
Re: Card filtering in analyzer
Have you tried using a COALESCE and filtering on the default value?
COALESCE(`field`, 'Empty')
Re: How to create a date field beastmode in Analyzer using 2 different date fields.
@charles It looks as though your calendar_shipDT is really just determined by looking at the schedule_ShipDT and seeing which day of the week it is and making the calendar_shipDT be the appropriate Wednesday. Here is what I put together that would accomplish this:
CASE /* if the day of week of the schedule ship date is Wednesday, use that day */ WHEN `dt` = 4 THEN `dt` /* if the day of week of the schedule ship date is Sun, Mon, Tue, use the upcoming Wednesday */ WHEN `dt` < 4 THEN DATE_ADD(`dt`, INTERVAL (4-DAYOFWEEK(`dt`)) day) /* if the day of week of the schedule ship date is Thur, Fri, Sat, use the Wednesday in the following week */ WHEN `dt` > 4 THEN DATE_ADD(`dt`, INTERVAL (11-DAYOFWEEK(`dt`)) day) END
You would replace dt with your schedule_shipDT fieldname.
This would result in data that looks like this:
Let me know if that doesn't work for you.
Re: Have date range in x axis for week
@chetan_cricut You would need to create a calculated field to concatenate the first and last day of the week (similar to how you created the week start date) for your x-axis, sorting by week start date. Your x-axis calculation would look something like this:
concat(date_format(`Date` - dayofweek(`Date`) + 1,'%b %d), ' - ', date_format(`Date` + (7 - dayofweek(`Date`)),'%b %d))
Re: How to use Rank System in Beast Mode
@Ruban Can you please provide more information on what you are trying to accomplish so that we can better answer your question?
Re: Set job schedule
@user02055 You can turn off error emails by deselecting the "Notify on Error" checkbox in the Notifications tab on your Workbench job: https://domohelp.zendesk.com/hc/en-us/articles/4407013819671-Setting-Notifications-in-Workbench-5-1
However, I would recommend adjusting the schedule to start a little after 6 am to account for the scheduled maintenance rather than turning off error notifications all together.