I have a set of data that looks like this
event_name, open_date, closed_date
JOBAPPLICATON, 1-jun-2014, 4-jun-2014
JOBAPPLICATON, 3-jun-2014, 4-jun-2014
JOBAPPLICATON, 1-jun-2014, 14-jun-2014
...
I would like to plot these in a bar chart with a time scale, in such a way that the open_date is grouped and counted (as a red bar), and the closed_date is grouped and counted (as a blue bar). Ideally, these bars are next-to-each-other.
I achieved some success by combining them in a composedChart as two separate barcharts, but is that the best way? Or are there better approaches?