Formatting Fiscal Year and Quarter columns
gbrown
Member
in Beast Mode
Answers
-
We maintain a date lookup table that we leverage across multiple datasets that tells us the specific things we need to know about our fiscal year, like quarter, week number, prior year, etc. that would be relevant across all dates. It can be a little work to ramp up a table, but the payoff is there. A join on the date through magic ETL will give you just about any naming conventions you might need.
4 -
@gbrown I second @kivlind's suggestion of using a date lookup table. Domo also has a Fiscal Calendar feature, which allows you to group card data by fiscal period:
https://domohelp.zendesk.com/hc/en-us/articles/360042924254-Using-a-Fiscal-Calendar
2
Categories
- All Categories
- 1.4K Product Ideas
- 1.4K Ideas Exchange
- 1.4K Connect
- 1.2K Connectors
- 284 Workbench
- 4 Cloud Amplifier
- 4 Federated
- 2.9K Transform
- 88 SQL DataFlows
- 554 Datasets
- 2.2K Magic ETL
- 3.3K Visualize
- 2.3K Charting
- 564 Beast Mode
- 9 App Studio
- 27 Variables
- 577 Automate
- 140 Apps
- 414 APIs & Domo Developer
- 22 Workflows
- 1 DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 350 Distribute
- 90 Domo Everywhere
- 258 Scheduled Reports
- 2 Software Integrations
- 91 Manage
- 88 Governance & Security
- 9 Product Release Questions
- Community Forums
- 42 Getting Started
- 28 Community Member Introductions
- 85 Community Announcements
- 4.8K Archive