-
Re: Why are all of these dates (Due_Date, PO_Date, Print_Date, Ship_Date) returning the date - 1 day
This is because Domo interprets all dates as UTC when they get imported. If your SQL server is configured for a timezone other than UTC you can use a date transform in your workbench job configuratio…1 -
Re: How can I set up a graph to show period over period data in a dynamic way?
@hollyrene1225 - I recommend restructuring your data so that you have multiple periods within the same dataset. I've done several writeups on this and it allows you to show multiple periods on the sa…2 -
Re: Magic ETL Possibility?
A more straightforward method rather than multiple CASE WHEN statements is to use SPLIT_PART SPLIT_PART(`Fruit`, ',', 1) -- First in CSV SPLIT_PART(`Fruit`, ',', 2) -- Second in CSV SPLIT_PART(`Fruit…2 -
Re: GA4 connector stopped on Importing ...
I'd recommend logging a ticket with Support to have them help diagnose your connector issue as they own that connector.1 -
Re: Best Practice - Columns to Rows?
@Data_Devon It depends on your use case. Having your columns wide will allow you to consume fewer rows overall, potentially reducing your costs. On the other hand, Domo likes things as rows to deal w…3