GrantSmith Coach 
-
Re: Mirror User Card Access
Are these two users in the same group / need the same access? Have you thought about configuring a group and then sharing the cards with that group instead so any future users will get the access whe…1 -
Re: How do I get the date to show up even when there are no results?
Start with the calendar dataset from the Domo date dimension connector and left join your dataset to it on the date using a dataset view or ETL. Then use the calendars date field instead of your own.…2 -
Re: Dashboard display based on current time
You can't dynamically tell a page to filter on different values (filter on shift 1 / filter on shift 2) depending on the time of the day. You'd likely need to have a beast mode that calcula…1 -
Re: How do you rename null values in a date column?
You can use a beast mode in analyzer or a formula tile in Magic ETL 2 and the COALESCE function to change NULL values to another value: COALESCE(`dt`, '2022-02-02')2 -
Re: Add Data that has been modified in the last 7 days
Snowflake has a bit different syntax. Try something like: SELECT * FROM "TABLE" WHERE "ORDER_MODIFIED_TIME" > CURENT_DATE() - interval '7 day'1
