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
Are you on my newsletter? If not, signup here so you don't miss out on my Domo tricks, alerts about my webinars, cooking tips and more
Signup here:
1
Categories
- All Categories
- Product Ideas
- 2.1K Ideas Exchange
- Data Connections
- 1.3K Connectors
- 309 Workbench
- 17 Cloud Integrations
- Data & ETL
- 2.3K Magic ETL
- 120 SQL DataFlows
- 666 Datasets
- Visualize & Apps
- 90 App Studio
- 198 Pro-code Components
- 2.6K Charting & Analyzer
- 873 Calculations & Variables (Beast Mode)
- AI & Data science
- 23 Domo AI & AI Chat
- 4 Managing AI
- 18 Jupyter Workspaces
- Automate
- 122 Workflows
- Alerts
- Distribute
- 118 Domo Everywhere
- 284 Reporting
- Manage
- 145 Governance & Security
- 489 APIs
- 11 Add-ins & Plugins
- 13 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 118 Community Announcements
- 5K Archive