Adding a time field or transforming time to match selected time

Grafana Dashboards
1
  • What Grafana version and what operating system are you using?
    Grafana v11.3.2
  • What are you trying to achieve?
    i would like to find a way to line an inserted CSV table using the infinity query up with the chosen date and time
  • How are you trying to achieve it?
    I have tried multiple ways all have flunked. currently i have it starting at midnight on the current day but that doe not allow me to line it up with the current real time data flow. the goal is to compare our actual recipe with what is happening in real time. my current idea is instead of trying to line it up automatically because i feel that is impossible after trial and error, i would like to just have it start at the beginning of the time period and the user can zoom in to the batch they want to see and the table line be layered on top. maybe there is a way to add a new time column connected to the selected time? it also is for some reason coloring the tables where it is located but that is not the main issue.
    Screenshot 2025-04-17 112738
    Screenshot 2025-04-17 1127381380×268 19.1 KB

Here is a sample of my table:

Time,Molases_flow_set_point,yeast_heat_generated_Kj,yeast_heat_generated_Kw, CALC_MEMP_SM_feed_temp_sp,Fermenter_Temp_sp,mol_temp_heat_generated_Kj,mol_temp_heat_generated_Kw,total_heat_generated_kw,batch
00:01:00,22.78,45418.28585,756.9714308,75,33,289324.9703,4822.082838,5579.054269,705
00:02:00,22.78,45418.28585,756.9714308,75,33,289324.9703,4822.082838,5579.054269,705
00:03:00,22.78,45418.28585,756.9714308,75,33,289324.9703,4822.082838,5579.054269,705
00:04:00,22.78,45418.28585,756.9714308,75,33,289324.9703,4822.082838,5579.054269,705
00:05:00,22.78,45418.28585,756.9714308,75,33,289324.9703,4822.082838,5579.054269,705
00:06:00,22.78,45418.28585,756.9714308,75,33,289324.9703,4822.082838,5579.054269,705
00:07:00,22.78,45418.28585,756.9714308,75,33,289324.9703,4822.082838,5579.054269,705
00:08:00,22.78,45418.28585,756.9714308,75,33,289324.9703,4822.082838,5579.054269,705
00:09:00,22.78,45418.28585,756.9714308,75,33,289324.9703,4822.082838,5579.054269,705
00:10:00,23.3,46455.05093,774.2508489,75,33,295929.4033,4932.156722,5706.407571,705
00:11:00,23.3,46455.05093,774.2508489,75,33,295929.4033,4932.156722,5706.407571,705
2

your time column only has time but not date, is this by design? it might be difficult to use date time filter on those

3

I have tried both. at least this way it shows up in the most current date

4

So all of those time values are for today only?

5

it will jump to the most recent day starting at midnight currently