# To create a dashboard to get the highest transactions in a week in any interval
**URL:** https://discuss.elastic.co/t/to-create-a-dashboard-to-get-the-highest-transactions-in-a-week-in-any-interval/349693
**Category:** Kibana
**Tags:** dashboard
**Created:** [December 20, 2023, 6:36am UTC](https://discuss.elastic.co/t/to-create-a-dashboard-to-get-the-highest-transactions-in-a-week-in-any-interval/349693 "2023-12-20T06:36:33Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@0954bd6f79bcb4a34df4](https://discuss.elastic.co/u/0954bd6f79bcb4a34df4)
#### Post date: [December 20, 2023, 6:36am UTC](https://discuss.elastic.co/t/to-create-a-dashboard-to-get-the-highest-transactions-in-a-week-in-any-interval/349693/1 "2023-12-20T06:36:33Z")
i need to create a dashboard where it should display highest transactions of all weeks in any interval ,say 6 months (Monday to sunday i,e; highest Monday, Tuesday,,,,Sunday transactions in all weeks of the 6 months) .Overall it should display only 7 days of week in any interval
---
### Author:  [@Marius\_Dragomir](https://discuss.elastic.co/u/Marius_Dragomir)
#### Post date: [December 27, 2023, 9:17pm UTC](https://discuss.elastic.co/t/to-create-a-dashboard-to-get-the-highest-transactions-in-a-week-in-any-interval/349693/2 "2023-12-27T21:17:17Z")
If you are familiar with SQL, i would suggest using ES|QL which was recently released to do a search, or have a look into using Canvas as that would be the adequate app in Kibana to do it.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [January 24, 2024, 9:18pm UTC](https://discuss.elastic.co/t/to-create-a-dashboard-to-get-the-highest-transactions-in-a-week-in-any-interval/349693/3 "2024-01-24T21:18:03Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.