Within CloudWatch dashboard, I have a gauge metric which shows the sum of a custom metric (custom metric represents the number of log entries over time). The number of log entries is very consistent per day (lets assume 8).
I'd like to only include/show data since the last Friday. So on a friday, gauge should drop to 0. When I configure to show the last 7 days, it shows every day nearly the same number (8 * 7 = 56).
Expected example:
| Day of week | expected gauge number |
|---|
| Friday (0:00) | 0 |
| Friday (23:59) | 8 |
| Saturday | 16 |
| Sunday | 24 |
| Monday | 32 |
| Tuesday | 40 |
| Wednesday | 48 |
| Thursday | 56 |
| Friday (0:00) | 0 |
| Friday (23:59) | 8 |
| Saturday | 16 |
| ... | ... |
I tried with MATH "if", but there is no NOW() function. Does someone have an idea how to achieve this?
