search

ddurieux / glpi_app_grafana

GNU Affero General Public License v3.0
23 stars 13 forks source link

Use Query Variable to calculate field #50

Open jefferson0904 opened 5 years ago

jefferson0904 commented 5 years ago

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?

ddurieux commented 5 years ago

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