I know that this is not the google sheets support forum, but hopefully someone here can help me with a rather specific request, and if not I will go back to the google sheets support forum.
I use to use personal capital but since I moved to Tiller haven’t looked back at PC. However, I really like this graph they give me (if it were accurate).
This graph shows the x axis that is the day of the month and is a cumulative cash flow as of today vs last month on the same day. I like this and I can come up with the data really simple using the query formula to create a summary of each day both for the current month and for the last month then use an arrayformula + vlookup to map this into each day since there will be days where perhaps I didn’t spend anything yet you still want to count those days since then you will be creating a running total.
However, what i need help with is how to create the dynamic x axis for the day of the current month. I thought of a brute force way of doing this by having a seaprate sheet with a column for each month showing the number of days and then i can use a formula to pick the right column to use but wondering if there is a simpler way?
I want to have this graph bc to me i use it as a quick glance into how am I doing vs last month on the same time also there is some seasonality that happens with regards to spending where in the beginning you have more spending due to bills then it tapers off.