Making the Y-axis time / duration based

Hey folks :wave: !

I'm wondering if there is a way to make Y-Axis time / duration based, I have a duration column in seconds, but I cannot format it properly and set it as time.

I used a trick by modifying the Y-axis coefficient multiplier to transform seconds into minutes, but I'm not satisfied with this, if you have a solution, let me know :smile: !

I'm using the latest metabase version (0.43.3) and I'm connected to BigQuery and getting the data using SQL.

I found a previous post talking about this issue, but no real solution invoked.

Thanks!

Hi @ar-ms
Metabase doesn't currently have a way of handling timeseries or strings in a great way on the Y-axis.
Those are usually used on the X-axis, whereas the Y-axis is a numeric value.
You cannot do "inline" casting, you'll have to do that in SQL.
Sounds like you're looking for this:
https://github.com/metabase/metabase/issues/8875 - upvote by clicking :+1: on the first post

1 Like

Hey!

I cheked that github issue previously, I thought maybe from that issue to now, there will be a solution to make the Y-Axis open to other type of data.

Anyway, thank you @flamber :+1: !