Hi, Im using relative time now/M and this gives me “This month so far” starting from 1st day. However, I want that it starts from day 8 because that is when my electric bill billing cycle starts. Can I somehow shift it forward?
You can, set from to something like now-7d/M+7d to get your billing period. The logic here is: Start from the current time, go back 7 days so you’re sure you’re in the starting month of the period and round down to the beginning of the month. Add 7 to go to the 8th day of the month (it’s -1 since it’s an offset from the first day).
Thank you, that worked like a charm!
thanks @anon349787 - is there anyway to use this on the Relative time, so that we accomplish the same thing but it will stay updated as the days go by? ie if on a dashboard i want a chart to always show the 1 month billing period that starts on say 8th of the month.
I can accomplish this with via setting from/to , but 3 days im guessing i will i have to adjust the now-7d/M+7d to shift it 3 days.
thanks