I am having trouble figuring this one out. We have a dashboard that we normally update twice a month. I am trying to show, through a line chart, the progress we make on the outstanding volume of transaction we need to process. My problem is that for each month, the values are summarized therefore, at the end of the month, the result on the chart is the combination of the outstanding volume at the 15th and the 30th. I only what the chart to take in account the last value entered for the month.
Results on dashboard
September 15 2021
500 (which is the correct value of outstanding item at the time)
September 30 2021
1100 (which is not the correct value we want to represent at the end of the month) We would like to show that the outstanding volume at the end of september is 600)