We have a situation where a “project” can be submitted unlimited times by a user. On each project submission, it is accompanied with a certain numerical “amount”.
What I need to do is aggregate the total sum of all the latest amount values for a project by each company.
i.e. Let’s say we have John and Mary from the company J&M and they are working on the projects ABC and DEF. John submits project ABC 2 times, the first time the amount is 50, the second time it is 75 and DEF 1 time at 150. Mary submits DEF once with the amount 100 AFTER John’s submission to DEF. I need to add 100 (the latest submission to DEF) and 75 (the latest submission to ABC) to get 175 and show that on a dashboard.
I was able to easily aggregate ALL submissions (which would end up giving me 100 + 75 + 150 + 50 = 375) but couldn’t find a way to just get just the latest submission per project. Is there a way to do this? I thought about using JQL but couldn’t find a way to add that to the dashboards so I didn’t put much time into it.