How to calculate rolling 30 days of DateA occurring from DateB
Hi all,
So I had an initial question that has since been answered which was how to calculate when a date occurs within the same month of another date column but has since been answered (https://dojo.domo.com/discussion/comment/56039#Comment_56039).
Now, I would like to change this up to see when column DateA occurs within 30 days of column DateB.
The date calculations escape me but hoping to learn through solutions of what works and how. Any advice is greatly appreciated!
Additional context: I have two date columns and want to use DateB as the "anchor" to see instances of when DateA occurs within +30 days of DateA to grade performance of duties for associates based on when a task was assigned to them.
(e.g.) DateB: 12/1/2021 and DateA 12/25/2021 would be counted as a 1 vs DateA 01/11/2022 would be counted as a zero with the same DateB of 12/1/2021.
Answers
-
You can accomplish this with the DATEDIFF() function, which calculates the number of days between two dates. Example:
DATEDIFF(`DateA`,`DateB`)
To count how many are within 30 you would add a CASE statement around this, like this:
CASE WHEN DATEDIFF(`DateA`,`DateB`) <= 30 THEN 1 ELSE 0 END
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.1
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
- 466 Domo Developer
- 50 Domo Everywhere
- 106 Apps
- 717 New to Domo
- 85 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 27 お知らせ
- 64 Kowaza
- 299 仲間に相談
- 654 ひらめき共有