Flagging items past today's date
Hi,
I have a table where I am trying to flag all line items where the "Planned End Date" is past the current date. Is there a quick beast mode for this?
0
Best Answer
-
You could write a beast mode to bucket dates and would have one that was for previous dates and one for future dates then have them be different colors on your cards. Here is what a beastmode could potentially look like.
(CASE when `Planned End Date`-CURRENT_DATE()<0 then 'Future' end)
The have another beastmode with the below
(CASE when `Planned End Date`-CURRENT_DATE()>0 then 'Past' end)
You could then use these as the columns in your card and assign different colors for them to make them distinct from each other.
1
Answers
-
Thank you! That worked!
0
Categories
- 10.8K All Categories
- 3 Private Company Board
- 1 APAC User Group
- 12 Welcome
- 39 Domo News
- 9.7K Using Domo
- 1.9K Dataflows
- 2.5K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 343 Workbench
- 260 Domo Best Practices
- 11 Domo Certification
- 467 Domo Developer
- 50 Domo Everywhere
- 106 Apps
- 717 New to Domo
- 85 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 27 お知らせ
- 64 Kowaza
- 299 仲間に相談
- 654 ひらめき共有