I am using telegraf exec plugin which sends the data cloud watch as
metric name : s3 measurements
dimension env= test, bucketname = test
fields file_status whose value can either of 0-4 values.
finally I want to value mapping 0 - grey, 1 green 2 amber etc.
I am trying to plot a graph which shows the file_status values over period of time.
I have tried timeseries graph
select file_status from measurement_name where env=test and bucketname=test with aggregation was mean, graph shows incorrect value and if remove this aggregator so no values are displayed in the graph
Can someone recommend me what is the appropriate graph to use in this scenario ?