I'm using crossfilter.js and dc.js to create a dashboard and have one chart which has been stumping me! Hopefully someone can help! See data structure below:
I'm trying to make chart which plots quarters like below:
Desired Chart (Generated in Excel)
I'm trying to avoid normalizing/flattening the data set for Quarters because I would have a x4 times the amount of records (or more depending on how many years we wish to show) and there are a lot of additional description fields used as dimensions for other analysis.
Any ideas or suggestions would be greatly appreciated! Thank you in advance!