MarkSnodgrass Coach 
-
Re: Calculated Fields - Pipedrive ID's
You would want to use the formula tile in Magic ETL to do this type of conversion. If your list is quite long, another option would be to create a lookup table with a Domo Webform or a spreadsheet th…3 -
Re: Postgres SSH Connector - Data Types not importing as expected
Often when a field doesn't come in as the type I expected, I use Magic ETL to cast it to the appropriate type and then use the output dataset for my cards. There are a couple ways to do this in …1 -
Re: How to display results up to last week
You can create a beast mode that will look at the current date and then move it back to the last day of the previous week and then compare it against your date field. CASE WHEN `date` <= /* last d…4 -
Re: Beast mode to extract the date based on a pattern
@ozarkram if your data has no consistency or pattern as to where the date is going to be, then it is going to be extremely difficult to construct the correct statement to extract it. If you can ident…1 -
Re: Count amount of dates in a row
It depends how you want to display the data, but at a basic level if you used a table card, drag in date of stay and market, then drag in market again and change the aggregation type to count. This w…2
