Avg Time (Duration) Y-Axis


New user to Spotfire, I'm struggling to find a way to display the average time on the y-axis with a date range on the x-axis.

The only options presented to me when entering the duration column to the y-axis are:

  • Count
  • UniqueCount
  • CountBig
  • Range

I was looking for the simple option of Average to show a simple line graph or bar chart of the average duration per day or month or week etc.

Anyone else come across this same issue?

Many Thanks


1 Comment

First thought is it must be a data type restriction - what data type is the duration column? It has to be numeric for the Avg option.

janine.rawnsley - Oct 24, 2016 - 8:54am ::
+ Add a Comment

(2) Answers