Best Of
Re: Identifying "Last Week' when current week is 0 or 1
CASE WHEN `Date` + INTERVAL (7-DAYOFWEEK(`Date`)) DAY = CURRENT_DATE() - INTERVAL DAYOFWEEK(CURRENT_DATE()) DAY THEN 'Last Week' ELSE 'Not Last Week' END
To add some additional context I'm adding a specific number of days to the date field to get to saturday (7) of that day's week then comparing it to last saturday (current_date - whatever day of the week it is to get back to 7). DAYOFWEEK returns 1-7 depending on which day the date actually is.
So for example since today is Friday DAYOFWEEK is 6. 6 days ago would be the saturday of last week.
Re: Is it possible to add hyperlinks into a Gantt Chart Y value?
@Stuck I agree that this could be a useful feature. I suggest checking whether anyone has already posted this to the Dojo Ideas Exchange and upvoting it so that Domo's product team sees it. If it hasn't been suggested already, then you can create a separate post for others to upvote.
Re: YTD Previus Year
I’d recommend reformatting your dataset to use a custom date offset dimension dataset. This will allow the interactions with the page date filters and simplify your data structure. I’ve done a write up on this previously here: https://dojo.domo.com/main/discussion/53481/a-more-flexible-way-to-do-period-over-period-comparisons#latest
Re: Difference between dates
Likely you're swapping the order of the parameters. If you reverse the order it should get you a positive number. The order is backwards where it expects the end date as the first parameter and the start date as the second parameter.
Re: Is it possible to add hyperlinks into a Gantt Chart Y value?
Currently this isn’t supported with a Gantt chart. You could uses drill path possibly to go to a table card which you can display and use a hyperlink to then open your project.
Re: How to join to a table multiple times?
If you want to do this just using views, then I think @Jones01 has the right idea. Depending on how many joins you want to do, this might get just as complex as just using an ETL. You could try doing this using a SQL dataflow as that might provide you with a little more familiarity with the process, but depending on the number and complexity of the joins, that could take a long time to run.
Re: How to join to a table multiple times?
You could create two contacts views. One filtered by buyers and one by sellers then join them both to your main dataset
I'm quite new to domo so someone may have a better way.
Jones01
Re: Avg. Time between purchase orders
You won't need your group by tile, just the Rank & Window tile.
Re: Avg. Time between purchase orders
@sarahi6 Are you wanting for each line to have the average time between purchases for all customers? If so, you'll want to use a Rank & Window tile to do that.
https://domohelp.domo.com/hc/en-us/articles/360042922814-Old-Magic-ETL-Tiles-Rank-and-Window
Re: Avg. Time between purchase orders
@sarahi6 because you have start and end date in your group on columns, you are only finding the average time between purchases on the same start and end date. I am assuming you want to find the average time between purchase by customer, so you will want to just group on customer id (remove the start/end date columns).
mhouston