Display Timespan vs cummulative activity

[Bob Senden]

I've got a large data set that has datetime stamps for the start of an activty, the end and the duration in minutes.

What I would like to display is the number of activities 'active' on the y-axis and the the timespan on the x-axis, both duration and time of day when they have been active. I've been targeting a normal line chart and I am thinking of calculating the volume under the line.

Attached is also an example of the data set and a rough sketch of what the visualisation has to look like.

Preferably I'd like to assign a colour for all the different categories.

The data is fetched from a database via SQL. I've tried to introduce a calculated column with 'DateDiff', but that function seems unavailable for my data set.

How do I achieve this in Spotfire

[Gaia Paolini]

From your sample data I don't see datetimes,

I see something like E.g.

StartTime=35:00.0 EndTime=44:00.0 Duration = 129

so presumably some information got lost and the endtime has a number of hours added to it that is not shown.

 

Assuming the complete dates are available, maybe this answer can help (using a TERR data function):

https://community.spotfire.com/questions/creating-daily-timeline-show-numbe...