Time Series Grafana

I have following as DB with following Tags and Fields
SHOW TAG KEYS
name: http
tagKey

Country
dbTag
endpointTag
pingTag
status
statusCode
url

SHOW TAG VALUES WITH KEY = “dbTag”
name: http
key value


dbTag f29fabe637a472bf5222b12a0bc5df77
dbTag fad58de7366495db4650cfefac2fcd61

SHOW TAG VALUES WITH KEY = “pingTag”
name: http
key value


pingTag 068ea8c10915701e0b416e67d5bfc70f

SHOW TAG VALUES ON “wss” WITH KEY IN (“dbTag”,“status”)
name: http
key value


dbTag f29fabe637a472bf5222b12a0bc5df77
dbTag fad58de7366495db4650cfefac2fcd61
status Down
status Up

SHOW FIELD KEYS
name: http
fieldKey fieldType


db string
endpoint string
pingName string

I wanted to sent alerts when statusCode is 0. Hence I have created query for timeseries graph. but no luck still now.
Now I wanted to plot statusCode on Timeseries graph ( Y axis as statusCode and X axis as time). I tried in many ways but I am not able to plot statusCode. Let me know what I am missing.