# How to create chart for User Growth Rate in kibana
**URL:** https://discuss.elastic.co/t/how-to-create-chart-for-user-growth-rate-in-kibana/258692
**Category:** Kibana
**Created:** [December 15, 2020, 10:05am UTC](https://discuss.elastic.co/t/how-to-create-chart-for-user-growth-rate-in-kibana/258692 "2020-12-15T10:05:26Z")
**Posts on this page:** 5
**Page:** 1
### Author:  [@dharanesh](https://discuss.elastic.co/u/dharanesh)
#### Post date: [December 15, 2020, 10:05am UTC](https://discuss.elastic.co/t/how-to-create-chart-for-user-growth-rate-in-kibana/258692/1 "2020-12-15T10:05:26Z")
I have user logs i need to find user growth rate how to do this in kibana.
---
### Author:  [@lukeelmers](https://discuss.elastic.co/u/lukeelmers)
#### Post date: [December 18, 2020, 9:37pm UTC](https://discuss.elastic.co/t/how-to-create-chart-for-user-growth-rate-in-kibana/258692/2 "2020-12-18T21:37:59Z")
Hey there,
Some more information might increase your chances of getting a useful answer. A few starting questions:
- What do your logs look like?
- How are you planning to measure "growth"? (What metrics are you using to determine this?)
- How do you want to visualize this?
---
### Author:  [@dharanesh](https://discuss.elastic.co/u/dharanesh)
#### Post date: [December 30, 2020, 4:54pm UTC](https://discuss.elastic.co/t/how-to-create-chart-for-user-growth-rate-in-kibana/258692/3 "2020-12-30T16:54:57Z")
logs look like user\_id,event,timestamp.
"(user at the end of time period - user at start of time period)/user at the start of period " using this formula.
using barchart or line chart
---
### Author:  [@lukeelmers](https://discuss.elastic.co/u/lukeelmers)
#### Post date: [December 30, 2020, 5:05pm UTC](https://discuss.elastic.co/t/how-to-create-chart-for-user-growth-rate-in-kibana/258692/4 "2020-12-30T17:05:12Z")
> "(user at the end of time period - user at start of time period)/user at the start of period " using this formula.
If you are wanting to perform calculations like this, it sounds like a use case for bucket script aggregations. You can't currently do this using Kibana's core bar/line charts, however there is a way to do this in TSVB. This recent discussion has some links which should explain in more detail:
> [@Take/calculate value from dashboard](https://discuss.elastic.co/t/take-calculate-value-from-dashboard/259093/2):
>
> Is it possible to calculate value directly from a dashboard? The short answer is "no" -- you can't do this directly from a dashboard. However, you can achieve this using a TSVB visualization (which can then be embedded in a dashboard). What you're looking to do is called a [bucket script aggregation](https://www.elastic.co/guide/en/elasticsearch/reference/6.8/search-aggregations-pipeline-bucket-script-aggregation.html), which is [not yet supported in our standard agg-based visualizations](https://github.com/elastic/kibana/issues/4707), but [can be done using TSVB as shown here](https://github.com/elastic/kibana/issues/4707#issuecomment-325997105). Another more detailed example can be found in this thread:
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [January 27, 2021, 5:05pm UTC](https://discuss.elastic.co/t/how-to-create-chart-for-user-growth-rate-in-kibana/258692/5 "2021-01-27T17:05:16Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.