Hello ! My data is in this form : _time (dd/mm/yyyy), NbRisk, SubProject, GlobalProject 02/05/2021, 10 , SubProject1, Project 1 01/05/2021, 4 , SubProject2 , Project 1 01/05/2021, 5 , SubProject3 , Project 1 10/04/2021, 80 , SubProject1 , Project 1 09/04/2021, 32 , SubProject2 , Project 1 09/04/2021, 12 , SubProject3 , Project 1 03/05/2021, 11 , SubProject1, Project 2 01/05/2021, 40 , SubProject2 , Project 2 15/04/2021, 60 , SubProject3 , Project 2 09/04/2021, 2 , SubProject3 , Project 2 08/04/2021, 4 , SubProject2 , Project 2 05/04/2021, 3 , SubProject1 , Project 2 I would like to calculate the last "NbRisk" by "SubProject" and sum it by all day and by "GlobalProject" with timechart to see the trend. For example : 07/05/2021, Project 1, 19 07/05/2021, Project 2, 111 06/05/2021, Project 1, 19 06/05/2021, Project 2, 111 | | 01/05/2021,Project 1, 89 01/05/2021,Project 2, 103 | | 10/04/2021, Project 1, 124 10/04/2021, Project 2, 9 I have tried a lot of thing like streamstats/addtotals without success .. Thanks for ur help !
... View more