I have two columns with time datatype, from those columns I create a costume column that takes diff of between columns. But, when I tried to plot the result Metabase unable to display it, I supposed because of the datatype. If there is any way to overcome it, I'll be appreciated!
Hi @amethyst
Please post “Diagnostic Info” from Admin > Troubleshooting.
I’m not sure what is being returned, but try posting the response by looking in the browser developer Network-tab, when running the query.
Actually my question is quite simple “Can I plot the interval time data type that I got from some costum column end_time - start_time? I’m unable to plot it (see my images above on question)”
@amethyst You would need to return an integer instead of interval, which you can do like this: EXTRACT(epoch FROM "end_time"-"start_time")
But that’s only possible in SQL - there’s an issue open about adding interval support in Metabase: https://github.com/metabase/metabase/issues/2656 - upvote by clicking on the first post