I want to plot time series data which is just hour and minute. Can I plot it so that I can use just the time as the X-axis and then an aggregate of another metric on Y-axis?
My data is something like this:
TIME, PM
00:05, 25
01:34, 29
13:08, 39
16:45, 20
...
Is there a way to plot this? I couldn't find a way to directly feed the Time column to metabase and just plot it as it is .