Can't Graph by Month

SaloniShah

I've merged two tables and used the following formula to make sure the date doesn't get converted to String

The two tables joined successfully. But My chart doesn't let me Graph By - Month

The Table format still shows as 'String' under the Date columns.

What can I do maintain the dates as 'Date' format so that I can Group them by 'Month' in Charts.

MarkSnodgrass

@SaloniShah A couple things to point out here:

Your x-axis is not being recognized as a date field. When it isn't a date field, Domo will not let you use the "graph by" option in the date range filter.

I see your x-axis field is "created date", but your formula in your ETL screenshot is creating a field called "AggregateDate". Have you tried putting the "AggregateDate" field in your x-axis?

A quick way I often convert a field to a date data type in the formula editor is to wrap the DATE() function around it. Such as, DATE(`AggregateDate`) . This will convert it to a date field, assuming the field has all valid dates.

Hope this helps.

Jones01

@SaloniShah

try using the alter column tile after the append to cast it into a date.

SaloniShah

@Jones01 what formula should I use to Cast it into date?

MarkSnodgrass

@SaloniShah A couple things to point out here:

Your x-axis is not being recognized as a date field. When it isn't a date field, Domo will not let you use the "graph by" option in the date range filter.

I see your x-axis field is "created date", but your formula in your ETL screenshot is creating a field called "AggregateDate". Have you tried putting the "AggregateDate" field in your x-axis?

A quick way I often convert a field to a date data type in the formula editor is to wrap the DATE() function around it. Such as, DATE(`AggregateDate`) . This will convert it to a date field, assuming the field has all valid dates.

Hope this helps.

SaloniShah

Thanks @Jones01 & @MarkSnodgrass I used the STR_to_Date function and it worked fine.