Grouping date field in table view

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 🟢
    Accepted Answer

    try this 

     

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

Answers

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

     

    Thanks,

     

    Rob

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

  • Sorry for the delayed response.  Yes this worked!!

     

    Thanks,

     

    Rob

This discussion has been closed.