aggr(),rank(),if()

[mert1917]

Hi all:),

I have a problem  could you  help to me please.

I have 3 columns(Date,Hours,Count(I3) )

how can i take sum of up to this hour yesterday?

How do I get 50 value?

thank you so much..

Date ,hours, Count(I3), target 
2019.02.15, 13, 20, 50 (Now)
2019.02.15, 12, 19,  
2019.02.15, 11, 17,  
2019.02.15, 10, 16,  
2019.02.15, 9, 15,  
2019.02.14, 17, 55,  
2019.02.14, 16, 26,  
2019.02.14, 15, 15,  
2019.02.14, 14 45,  
2019.02.14, 13, 10, 50 
2019.02.14, 12, 10,  
2019.02.14, 11, 10,  
2019.02.14, 10, 10,  
2019.02.14, 9, 10,  

[Wlad_Masi]

What is the logic that should be used to calculate the sum?
Do you need it calculates in the script or it could be calculated in the visualization layer?