Best Of
Re: Any way to highlight current date on a line chart?
@GrantSmith Thank you again! I'm enjoying the learning process, and I'm especially encouraged by this active Domo community!!
1
Re: Odd issue with ETL and missing data
If it is in the output dataset preview it should be in the output. I'd be happy to jump on a call with you and try and troubleshoot:
Re: Creating a Beastmode that meets Revenue Requirements
CASE
WHEN SUM(revenue) > 1000
AND SUM(CASE WHEN (`date` - DAYOFMONTH(`date`) + 1) = STR_TO_DATE(CONCAT(YEAR(NOW())-1,'-',MONTH(NOW()),'-01', '%Y-%m-%d') THEN
`revenue` END)
WHEN . . .
END
You can try something like this to check if date is equal to 12 months ago and has 100 or more in revenue and the overall revenue is greater than 1000
Re: Expose DomoStats Groups
You'll need to use the Domo Governance datasets for groups. The 'Users and Groups' report has all the fields you need!



