glpi_app_grafana icon indicating copy to clipboard operation
glpi_app_grafana copied to clipboard

Use Query Variable to calculate field

Open jefferson0904 opened this issue 5 years ago • 1 comments

Is there a way to use variables to reference a query to calculate a field. Here it is what I want to do:

I Have a query returning the total number of problems. Query A I Have a second query returning the total number of solved problems. Query B

I want to show the percentage of problems solved, using Query B e Query A to calculate it.

Is there a way to do that?

jefferson0904 avatar Jun 12 '19 12:06 jefferson0904

not possible, the only possibility is to use mysql datasource (so not this plugin) and make with in the SQL query. I had something like this to do and I do it this MySQL datasource. Code it in this plugin will be very complex, so a solution exist with MySQL datasource.

Perhaps it can do it inside, but only possible with a quotation, not possible on my little free time

ddurieux avatar Jun 12 '19 13:06 ddurieux