How to create a range or interval as a condition for summing amount

[#1]

Please I have a question ?  I have two fields, one  is called Loss and the second one is

time of detection.

First field contains amounts of loss and second contains days of how long it take to detect.

I need to create intervals from the time of detection field and based on the selected interval to sum the corresponding loss from the Loss field ?

[maxgro]

you can use a calculated dimension with the class function (the 2nd parameter is the class interval, in my example 5); for different interval you can use nested if instead of class

t:

load * inline [

loss, time

100,3

110,4

120,5

90,1

45,20

70,15

56,12

];