use last date of period when using period selector in datatable visualization (#16638)

Co-authored-by: sgiehl <stefan@matomo.org>

1 files changed, 6 insertions, 0 deletions

diff --git a/plugins/CoreHome/javascripts/dataTable.js b/plugins/CoreHome/javascripts/dataTable.js
index db7f781bf3..b90e444d23 100644
--- a/plugins/CoreHome/javascripts/dataTable.js
+++ b/plugins/CoreHome/javascripts/dataTable.js
@@ -720,7 +720,13 @@ $.extend(DataTable.prototype, UIControl.prototype, {
                 return;
             }
 
+            var piwikPeriods = piwikHelper.getAngularDependency('piwikPeriods');
+            var currentPeriod = piwikPeriods.parse(self.param['period'], self.param['date']);
+            var endDateOfPeriod = currentPeriod.getDateRange()[1];
+            endDateOfPeriod = piwikPeriods.format(endDateOfPeriod);
+
             self.param['period'] = period;
+            self.param['date'] = endDateOfPeriod;
             self.reloadAjaxDataTable();
         });
     },