Best Of
Re: January Virtual User Group Kickoff
As it turns out, it WAS amazing! Thank you to the team that pulled off this excellent event for the community.
Re: January Virtual User Group Kickoff
These sessions should be more than twice a year. Just saying :)
Re: Governance datasets with Dataset source name
Hi @AnwarBham
That level of detail doesn’t exist in the governance/metadata tables and isn’t easily available without getting very technical with some API calls
Re: Beast mode that would put people in a specific group based upon a date
@user048760 using the datediff function and the current date function in my initial response would get you that day difference.
Re: HTML code is not working in table view
The basic table card supports a limited amount of HTML in it. To do what you want to do, you need to choose the HTML table card type. This is found under Tables and Textboxes in the chart types dropdown list.
Re: PDP Policy Simple Filter - don't see value in dropdown list
@loganherzog could you create a new column (i.e. StoreNo_PDP) using the formula tile for use in the PDP policy that meets either of @GrantSmith suggestions? Then you would not risk altering downstream ETL's.
mhouston
Re: Could not refresh dataset - Other Provider
This is likely coming from Domo Workbench. You need to go to where Domo Workbench is installed (likely on a company server) and check there for the reason that it isn't running. In Workbench, you can also change the type from Other Provider to Excel.
Re: Issue with dates in ETL
I would double-check that your Application Latest Hired Date is being seen as a date field by Domo and not a text/string field. If it is not being viewed as a date field, the evaluation will be problematic.
Re: 60 days since last pmt beastmode
You can use a case statement and datediff to do this:
CASE WHEN DATEDIFF(CURRENT_DATE(),`lastpmtdate`) >= 60 THEN '60 or greater' ELSE 'less than 60' END
Then just filter to 60 or greater
Re: How to find the difference between 2 dates?
Hi @user048760
Another option would be to define a custom date offset dimension for the current date, last month and 2 months ago. You can then conditionally calculate the rolling average over the past 3 months or look at the difference between months based on the offsets your define. I’ve done a write up about offset dimensions before: https://dojo.domo.com/discussion/comment/50540#Comment_50540
@jaeW_at_Onyx has done a video on this as well. https://www.youtube.com/watch?v=CDKNOmKClms&t=325s