Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here
Sep 30, 2020 03:52 AM
Phew! Lets’s see if I can explain this clearly.
Almost daily I go running.
I keep a log of distance and time and get a kick out of recording and graphing the results.
In Airtable, I’m using the chart app to chart several bits of data (DIstance, Time, s per km, s per mile, speed, etc.)
For the straight forward data (duration, time) Airtable has no problem making charts for me, they look great!
But, Airtable won’t let me make a chart with duration. No problem: the current workaround is as follows (example to calculate km/h):
This then gives speed and so far has been carefully charted every day without fail
But when I try to do something else (e.g. duration for fixed distance - mins per km) the fomula works for all previous entries but never the new ones!
Method:
I hope that’s clear - what have I missed that the field doesn’t calculate (and therefore won’t appear on the chart?)
I’m hoping to solve this soon as if I need to rebuild the whole thing then it won’t be too big!
Thanks in advance
Edd
Solved! Go to Solution.
Oct 07, 2020 07:27 AM
Simple answer: change the sec/Km field to a formula, and enter {min/Km}
as the formula. See what happens!
Oct 04, 2020 10:10 AM
Hi Edd,
Can you provide a screenshot of the base and the formula that’s not working?
Oct 06, 2020 12:28 AM
Sure!
Firstly, here’s the base:
,
And here’s the first instance of numbers not converting (copying, as the field is a duplicate) from mins to sec…
Let me know if you need more!
Oct 07, 2020 07:02 AM
I think I see what’s happening - let me know if this sounds right to you. The “Number” field type does not support formulas. In other words, if you switch from “Formula” to “Number”, it will stop calculating, and become a static field. If your intention is to convert mm:ss to seconds, you can do that with a formula!
Is your min/Km field is formatted in mm:ss? If yes, make the sec/Km field a formula field. Then just put the {min/Km}
field into your formula without any calculations. It should automatically show the units as seconds.
Oct 07, 2020 07:12 AM
I think I’ll have to re-read that 3 or 4 times, but will give it a go and report back - thanks! :thumbs_up:
Oct 07, 2020 07:27 AM
Simple answer: change the sec/Km field to a formula, and enter {min/Km}
as the formula. See what happens!
Oct 08, 2020 09:11 AM
Brillant - thanks!
I think I thought a chart couldn’t reference a formula - guess I was wrong!
Now if only I could make a chart showing minutes and seconds instead of just seconds - that yould be perfect!