# Canvas report for Log files Ubuntu **URL:** \ **Category:** Kibana\ **Created:** [December 13, 2018, 4:56am UTC](https://discuss.elastic.co/t/canvas-report-for-log-files-ubuntu/160668 "2018-12-13T04:56:29Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Siddharth\_Rai](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/siddharth_rai/32/38770_2.png) [@Siddharth\_Rai](https://discuss.elastic.co/u/Siddharth_Rai)\ **Post date:** [December 13, 2018, 4:56am UTC](https://discuss.elastic.co/t/canvas-report-for-log-files-ubuntu/160668/1 "2018-12-13T04:56:29Z")
Problem Statement: a) generate a Canvas report (presentable) out of CMDB data in a spreadsheet. I tried to install metricbeat, elasticsearch and Kibana From Kibana, discovery option I am trying to upload data as csv . But I am not able to connect it to Canvas for a WoW report. Sincerely, Siddharth Rai ---
**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\ **Post date:** [December 13, 2018, 10:23pm UTC](https://discuss.elastic.co/t/canvas-report-for-log-files-ubuntu/160668/2 "2018-12-13T22:23:00Z")
> [@Siddharth\_Rai](#): > > From Kibana, discovery option I am trying to upload data as csv . But I am not able to connect it to Canvas for a WoW report. It's not really clear what your problem is unfortunately. Do you have data in Kibana or are you trying to import it? ---
**Author:** ![Siddharth\_Rai](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/siddharth_rai/32/38770_2.png) [@Siddharth\_Rai](https://discuss.elastic.co/u/Siddharth_Rai)\ **Post date:** [December 13, 2018, 11:38pm UTC](https://discuss.elastic.co/t/canvas-report-for-log-files-ubuntu/160668/3 "2018-12-13T23:38:47Z")
I have uploaded data in Kibana in csv format. I did manage to import as well. I can see name of the instance in Canvas as well, I am struggling with query part: select all fields from data\_uploaded\_in\_kibana where field1 like %POE% order by date. Select \* from from data\_uploaded\_in\_kibana where field1 like %POE% did work for me, but i am looking for more than that. ---
**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\ **Post date:** [December 13, 2018, 11:47pm UTC](https://discuss.elastic.co/t/canvas-report-for-log-files-ubuntu/160668/4 "2018-12-13T23:47:26Z")
> [@Siddharth\_Rai](#): > > i am looking for more than that. Unless you can communicate what you are looking for, it's quite difficult to help. ---
**Author:** ![Siddharth\_Rai](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/siddharth_rai/32/38770_2.png) [@Siddharth\_Rai](https://discuss.elastic.co/u/Siddharth_Rai)\ **Post date:** [December 14, 2018, 12:03am UTC](https://discuss.elastic.co/t/canvas-report-for-log-files-ubuntu/160668/5 "2018-12-14T00:03:43Z")
Problem Statement: a) I want to display a spreadsheet data (structured data) in Canvas, similar to demo of Airline Canvas page. What's been done: a) I have installed metricbeat, elasticsearch, & Kibana in ubuntu environment. b) I am able to get Canvas report from 3 demo data lake (eCommerce, web traffic & airline ) I am struggling with Lucene sql query syntax for my field name ( ex. Location - Postcode) which has spaces between them . In Canvas workpad I choose to pool data directly from Elasticsearch. To start with, I want to display data in a table (rows and column). ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [January 11, 2019, 12:03am UTC](https://discuss.elastic.co/t/canvas-report-for-log-files-ubuntu/160668/6 "2019-01-11T00:03:50Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.