I am developing a report in Canvas currently and several elements use the same field within their esql queries. As it is intended that this workpad would be cloned it would be really useful to use a variable in the query
Currently I have
essql query="SELECT HISTOGRAM(isotimestamp, INTERVAL 1 DAY) AS day, COUNT(result) AS tot, result AS res FROM \"MyIndex*\" WHERE account_id='DADCCUT3D44UOUCE9VDU' AND result='success' GROUP BY day, res"
I would prefer
But I cannot get this to work. As the report queries multiple indexes for multiple elements it would be beneficial to be able to update this in one spot, rather than risk missing the change on one element.