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?