Fiscal Year Beast Mode
Hi all,
I am trying to create a filter on the dashboard for us to be able to filter by fiscal year
The problem I am running into is that we have already contacted Domo about giving us the fiscal year option so all of the cards below this filter are already in fiscal year. The filter above is not. I have a simple beast mode that took the year(`purchase date`) and have it filtered by that but need to have a fiscal year calculation added to that beast mode instead.
This is what I have so far. I am not sure what the syntax is supposed to look like but Domo doesn't like this one. Can someone help with what I need here?
**Our fiscal year begins July 1 so anything that is between July 1, 2021 and June 30, 2022 would be FY 2022
If this helps, feel free to agree, accept or awesome it!
Answers
-
Ok so I fixed the () issue and now I'm back to square one. This is the new filter based on that coding above.
when I put the year function in front of it, I only am able to get 2022 to show up
If this helps, feel free to agree, accept or awesome it!
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 295 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 98 SQL DataFlows
- 608 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 713 Beast Mode
- 50 App Studio
- 39 Variables
- 669 Automate
- 170 Apps
- 447 APIs & Domo Developer
- 45 Workflows
- 7 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 116 Manage
- 113 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 104 Community Announcements
- 4.8K Archive