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
try this
STR_TO_DATE(CONCAT(month(`Date`) , '/1/' , year(`Date`)),'%m,%d,%Y')
Tried using Beast Mode field Month('Date'). Worked but returns integer month. Want to convert that into Month Year format. Suggestions?
@rparise, did Godzilla's reply help you out?
Sorry for the delayed response. Yes this worked!!