I have a Query Result that returns a column in time format like this
But when I try to create a visualization with Line charts it always show zero as you can see below:
How can I solve this visualization or else (and here comes a SQL question) how can I cast Minutes into Integer with sqlite sintax?
t
Thank you!
For your first question: what happens if you change the Y-axis scale to “Datetime”?
For your second question: can you clarify exactly what is the requirement?
00:38:35 == ?
@k4s1m, Thanks for your answer!
Well, I tried to change Y-axis scale to Datetime and it gets worse haha
About the second question, I mean 00:38:35 == 38.35 or 01:00:00 == 60 got it?
Thank you again!
