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 ?
Add a virtual column Month with app formula MONTH([DateColumn])
Then set up your histogram chart to pick the Month column.
User | Count |
---|---|
43 | |
30 | |
24 | |
23 | |
13 |