grafana/google-sheets-datasource

Support for multiple selects in dashboard variable

Rybue opened this issue · 2 comments

Rybue commented

Hi! Thank you for great plugin.
I was wondering if it would be possible to add support for repeat panels?

Let me exlpain issue that I have.

  1. I added named ranges to Google Spreadsheet, named ike this - Sellars, Phobos
  2. I added dashboard variable that contain the same values and called instance
  3. I created few panels and use $instance variable to create dynamic graphs
    image
  4. When I select one host from dropdown menu, everything works great:
    image
  5. When I select multiple instances - data not being fetched
    image

Error message from the panel:

googleapi: Error 400: Unable to parse range: Status GPU's!{Sellars,Phobos}, badRequest

I would be happy to provide more info if needed.
Maybe there is some workaround for this?

Best regards

AdamCarballo commented

I'm having the same issue. Couldn't find a way to have multiple variables selected without getting bad requests.

  • 👍1
aarondenney commented

Same issue. It has something to do with the way its parsing the selected variable. Its returning the GLOB instead of the single for the specific panel.