Dynamic date range (last two quarters data)
Saketh
⚪️
HI All, I am looking to create a dynamic date filter on my card. The objective is to get last two financial year quarters data.
I am aware that there is an option in DOMO to get last two quarters data but this gives me incorrect results i.e if we are in May then this gives me nov - april data but what I need is oct 1st - march 31st data.
Currently I go into the cards regularly and update the dates but I am looking to create a dynamic date field using the beast mode.
Any help would be appreciated, thank you.
0
Answers
-
Hi @Saketh
Have you looked into implementing a Fiscal Calendar from Domo? https://domohelp.domo.com/hc/en-us/articles/360042924254-Using-a-Fiscal-Calendar
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0
Categories
- 11K All Categories
- 5 Private Company Board
- 2 APAC User Group
- 12 Welcome
- 42 Domo News
- 9.9K Using Domo
- 2K Dataflows
- 2.5K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 349 Workbench
- 267 Domo Best Practices
- 11 Domo Certification
- 474 Domo Developer
- 51 Domo Everywhere
- 110 Apps
- 725 New to Domo
- 85 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 29 お知らせ
- 65 Kowaza
- 301 仲間に相談
- 662 ひらめき共有