Best Of
Re: Google Sheets Enterprise WriteBack Connector Errors
I'd try just 1 row and see if it times out, but it should have been able to use 7k rows. I'd double check your connections and your permissions.
Re: Unable to save card with Beastmode active
Domo currently doesn't support filtering with window functions, so you're getting the error. They did previously but recently stopped supporting it without any reasoning or documentation.
Re: Conditional Formatting Based On User
Currently this isn't possible but I'd recommend adding it to the Ideas Exchange to allow getting the logged in user's information.
Re: locks = locks?
Perhaps not the best way, but to your ETL that builds that DataSet, I'd add a calculated column that tells you the difference between the 2 values and another one that would just flag if the date is older than your threshold (in this case 7 days).
You'll have a formula tile in your ETL that will do both calculations, something like
IsOlderThanThreshold
CASE WHEN `PowerLenderLockDate` <= CURDATE() - Interval 7 Day THEN 'True' ELSE 'False' END
Delta
Rate_locks_powerlender - Rate_locks_powerseller
With this I'd then do the Alert as follows:
- Trigger Depends on whether your ETL does replace or append.
- Filters
- IsOlderThanThreshold equals True
- Delta is not equal to 0
This has the advantage that it won't only notify you when the entry 0 days ago is not 0, but whenever an older entry may stop being compliant. Hope this helps.





