Hi Folks, I’ve just added an elasticsearch source to our grafana instance (data coming from https://slurm.schedmd.com/elasticsearch.html), and am trying to provide a ‘drill down’ link to a second dashboard. I’m able to pass the jobID easily, but when passing the @start @end timestamps over to set the ‘from=XXX&to=YYY’ fields I can’t work out how to re-evaluate them as epoch seconds.
Is this possible, or is there a better way to pass the variables?
I’m setting the URL link as
…/job-profile?orgId=1&var-jobid={__cell:raw}&from={__cell_9}&to=${__cell_10}
but that’s coming over as …/job-profile?orgId=1&var-jobid=9561&from=2020-02-25T12:58:04&to=2020-02-25T20:58:05
Any suggestions? sadly the raw data is passed into elastic as a datestring:
{"_index":“slurm”,"_type":“jobcomp”,"_id":“1eKsYHABsJ1UsqDnc9N3”,"_score":1.0,"_source":{“jobid”:9519,“username”:“aelwell”,“user_id”:20701,“groupname”:“aelwell”,“group_id”:20701,"@start":“2020-02-20T03:37:56”,"@end":“2020-02-20T03:37:58”,“elapsed”:2,“partition”:“workq”,“alloc_node”:“chaos-1-eth5”,“nodes”:“nid00035”,“total_cpus”:40,“total_nodes”:1,“derived_ec”:“0:0”,“exit_code”:“1:0”,“state”:“FAILED”,“cpu_hours”:0.022222,“pack_job_id”:0,“pack_job_offset”:0,"@submit":“2020-02-20T03:36:04”,"@eligible":“2020-02-20T03:36:04”,“queue_wait”:112,“work_dir”:"/home/aelwell",“cluster”:“chaos”,“qos”:“normal”,“ntasks”:0,“ntasks_per_node”:0,“cpus_per_task”:1,“time_limit”:3600,“job_name”:“hostname”,“account”:“pawsey0001”,“parent_accounts”:"/root/pawsey0001/pawsey0001"}},
Many thanks
Andrew