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
1
Categories
- 7.7K All Categories
- 7 Connect
- 922 Connectors
- 245 Workbench
- 477 Transform
- 1.8K Magic ETL
- 60 SQL DataFlows
- 446 Datasets
- 57 Visualize
- 205 Beast Mode
- 2.1K Charting
- 8 Variables
- 4 Automate
- 349 APIs & Domo Developer
- 84 Apps
- Workflows
- 15 Predict
- 3 Jupyter Workspaces
- 12 R & Python Tiles
- 242 Distribute
- 60 Domo Everywhere
- 241 Scheduled Reports
- 15 Manage
- 36 Governance & Security
- 42 Product Ideas
- 1.1K Ideas Exchange
- 2 Community Forums
- 15 Getting Started
- 2 Community Member Introductions
- 50 Community News
- 18 Event Recordings
- 576 日本支部