Possible to increment Range in Google sheet datasource via variable?

spraytek · February 3, 2022, 2:09pm

I’m pulling some data from a (poorly) preformatted Google sheet and would like to be able to increment the cell reference in the query’s range by a variable. For example, for server1 I have a stat panel pulling the data from cell E17. The equivalent data for server2 is in E27. If setup variables for server1: 0 and server2:10 can I increment E17+$variable. Pretty sure the range field is treated as a string so I don’t think so but wanted confirmation.

P4P_datasource

Running v8.3.3

mattabrams · February 7, 2022, 11:53pm

Hey there @spraytek and welcome back to the forum.

Looks like the Google Sheets Data Source Plugin supports template variables for ID and Range:

github.com

grafana/google-sheets-datasource/blob/main/src/DataSource.ts#L14-L22

      
        
            // Support template variables for spreadsheet and range
            applyTemplateVariables(query: SheetsQuery, scopedVars: ScopedVars) {
              const templateSrv = getTemplateSrv();
              return {
                ...query,
                spreadsheet: templateSrv.replace(query.spreadsheet, scopedVars),
                range: query.range ? templateSrv.replace(query.range, scopedVars) : '',
              };
            }