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
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.