Unable to plot the graph for field values 0-4

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 ?

1 Like

Hi ,

Welcome to the :grafana: community forum !!

  • Please review the submission template and include more details (you already provided some but needed a bit more and best will be to attach a screenshot):
  • What Grafana version and what operating system are you using?
  • What is your datasource?
  • What are you trying to achieve?
  • How are you trying to achieve it?
  • What happened?
  • What did you expect to happen?
  • Can you copy/paste the configuration(s) that you are having problems with?
  • Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.
  • Did you follow any online instructions? If so, what is the URL?