Grouping date field in table view

rparise
rparise
in Card Building

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

    try this 

     

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

Answers

  • rparise
    rparise

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

     

    Thanks,

     

    Rob

  • kshah008
    kshah008

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

  • rparise
    rparise

    Sorry for the delayed response.  Yes this worked!!

     

    Thanks,

     

    Rob

This discussion has been closed.

Categories