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
- 10.5K All Categories
- 5 Connect
- 915 Connectors
- 250 Workbench
- 459 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 476 Datasets
- 186 Visualize
- 250 Beast Mode
- 2.1K Charting
- 11 Variables
- 16 Automate
- 354 APIs & Domo Developer
- 88 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 245 Distribute
- 62 Domo Everywhere
- 242 Scheduled Reports
- 20 Manage
- 41 Governance & Security
- 170 Product Ideas
- 1.2K Ideas Exchange
- 10 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive