# Dynamic Baseline

**URL:** <https://discuss.elastic.co/t/dynamic-baseline/322317>\
**Category:** Kibana\
**Created:** [January 2, 2023, 2:25pm UTC](https://discuss.elastic.co/t/dynamic-baseline/322317 "2023-01-02T14:25:41Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Rbb](https://avatars.discourse-cdn.com/v4/letter/r/a698b9/32.png) [@Rbb](https://discuss.elastic.co/u/Rbb)\
**Post date:** [January 2, 2023, 2:25pm UTC](https://discuss.elastic.co/t/dynamic-baseline/322317/1 "2023-01-02T14:25:41Z")

</div>

Hi!  
I need to create a dynamic baseline which is based on the average of the field [transaction.duration.us](http://transaction.duration.us) of the previous month. I have tried to create a runtime field, but the fact that the data is located in seperated docs as histogram data causes trouble for aggregation. I am also tempted to use transforms, but if I understand it right - the destination index cant be of the same index template as the source index. This will cause trouble when I will display graphs in Kibana. Do you have any recommendations on how I can proceed with this issue?

---

<div class="post-metadata">

**Author:** ![nickpeihl](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nickpeihl/32/112622_2.png) [@nickpeihl](https://discuss.elastic.co/u/nickpeihl)\
**Post date:** [January 3, 2023, 3:13pm UTC](https://discuss.elastic.co/t/dynamic-baseline/322317/2 "2023-01-03T15:13:24Z")

</div>

Hi @Rbb.

Are you trying to create this baseline in a visualization? Lens supports [custom formulas](https://www.elastic.co/guide/en/kibana/current/lens.html#lens-formulas) that have a `shift` parameter that can aggregate over a different period.

---

<div class="post-metadata">

**Author:** ![Rbb](https://avatars.discourse-cdn.com/v4/letter/r/a698b9/32.png) [@Rbb](https://discuss.elastic.co/u/Rbb)\
**Post date:** [January 3, 2023, 4:01pm UTC](https://discuss.elastic.co/t/dynamic-baseline/322317/3 "2023-01-03T16:01:39Z")

</div>

I also want to split the data into several graphs and visualize the top 5 most visited pages(rum).  
I have up to now used aggregation based visualization. Is it possible to split it like this with lens as well?

---

<div class="post-metadata">

**Author:** ![nickpeihl](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nickpeihl/32/112622_2.png) [@nickpeihl](https://discuss.elastic.co/u/nickpeihl)\
**Post date:** [January 4, 2023, 4:02pm UTC](https://discuss.elastic.co/t/dynamic-baseline/322317/4 "2023-01-04T16:02:40Z")

</div>

Hi @Rbb.

Sure, you can add the page url field to the Breakdown section in the Lens editor.

---

<div class="post-metadata">

**Author:** ![Rbb](https://avatars.discourse-cdn.com/v4/letter/r/a698b9/32.png) [@Rbb](https://discuss.elastic.co/u/Rbb)\
**Post date:** [January 4, 2023, 5:27pm UTC](https://discuss.elastic.co/t/dynamic-baseline/322317/5 "2023-01-04T17:27:15Z")

</div>

I want each page to be an individual graph as one can do by the split chart function in the aggregation based visualizations. I cant get the Breakdown feature to do that, can I?

I found this related post: [Kibana Lens split chart](https://discuss.elastic.co/t/kibana-lens-split-chart/239120).  
Is this still the case? If so is there any way to both get the dynamic baseline and splitting charts?

---

<div class="post-metadata">

**Author:** ![nickpeihl](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nickpeihl/32/112622_2.png) [@nickpeihl](https://discuss.elastic.co/u/nickpeihl)\
**Post date:** [January 5, 2023, 4:29pm UTC](https://discuss.elastic.co/t/dynamic-baseline/322317/6 "2023-01-05T16:29:05Z")

</div>

Hi @Rbb.

Sorry, no, we currently don't have the ability to split charts in Lens. [Here is the feature request tracking this](https://github.com/elastic/kibana/issues/72063).

I don't think there is a way to have both a time-shifted baseline and split charts in the same visualization in Kibana.

---

<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:** [February 2, 2023, 4:29pm UTC](https://discuss.elastic.co/t/dynamic-baseline/322317/7 "2023-02-02T16:29:26Z")

</div>

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