Organize Calculated Fields

Grafana Dashboards
1
  • What Grafana version and what operating system are you using?

Grafana v9.2.6

  • What are you trying to achieve?

I have Grafana connected to Opensearch data source. I am getting data from an index.

image
image1491×227 13.3 KB

I have a column with a unix epoch type:

image

I want to convert this into datetime.

The thing is that I don’t have a way to execute a query, I’d be able to convert the type or multiply by 1000.

What I found is create an add field from calculation transform:

image
image802×248 13.6 KB

And add an override type:

image

The result is the following one:

image

  • Is it possible to hide the column Start time where I’m doing the operation?
  • I can’t organize the calculated fields, there’s no way to move them to another position even editing manually the JSON model. Can I use another alternative?

I took a look to different posts but I couldn’t find something that can be done without editing a SQL query.

Thank you very much.