Merge Request Analytics - Fix throughput chart date range calculator
The date range information being calculated for the throughput chart graphql query is proving to be buggy. It appeared to be working fine for normal mid month days, but issues have arisen now on the last day of the month.
Example data being generated as at 2020-08-31
Sep_2019: mergeRequests(first: 0, mergedBefore: "2019-10-01", mergedAfter: "2019-10-01”)
Oct_2019: mergeRequests(first: 0, mergedBefore: "2019-12-01", mergedAfter: "2019-10-01")
Nov_2019: mergeRequests(first: 0, mergedBefore: "2019-12-01", mergedAfter: "2019-12-01")
Dec_2019: mergeRequests(first: 0, mergedBefore: "2020-01-01", mergedAfter: "2019-12-01")
Jan_2020: mergeRequests(first: 0, mergedBefore: "2020-03-01", mergedAfter: "2020-01-01")
Feb_2020: mergeRequests(first: 0, mergedBefore: "2020-03-01", mergedAfter: "2020-03-01")
Mar_2020: mergeRequests(first: 0, mergedBefore: "2020-05-01", mergedAfter: "2020-03-01")
Apr_2020: mergeRequests(first: 0, mergedBefore: "2020-05-01", mergedAfter: "2020-05-01")
May_2020: mergeRequests(first: 0, mergedBefore: "2020-07-01", mergedAfter: "2020-05-01")
Jun_2020: mergeRequests(first: 0, mergedBefore: "2020-07-01", mergedAfter: "2020-07-01")
Jul_2020: mergeRequests(first: 0, mergedBefore: "2020-08-01", mergedAfter: "2020-07-01")
Jul_2020: mergeRequests(first: 0, mergedBefore: "2020-08-01", mergedAfter: "2020-07-01")
Aug_2020: mergeRequests(first: 0, mergedBefore: "2020-10-01", mergedAfter: "2020-08-01")
Note the month of July is repeated twice, and some other months have incorrect mergedBefore
and mergedAfter
data.