Converting Text column with fiscal periods to a date

jkellams

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?

DashboardDude

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