GrantSmith Coach 
-
Re: calculate difference between two dates
Hi @user041053 You'll need to utilize a window function and a date diff function to calculate the difference between the two dates. DATE_DIFF(`Date`, COALESCE(LAG(`Date`) OVER (ORDER BY `Date`))…1 -
Re: calculate difference between two dates
@user04105 I'm working with too many different SQL version, so sorry! It should be DATEDIFF not DATE_DIFF. Domo has some issues processing with the coalesce inside and not populating the date co…1 -
Re: Julian Date
HI @user18189 Which format are your Julian dates in? YYDDD or YYYYDDD? Since Julian dates count the number of days and doesn't use months you'd need some sort of DATE_ADD function call to a…1 -
Re: Julian Date
Hi @Ajeet_Mahajan Did that solve your problem? If so can you accept the answer so it's easier for others to find the solution in the future? Thanks!1 -
Re: Is there any way we could replicate Multi-Row formula tile of Alteryx tool in Domo?
Hi @LoveBindal Have you looked into Window functions? You can do it in either an ETL using the Rank and Window tile (https://domohelp.domo.com/hc/en-us/articles/360042922814-Magic-ETL-Tiles-Rank-and-…1
