-
What Grafana version and what operating system are you using?
Grafana 9.5.14 in AWS ECS container -
What are you trying to achieve?
I need to calculate the difference time between two records. These records represent the date on which the same version of the same application was deployed in the testing, pre-production and production environments.
I need to:
- Calculate the time differences between testing → pre-production and create a new column with the result
- Calculate the time differences between pre-production → production and create a new column with the result
The datasource is InfluxDB 2.7.0, im using InfluxQL to write the sentences and this is the query:
SELECT “status” FROM “default”.“jenkins_job” WHERE (“estado”::tag = ‘0’ AND “ambiente”::tag != ‘DESA’ AND “app_version”::tag =~ /^$APPVERSION$/ AND “app_name”::tag =~ /^$APPNAME$/) AND $timeFilter GROUP BY “ambiente”::tag, “app_name”::tag, “app_version”::tag
