# Kibana Cavas empty datatable **URL:** \ **Category:** Kibana\ **Tags:** canvas\ **Created:** [October 19, 2022, 1:05pm UTC](https://discuss.elastic.co/t/kibana-cavas-empty-datatable/317001 "2022-10-19T13:05:33Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![Zdeno\_Liska](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/zdeno_liska/32/83511_2.png) [@Zdeno\_Liska](https://discuss.elastic.co/u/Zdeno_Liska)\ **Post date:** [October 19, 2022, 1:05pm UTC](https://discuss.elastic.co/t/kibana-cavas-empty-datatable/317001/1 "2022-10-19T13:05:33Z")
Hi, I am facing strange issue. I have created canvas report like below. Anyway, I am getting random icons with exclamation marks, but when I reload data with Alt+R, they randomly disapear and reapear on different metric., after several reloads everything is OK but nex one again causes this issue. Am I missing something?? ![image](https://us1.discourse-cdn.com/elastic/original/3X/8/e/8edf24f9adb4b7854ffe5fac278f4e2b9263b5e7.png) ---
**Author:** ![drewdaemon](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/drewdaemon/32/97779_2.png) [@drewdaemon](https://discuss.elastic.co/u/drewdaemon)\ **Post date:** [October 19, 2022, 3:17pm UTC](https://discuss.elastic.co/t/kibana-cavas-empty-datatable/317001/2 "2022-10-19T15:17:45Z")
Hi @Zdeno_Liska — Could you share specifically how you created those numbers on your workpad (which canvas element did you use, or is this a custom expression)? ---
**Author:** ![Zdeno\_Liska](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/zdeno_liska/32/83511_2.png) [@Zdeno\_Liska](https://discuss.elastic.co/u/Zdeno_Liska)\ **Post date:** [October 20, 2022, 6:58am UTC](https://discuss.elastic.co/t/kibana-cavas-empty-datatable/317001/3 "2022-10-20T06:58:11Z")
Hi, thanks for reply: here is original code causing issue: ```auto kibana | selectFilter group="by-device" group="by-date1" ungrouped=true | essql query="SELECT AVG(\"P1-C01-Temp\") as avg, Round(STDDEV_SAMP(\"P1-C01-Temp\"),2) as std_samp,Round(STDDEV_POP(\"P1-C01-Temp\"),2) as std_pop, prodTimeSpan ts FROM \"metrics-factory*\" WHERE position='RC1' GROUP BY prodTimeSpan order by avg DESC LIMIT 1" | math "ts" | metric "" metricFont={font align="center" color="#1785b0" family="'Open Sans', Helvetica, Arial, sans-serif" italic=false size=14 underline=false weight="bold"} labelFont={font size=14 family="'Open Sans', Helvetica, Arial, sans-serif" color="#000000" align="center"} metricFormat="0,0" | render ``` and here is update that seems as a solution for me that I found after I posted this question: kibana ```auto kibana | selectFilter group="by-device" group="by-date1" ungrouped=true | essql query="SELECT AVG(\"P1-C01-Temp\") as avg, Round(STDDEV_SAMP(\"P1-C01-Temp\"),2) as std_samp,Round(STDDEV_POP(\"P1-C01-Temp\"),2) as std_pop, prodTimeSpan ts FROM \"metrics-factory*\" WHERE position='RC1' GROUP BY prodTimeSpan order by avg DESC LIMIT 1" | if {rowCount | eq 0} then=0 else={math "ts"} | metric "" metricFont={font align="center" color="#1785b0" family="'Open Sans', Helvetica, Arial, sans-serif" italic=false size=14 underline=false weight="bold"} labelFont={font size=14 family="'Open Sans', Helvetica, Arial, sans-serif" color="#000000" align="center"} metricFormat="0,0" | render ``` anyway, is there a possibility to perform some query only once if it is commonfor multiple elements and then somehow refer to result of this query? Concept of variables seems to be out of options as there is no defined order of expressions evaluations. I am just curious ---
**Author:** ![drewdaemon](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/drewdaemon/32/97779_2.png) [@drewdaemon](https://discuss.elastic.co/u/drewdaemon)\ **Post date:** [October 21, 2022, 10:18pm UTC](https://discuss.elastic.co/t/kibana-cavas-empty-datatable/317001/4 "2022-10-21T22:18:34Z")
> is there a possibility to perform some query only once if it is commonfor multiple elements and then somehow refer to result of this query? We don't have the concept of elements referencing each other in Canvas. It kind of reminds me of [this issue](https://github.com/elastic/kibana/issues/134706), but I don't know of any plans to add this as something you could use when building a Canvas workpad. cc: @devon.thomson ---
**Author:** ![devon.thomson](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/devon.thomson/32/85468_2.png) [@devon.thomson](https://discuss.elastic.co/u/devon.thomson)\ **Post date:** [October 24, 2022, 1:46pm UTC](https://discuss.elastic.co/t/kibana-cavas-empty-datatable/317001/5 "2022-10-24T13:46:48Z")
Hi @Zdeno_Liska, I can confirm what @drewdaemon said, there is currently no way to store and re-use partial query results in a Canvas workpad. ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [November 20, 2022, 1:02am UTC](https://discuss.elastic.co/t/kibana-cavas-empty-datatable/317001/6 "2022-11-20T01:02:48Z")
---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [December 17, 2022, 9:53pm UTC](https://discuss.elastic.co/t/kibana-cavas-empty-datatable/317001/7 "2022-12-17T21:53:54Z")
---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [January 14, 2023, 6:10pm UTC](https://discuss.elastic.co/t/kibana-cavas-empty-datatable/317001/8 "2023-01-14T18:10:20Z")
---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [February 11, 2023, 6:10pm UTC](https://discuss.elastic.co/t/kibana-cavas-empty-datatable/317001/9 "2023-02-11T18:10:45Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.