Odd behaviour with FISCAL Calendar
HI,
We have had the fiscal calendar enabled on our instance and the fiscal year loaded in.
I have noticed some very strange behaviour of the cards and was wondering if this is something domo haven't setup correctly or just limitations of the feature.
In our fiscal year we have a fiscal month running from 03/01/2021 to 30/01/2021.
If I choose the date range 01/01/2021 to 30/01/2021 I get the below data.
So we have a portion of last fin month in 2020 and then the first fin month of 2021 (why it says 2022 is also a mystery!). The data here is correct.
The biggest oddity is this. If I choose the date range 01/01/2021 to 31/01/2021. So this includes 1 day of the next fin month of 2021.
It doesn't break that part out into its own month. If I then include the 1st Feb 2021 I get the below. So it is only breaking the month apart on a new calendar month rather than the boundary for the next fin month.
Also if I start the period on 27th December 2020 to 30/01/2021 I then get 3 fiscal months when in reality this is only covering 2!!
Has anyone had any experience with the fiscal option?
Thanks
Answers
-
@MichelleH Thanks, Yes I have just had confirmation that there was an error uploading our custom fiscal year so they are redoing now for me
1
Categories
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 472 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 202 Visualize
- 255 Beast Mode
- 2.1K Charting
- 12 Variables
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 247 Distribute
- 63 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 179 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive