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
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.
I am trying to relate completion date by time using the Hour and Time per day as a Y-axis, with the X-axis being the day. Using this I would like to graph across time when a specific Job completed, we have a field called update time that I can format as a 24 hour Hour:Minute:Second. Taking only one per day I’d like to be able to compare the update times with a line graph.
Problem is the Y-axis doesn’t seem able to display 24 hour time, it is only showing me linear measurements.
Any way to di…
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 on the first post
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