I'm getting crazy, I have a google sheet with...

(Haroldo) #1

I’m getting crazy, I have a google sheet with the first column as date, formatted as Number

Date I have another column with a number of product sold. I’m just doing a chart (histogram with Group aggregated "product old) or Aggregated

donuts I Always get a chart with every single date on x axis, I want it aggregated by date by month, not every single date I have in the sheet. I review my date data and look ok to me. in the google sheet date and #Sm sold are the 2 main data to plot.

Please any input ?

(Praveen Seshadri (AppSheet)) #2

Add a virtual column Month with app formula MONTH([DateColumn])

Then set up your histogram chart to pick the Month column.