Can't Graph by Month

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.


Best Answer

  • MarkSnodgrass
    Answer ✓

    @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.

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.

Answers

  • Jones01
    Jones01 Contributor

    @SaloniShah


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



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

  • MarkSnodgrass
    Answer ✓

    @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.

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.
  • Thanks @Jones01 & @MarkSnodgrass I used the STR_to_Date function and it worked fine.