Using variables in influx query

InfluxDB 1 Chronograf
,
1

Hello,

I have a quick question about querying the influx DB. I’ve assigned my database and retention policy as variables at the top of my script (as generated when i use chronograf to create my tick scripts) and was wondering if it is possible to insert my DB and RP variables into my query?

TICK script novice go easy please

var db = 'telegraf'
var rp = 'autogen'
//Store the alerts
var outputDB = 'chronograf'
var outputRP = 'autogen'

var groupBy = ['host', 'time']
var period = 60s
var every = 30s

var threshold = 10.0

var data = batch 
    |query('''SELECT mean(tcp_established) AS stat FROM /^$db$/./$rp$/."netstat";  ''')
    .period(period)
    .every(every)
    .groupBy(groupBy)

When i try to define i get an error message:

found ‘.’ , expected ; at line 1 character 50 (line one is a commented out line with the script/alert name.

So, my question is as follows: am i able to use the queries like this? If I’m defining my DB and RP at the start of the script, it would make sense to be able to reference it in my query (to me at least) right? And if so, how would i go about doing so?

I’ve tried to follow this github page

2

Hi, I am also facing same problem, can you share its solution if its solved?