Hi everyone,
Let’s say, I have a shop and I want to make some stats on the sales to check when are the best and worst sales. This part is quite simple, I found a topic on this already here (How to find Min / Max in a column - #4).
But now let’s add some spice, the financial benefits of the shop are processed by 1-day periods except when it is a weekend or a holiday. The processed data look like this :
| Date | Financial Benefits |
|---|---|
| 2022-04-01 | 4 608 ₽ |
| 2022-04-02 | 3 979 ₽ |
| 2022-04-03 | 15 215 ₽ |
| 2022-04-05 | 24 711 ₽ |
| 2022-04-06 | 4 172 ₽ |
| 2022-04-07 | 6 058 ₽ |
| 2022-04-08 | 5 775 ₽ |
| 2022-04-09 | 2 254 ₽ |
| 2022-04-10 | 25 789 ₽ |
| 2022-04-12 | 42 489 ₽ |
| 2022-04-13 | 6 672 ₽ |
As explained above, I am able to find the maximum/minimum values and the associated date with the following modules :
For statistic issues I also need for both dates (max/min benefits) to get the date for both the previous and the following report to check the date difference.
For exemple, for the maximum value (42 489 ₽), the previous report was on 2022-04-10 (2 days before) and the following was on 2022-04-13 (1 day after).
The processed data are already sorted by date (with no blank lines) so I would need the previous and the following line. Do you have any idea on how I can retrieve them ?
Thank you and have a nice weekend.