# Weekdays and percentages in line graphs

**URL:** <https://discuss.elastic.co/t/weekdays-and-percentages-in-line-graphs/194109>\
**Category:** Kibana\
**Created:** [August 6, 2019, 10:11pm UTC](https://discuss.elastic.co/t/weekdays-and-percentages-in-line-graphs/194109 "2019-08-06T22:11:04Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Karthik2411](https://avatars.discourse-cdn.com/v4/letter/k/ed8c4c/32.png) [@Karthik2411](https://discuss.elastic.co/u/Karthik2411)\
**Post date:** [August 6, 2019, 10:11pm UTC](https://discuss.elastic.co/t/weekdays-and-percentages-in-line-graphs/194109/1 "2019-08-06T22:11:04Z")

</div>

how do I get graphs represented in percentages with weekdays break down say from sunday to saturday and refresh automatically every week

---

<div class="post-metadata">

**Author:** ![flash1293](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/flash1293/32/41227_2.png) [@flash1293](https://discuss.elastic.co/u/flash1293)\
**Post date:** [August 8, 2019, 12:01pm UTC](https://discuss.elastic.co/t/weekdays-and-percentages-in-line-graphs/194109/2 "2019-08-08T12:01:54Z")

</div>

You can aggregate by weekday creating a [scripted field](https://www.elastic.co/blog/using-painless-kibana-scripted-fields) and then using a terms aggregation on that field to have separate buckets per day.

I'm not completely sure what you mean by refreshing automatically - all data shown in visualize and dashboard is freshly fetched when you open the page. You can also configure an automatic refresh on dashboards to reload data in regular intervals (see the "Refresh every" settings in the bottom of the flyout)

 ![32](https://us1.discourse-cdn.com/elastic/original/3X/4/c/4cfc4009dcab8d1be5bcd08407fd1bc300f48b09.png)

---

<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:** [September 5, 2019, 12:01pm UTC](https://discuss.elastic.co/t/weekdays-and-percentages-in-line-graphs/194109/3 "2019-09-05T12:01:58Z")

</div>

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