How to create a timechart with a time field?

[Marco_Develops]

I'm trying to make a time chart where it uses the time value specified in my table.  Rather than the default _time value.

Currently I'm trying something like this:

base search
|eval Failures = if(STATUS ="Failed",1,0)
| timechart sum(Failures) by TIME

DATE	TIME	SYSTEM	Failures
03/01/2022	12:00	Development	10
03/01/2022	13:00	Development	2
04/01/2022	15:00	Development	3
05/01/2022	18:00	Development	8

 Any suggestions help :-).

Thank you,

Marco

[ITWhisperer · Accepted solution]

base search
| eval Failures = if(STATUS ="Failed",1,0)
| chart sum(Failures) by TIME