Data_Devon Contributor 
-
Re: Not able to sort Dates
Hi Ritesh! It looks like you have it sorted by Alphabetically even though the X-Axis is a date type. Click the little "ZA Arrow" sort button on the Y Axis, as shown in my screenshot, to tog…3 -
Re: what kind of SQL does DOmo use
Domo uses the MySQL dialect. Here's a few references: https://domo-support.domo.com/s/article/4405337525783?language=en_US1 -
Re: Is beast mode needed?
Hopefully the GOATs 🐐 can chime in, but here's what I'd do: Use this CASE WHEN (you were on the right track thinking of using the CASE WHEN) to flag a date as before today: CASE WHEN `Date_Time_Start…1 -
Re: How can I set up a graph to show period over period data in a dynamic way?
Hi hollyrene1225. Have you looked into the "Period over Period" chart types? They are mostly plug and play, so you wouldn't need to do any cooking in Magic ETL - just select the chart and y…1 -
Re: Date Calculation
I'd use the AddDate() function like so: ADDDATE('2024-12-04', INTERVAL 1 MONTH) If you intend to also jump to the next year - i.e. from December 2024 to January 2025 - that will be an extra step. You…2
