Converting Text column with fiscal periods to a date
Hello,
I have a relatively simple dataset with one column that lists fiscal periods, another with some product types, and another with sums of those product types.
I'd like to use this data to create a bar variance card, but Domo is currently looking at my fiscal periods column like they're 'text' instead of 'dates.' The periods are formatted like FY22P5, FY22P6, etc.
How would I convert the data column so that it's being looked at as a date as opposed to a string of text?
Answers
-
Hi @jkellams ,
I made you a video on how to do this: https://www.loom.com/share/5ce03a817b5a49c8b3b76b5f29bccb36
So you need to do some text formatting, but you can get the result.
John Le
You're only one dashboard away.
More video solutions at: https://www.dashboarddudes.com/pantry
John Le
You're only one dashboard away.
Click here for more video solutions:
1
Categories
- 10.5K All Categories
- 7 Connect
- 917 Connectors
- 250 Workbench
- 463 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 476 Datasets
- 190 Visualize
- 252 Beast Mode
- 2.1K Charting
- 11 Variables
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 246 Distribute
- 62 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 172 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive