Best Of
Re: Duplicate value handling in ETL
It doesn't appear that you have a lot of consistency to go off of since some of your first words have spaces and sometimes your first word is also the second word. Are the words at the end consistently the same? If so, you could look at the end of the string using the RIGHT() function and if it equals Referral or Internet, then you could use the REPLACE function to replace that word with nothing.
Intro
Hello Domo Community,
I am going on 13 years of using Domo, since the super secret NDA days and I have been loving it since!!! As always I am here to share knowledge and help out where I can, but also to see the cool things you all are doing!
Re: Bullet Chart Data Labels
@calvert_schaefer @NDoyle Domo informed me this morning that the problem is resolved.
Re: Incremental refreshes using Domo Workbench
No, it will only pull in the data that was updated based on the update timestamp from your database thus reducing the amount of data pulled in and processed. If you're wanting to remove old data then you can look into partitioning as @MarkSnodgrass mentioned.
Re: Allow naming of tables in Snowflake with Cloud Amplifier
Hi all - this issue has been resolved, and when using Domo to create new tables in Snowflake those Snowflake tables will now reflect the name of the DataSet from Domo.
Re: Remove duplicate unknown comma separated values within a single 'cell'
Here's a screenshot with an example (it's using bogus data but illustrates what I'm talking about):
Re: Calculate Previous Quarter Start and End Date
These are untested but something like this should get you what you're looking for:
Previous Quarter Start Date
LAST_DAY(`Report Date`) - INTERVAL (MOD(MONTH(`Report Date`), 3) + 3) MONTH + INTERVAL 1 DAY
Previous Quarter End Date
LAST_DAY(`Report Date`) - INTERVAL (MOD(MONTH(`Report Date`), 3)) MONTH
Previous Two Quarter Start Date
LAST_DAY(`Report Date`) - INTERVAL (MOD(MONTH(`Report Date`), 3) + 6) MONTH + INTERVAL 1 DAY
Previous Two Quarter End Date
LAST_DAY(`Report Date`) - INTERVAL (MOD(MONTH(`Report Date`), 3) + 3) MONTH
LAST_DAY(`Report Date`)
Returns the date of the last day in the month which you're aware of but clarifying it for others.
MOD(MONTH(`Report Date`), 3)
This tells us how many months to subtract to get to the prior quarter based on the Report Date's quarter. It's dividing the month number by three to get the remainder. For November it'll be 2. 11-2 = 9 (September)
- INTERVAL ... MONTH
Subtract the specific number of months calculated above. Adding 3 to that number will take us back another entire quarter or 6 to go back two more quarters.
+ INTERVAL 1 DAY
Add a day from the last day in the quarter 2 (+3 months) or 3 (+6 months) to get to the first day of the quarter 1 or 2 quarters ago.








