Google Earth Engine: Calculating Monthly average NDVI for each year and getting the date formatted correctly

Question

I'm trying to create a chart that is a monthly average for each year from a 22-year MODIS NDVI image collection. I have a number of steps to complete. This is one of them. The closest answer I could find is from the solution in this post:

Google Earth Engine: calculating and plotting monthly average NDVI for a region from MODIS data

The code at the end of the above link uses xProperty: 'system:index' giving the x axis as numbers from 0 onwards. How can I use the year (y) and month (m to create a xProperty that is formatted as a date?

 //Define chart parameters
var chartParam = {
 title: 'Monthly average NDVI',
  hAxis: {title: 'Time'},
  vAxis: {title: 'Average NDVI'},
  };
//Plot the chart
var chart = ui.Chart.image.seriesByRegion({
  imageCollection: yrMo,
  regions: ukr,
  reducer: ee.Reducer.mean(),
  scale: 500,
   xProperty: 'system:index',
 seriesProperty: 'PROJECT'
    });
    //Print chart to console
    print(chart.setOptions(chartParam));

score 0 · Accepted Answer · answered Aug 22 '23 at 13:57

Instead of setting month and year in the mapped function, set a combined date parameter, and specify that as the x-axis:

var yrMo = ee.ImageCollection.fromImages(
  years.map(function (y) {
        return months.map(function (m) {
            return collection
              .filter(ee.Filter.calendarRange(y, y, 'year'))
              .filter(ee.Filter.calendarRange(m, m, 'month'))
              .mean()
              .set('date',ee.Date.fromYMD(y, m, 1).format("YYYY/MM"))
    });
}).flatten());

...
//Plot the chart
var chart = ui.Chart.image.seriesByRegion({
  imageCollection: yrMo,
  regions: ukr,
  reducer: ee.Reducer.mean(),
  scale: 500,
  xProperty: 'date',
  seriesProperty: 'PROJECT'
});

Google Earth Engine: Calculating Monthly average NDVI for each year and getting the date formatted correctly

1 Answers1