doitintl / bigquery-grafana

Google BigQuery Datasource Plugin for Grafana. (NO LONGER MAINTAINED)
https://www.doit-intl.com/labs/
MIT License
242 stars 76 forks source link

Legend separation based on query results (help needed) #338

Closed CristianAbrante closed 2 years ago

CristianAbrante commented 3 years ago

Feature Request

Is your feature request related to a problem? Please describe.

I am currently working on the development of a panel to monitor the error events generated in an API. These events are stored in a BigQuery database, and I use your plugin to connect Grafana to this database.

This API contains different paths, and I would like to count the number of events that have been generated by each of the different paths. If I use Prometheus for this purpose, it is quite simple because they have a legend tag that allows me to disaggregate the different paths by displaying them separately.

At the moment, the only workaround that I had came up with is to have a different query per path, that filters the desired path in the WHERE clause. This is obviously not maintainable, because the number of paths is really big, and probably will increase in the future.

Screenshot 2021-05-25 at 11 24 31

This screenshot shows the visualization that I want to achieve. This is done with Prometheus.

Screenshot 2021-05-25 at 11 24 56

This is the legend disagregation that it is currently available with the Prometheus plugin.

Describe the solution you'd like

The expected solution would be to have the option for presenting the information separated by the different results that are obtained with the query. In order to keep the consistency it would be nice that this feature can be added in the same way as Prometheus does it, with the legend tag.

ofir5300 commented 2 years ago

We are retiring the DoiT International BigQuery DataSource plugin for Grafana. We recommend that you migrate to the official Google BigQuery data source maintained by Grafana. In August 2022, we will cease all development and archive the GitHub project.

We are sorry for any inconvenience.