Grouping date field in table view

Options
rparise
rparise Member
in Charting & Analyzer

I want to group sales by month.  I can get this view to populate with single bar chart, but when I try and convert to a table view it groups by invidivual day not month.

 

Thanks,

 

Rob

 

 

 

Best Answer

  • Godzilla
    Godzilla Contributor
    Answer ✓

    try this 

     

    STR_TO_DATE(CONCAT(month(`Date`) , '/1/' , year(`Date`)),'%m,%d,%Y')

    Domo Arigato!

    **Say 'Thanks' by clicking the thumbs up in the post that helped you.
    **Please mark the post that solves your problem as 'Accepted Solution'

Answers

  • rparise
    rparise Member

    Tried using Beast Mode field Month('Date').  Worked but returns integer month.  Want to convert that into Month Year format.  Suggestions?

     

    Thanks,

     

    Rob

  • Godzilla
    Godzilla Contributor
    Answer ✓

    try this 

     

    STR_TO_DATE(CONCAT(month(`Date`) , '/1/' , year(`Date`)),'%m,%d,%Y')

    Domo Arigato!

    **Say 'Thanks' by clicking the thumbs up in the post that helped you.
    **Please mark the post that solves your problem as 'Accepted Solution'
  • kshah008
    kshah008 Contributor

    @rparise, did Godzilla's reply help you out?

  • rparise
    rparise Member

    Sorry for the delayed response.  Yes this worked!!

     

    Thanks,

     

    Rob

This discussion has been closed.

Categories