Analyze Events With Durations

Dear All

Thanks in advance for any suggestions. I just started to use spotfire and barelly learn to insert graphs :) therefore would like to ask support with my struggles.

I have failure events with durations (start and end date) and given deferet volume for that period. Like follow:

Evnt ID Start End Asset Facility Well Type

Reason
 

Comment

Volume

00001 03/02/2017 10/02/2017 ABC CDE XYZ Type1 Reason1 ffefsgfh 23
00002 27/01/2017 03/02/2017 ABC GEA TA1 Type10 Reason3 fdsagtrtwyh 13

I would like to learn how to calculate and display it in time trend.. so i  can summerize total loss in asset or facility in given month or quarter as well as display time trends on graph where x axis is time and y axis is volumes?

Thanks

Dorota

Login