Grafana custom 'Time' field for time series graph

[maxluong2]

I am using InfluxDB and I have tables like this…

 
Time                 | Date               | Logs
----------------------------------------------
2021-08-24 14:26:522 | 2021-06-01 17:00:00| 10
2021-08-24 14:26:522 | 2021-06-01 18:00:00| 45
2021-08-24 14:26:522 | 2021-06-01 19:00:00| 43
2021-08-24 14:26:522 | 2021-06-01 20:00:00| 76
2021-08-24 14:26:522 | 2021-06-01 21:00:00| 23

I need to create a Time-series graph for alerting purposes. Choosing ‘Time-series’ in the query result in this:

Time                 | tablename.Logs Count
----------------------------
2021-08-24 14:26:522 | 10
2021-08-24 14:26:522 | 45
2021-08-24 14:26:522 | 43
2021-08-24 14:26:522 | 76
2021-08-24 14:26:522 | 23

I need Date as ‘Time’. feel like there is a simple solution to my problem here. Graphing the above will display all logs within the miniscule ‘2021-08-24 14:26:522’ timeframe, but obviously I’d like Date to be used as the “Time”. I cannot rename Date to “Time” in ‘Transform’ tab.

[mattabrams]

Hi @maxluong2 and welcome to the forum

The best way for the community to help you is to share your raw, unformatted data using the inspect drawer like this.