Skip to main content

Unable to chart duration data

  • August 2, 2018
  • 2 replies
  • 19 views

Karlstens
Forum|alt.badge.img+24

I can’t seem to chart any duration data. Is this a limitation or am I doing something wrong?

Example of the same data I put into Google Sheets.

https://imgur.com/veD97Z0

2 replies

Forum|alt.badge.img+5
  • Inspiring
  • August 5, 2018

No, it appears the Chart Block does not accept a duration as a chartable field type. You can convert the durations into decimal numbers and chart them. Internally, durations are seconds, so you would create a formula field with the formula

{Oval}/60

That will give you decimal minutes, which can be charted.


Forum|alt.badge.img
  • New Participant
  • June 10, 2019

Is this a feature that Airtable will be adding in the future?