The only way I know to do this is to get your data into a view where each project has a row for each day. I did that in the attached example using 10.1 of Tableau's Union feature with a unique sheet in a spreadsheet for each project.
I played around a bit with table calcs to try and replicate some of the visualizations included but nothing came close to the output.
daily funding by project.twbx 27.9 KB
While I agree with Patrick with regards re-shaping/densifying the data is the best/easiest solution...in the interest of showing the "Art of Possible" in Tableau, here is a solution (in T10.0) using your existing data set (and Tableau's data densification behaviour).
First, with regards your question on what it would look like if you densified the data yourself (before bringing into Tableau)...it would have a row for every "live" date for a project with the Daily Funding for each.
So would look something like this
With the data like this...you can just drag Start Date and Daily funding into the Viz and voila!
The solution I've provided here (using Tableau Data Densification) is very complicated and encompasses some advanced and not well documented features (Domain Padding, Data Densification, Nested Table Calcs). The only re-shaping of the data I did was to Pivot the Start/End date (using Tableau's in-built Pivot feature on the Connect to Data section). So Data looks like this
If you are unable to densify your data before bringing into Tableau, and you think the attached might fly, let me know and I can give you a full description of how to do it (be warned it will be a long!!)
Start End Date - Densified.twbx 42.3 KB
Thanks Patrick and Simon.
I went the route of changing my data so that I had a row for each project for each day and that's giving me what I need so I think I'll forego the more complicated alternative Simon offered.
But as always, it's nice to know there's more than one way to tackle something in Tableau. Thanks again for the examples and the assistance.
That's awesome Yuri ...CustomSQL-Free Cross/CartesianJoin!!
I hadn't really thought beyond a bit of data clean-up when using this new feature (formula joins), but this has a lot of potential. A bit like LoDs...it started off solving a few (current) problems, then as we dig deeper and deeper we find a multitude of creative uses (with a bit if thinking, we could probably do < and > joins...hmmm "food for thought"!!). I do love the way Tableau developers create solutions...really think about the "deeper" problem and come up with a single feature which solves 100s of problems (and some we don't even know we have yet!!)