I’m wondering if you could help me out with something. So i have this quarter over quarter line chart comparison, which is great for quarters that have finished. But if I want to bring in current quarter for a live up to date status of current performance, it flat lines after today’s date or today. Ideally I that line would stop, and each day it would tick forward or up as time goes on.
I’m pivoting by quarter, days of quarter on the x and I’m plotting a running total calculation of a ‘deal amount’ dimension.
Has anyone executed something like this? Or does anyone have any thoughts on the matter?