Can't Graph by Month

SaloniShah
SaloniShah Member
in Charting

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

image.png

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

image.png

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.

image.png


Tagged:

Best Answer

  • MarkSnodgrass
    MarkSnodgrass Coach
    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.


    image.png


  • SaloniShah
    SaloniShah Member

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

  • MarkSnodgrass
    MarkSnodgrass Coach
    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.
  • SaloniShah
    SaloniShah Member

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

Categories