I have an idea that I would like to explore, but can't really nail down how to approach my script for this addition I would like to make.
To explain I have a bar chart that I created to help identify on today's date what project milestones were acheived yesterday, and what projects milestones were missed. I would like to create button(s) (maybe a slider) that will let me change what today is. I believe it is imporant to note that yesterdays date is based on the 'Milestone.Revised Date' field.
Re: Attempting to make a Chart more robust/pivot data
I think your approach could work but is very complex and it would be quite difficult to maintain and extend. I suggest you should go back one or two steps and look if you could optimize your datamodel and make some associations and calculations in the script. Maybe these links could give you some hints: