Use a Line Chart to display scores over time

0
Hello,  I am having some difficulties in creating the logic for my line chart. I want to show an average or total score over time. I have several attempts but the following 2 are the two approaches that were the closest to being on the right track. I feel that my logic might need to have a separate loop to iterate over each month and average each individually.    This is the outcome of my first attempt (the problem with this is that it seems to be plotting every score over time): This is the outcome of my second attempt:   This is not correct either and I am after something very much in-between!   What I did for ATTEMPT 1: For the first graph, I used mainly 2 entities:   This is the microflow I used:   In the create ParsedDateHeld variable, this is a date and time and the value is: parseDateTime($IteratorReview/DateHeld, 'yyyy-MM-dd'). This is what is in the create ChartPointObject:   Then these are the values for the line chart:     ATTEMPT 2: I then tried to group the values by month together and find an average and so I then changed my microflow and added some more entities. In this attempt I still use JiraData, but now also use ChartPlot and MonthHolder: This is the microflow I used here:   Breaking this microflow down step by step:   Retrieve objects from JiraData:   2) Create empty list:   3) Create a separate empty list:   4) In a loop that iterates over ReviewList:   5) Create another variable:   6) Find:   7) Check if month has already been processed:     8) Create MonthStart variable:     9) Create MonthEnd variable:   10) Filter ReviewList:   11) Get average OTIF:   12) Create ChartPlot object:   13) Add $ThisMonthChartPoint to ChartPointList. 14) Create MonthHolder object:   15) Add $NewMonthKeyHolder to ProcessedMonths List. 16) End microflow with return of $ChartPointList.   Then in chart:       I would be very grateful if someone has the correct solution for working out an average or total score per month over time. I have a feeling that I might need to create a separate entity for each month and create a different loop to iterate over each month and grab an average for each but I am not sure how to go about this.    Thank you very much in advance!                 
asked
0 answers