# Timelion alternatives for canvas workpad

**URL:** <https://discuss.elastic.co/t/timelion-alternatives-for-canvas-workpad/252125>\
**Category:** Kibana\
**Tags:** canvas\
**Created:** [October 15, 2020, 3:09am UTC](https://discuss.elastic.co/t/timelion-alternatives-for-canvas-workpad/252125 "2020-10-15T03:09:47Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![AClerk](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/aclerk/32/55297_2.png) [@AClerk](https://discuss.elastic.co/u/AClerk)\
**Post date:** [October 15, 2020, 3:09am UTC](https://discuss.elastic.co/t/timelion-alternatives-for-canvas-workpad/252125/1 "2020-10-15T03:09:48Z")

</div>

Hello,  
Are there any alternatives to timelion in canvas?  
I would like to show time-based data, but there are bugs with timelion that I cannot workaround.

The final result should look something like this:

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/5/3/53df05d5ff86bb9a03121af297222a5fb88db814.png)  
Would be happy to hear any idea you might have.  
Cheers!

---

<div class="post-metadata">

**Author:** ![poff](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/poff/32/81795_2.png) [@poff](https://discuss.elastic.co/u/poff)\
**Post date:** [October 19, 2020, 9:31pm UTC](https://discuss.elastic.co/t/timelion-alternatives-for-canvas-workpad/252125/2 "2020-10-19T21:31:47Z")

</div>

Hey there!

Have you considered using the essql function to grab the data for your graph? Check out this example using the ecommerce sample dataset:

```
essql "SELECT DATE_TRUNC('hours', order_date) as \"@timestamp\", sum(taxless_total_price) as value FROM kibana_sample_data_ecommerce group by DATE_TRUNC('hours', order_date)"
| pointseries x="@timestamp" y="value"
| plot xaxis=true yaxis=true defaultStyle={seriesStyle points="0" bars="0" lines="3" color="#eb6c66"}
| render containerStyle={containerStyle opacity="0.5"}

```

This does a sum aggregation grouping by the order data. I'm also using the date trunc function to return data for hourly granularity.

Does this help?

---

<div class="post-metadata">

**Author:** ![AClerk](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/aclerk/32/55297_2.png) [@AClerk](https://discuss.elastic.co/u/AClerk)\
**Post date:** [October 19, 2020, 11:42pm UTC](https://discuss.elastic.co/t/timelion-alternatives-for-canvas-workpad/252125/3 "2020-10-19T23:42:25Z")

</div>

That is awesome!  
Thanks a lot @poff !

Do you know if I can change the time interval in the visualisation?  
For example to have 1 hour instead of 2?

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/0/5/05fa3215dfb74e4bafa8d7f451d9ef50b7a95c66.png)

Cheers ✈

---

<div class="post-metadata">

**Author:** ![poff](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/poff/32/81795_2.png) [@poff](https://discuss.elastic.co/u/poff)\
**Post date:** [October 20, 2020, 8:40pm UTC](https://discuss.elastic.co/t/timelion-alternatives-for-canvas-workpad/252125/4 "2020-10-20T20:40:00Z")

</div>

I'm not sure I have the perfect solution for the interval configuration on the chart but you might take a look at the axisConfig function: [https://www.elastic.co/guide/en/kibana/current/canvas-function-reference.html#axisConfig\_fn](https://www.elastic.co/guide/en/kibana/current/canvas-function-reference.html#axisConfig_fn)

---

<div class="post-metadata">

**Author:** ![AClerk](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/aclerk/32/55297_2.png) [@AClerk](https://discuss.elastic.co/u/AClerk)\
**Post date:** [October 21, 2020, 4:17am UTC](https://discuss.elastic.co/t/timelion-alternatives-for-canvas-workpad/252125/5 "2020-10-21T04:17:03Z")

</div>

Ya, seen this already.  
Ticksize - Use for `number` axes only. i.e. not time/date.

Thanks!

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [November 18, 2020, 4:17am UTC](https://discuss.elastic.co/t/timelion-alternatives-for-canvas-workpad/252125/6 "2020-11-18T04:17:08Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.