Grouping date field in table view

rparise Member

July 2016 in Charting

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

 

 

 

0

Welcome!

It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.

Sign In

Best Answer

• 

  Godzilla Contributor

  July 2016 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'

  0

Answers

• 

  rparise Member

  July 2016

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

   

  Thanks,

   

  Rob

  0
• 

  Godzilla Contributor

  July 2016 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'

  0
• 

  kshah008 Contributor

  July 2016

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

  0
• 

  rparise Member

  July 2016

  Sorry for the delayed response.  Yes this worked!!

   

  Thanks,

   

  Rob

  0

This discussion has been closed.