Minimum logical function for beastmode
user05685
⚪️
It would be very helpful to have a LEAST()/MOST() function that calculates the minimum/maximum from a user defined set rather than from a column as MIN()/MAX() does. I understand this can be done with a case currently, but that is very cumbersome.
I would like to be able to do the following:
LEAST(datediff(curdate(), min(date)), 30)
These would alleviate needing to type out a case such as:
case when datediff(curdate(), min(date)) < 30
then datediff(curdate(), min(date))
else 30
Ideally it could be used with more than 2 variables.
end
0
This discussion has been closed.
Categories
- 10.8K All Categories
- 3 Private Company Board
- 1 APAC User Group
- 12 Welcome
- 38 Domo News
- 9.7K Using Domo
- 1.9K Dataflows
- 2.5K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 343 Workbench
- 258 Domo Best Practices
- 11 Domo Certification
- 464 Domo Developer
- 50 Domo Everywhere
- 104 Apps
- 714 New to Domo
- 85 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 26 お知らせ
- 64 Kowaza
- 299 仲間に相談
- 653 ひらめき共有