I have a data set that is fairly simple but forhte life of me can't figure out how to chart it the way the client wants. This has me rather fustrated because i feel like i am missing something fairly obvious.
Dataset of Students (who have dropped out of a program) with their last day of attendance.
Student Id LastDate
Need a calendar graph to indicate trends of when in the term most of them are dropping. I would expect this would have a X axis as the date range of the term a datapoint for each week or day or month (some would have 0) and the Y would be the numbers.
In crystal it would seem a scatter chart would do this well, but I can't figure out how to get the date range for the X axis.