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.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 102 SQL DataFlows
- 626 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 753 Beast Mode
- 61 App Studio
- 41 Variables
- 692 Automate
- 177 Apps
- 456 APIs & Domo Developer
- 49 Workflows
- 10 DomoAI
- 38 Predict
- 16 Jupyter Workspaces
- 22 R & Python Tiles
- 398 Distribute
- 115 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 130 Manage
- 127 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 11 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 110 Community Announcements
- 4.8K Archive