May be too much specific question.
But if I have a date mentioned in specific table in numeric format like - 12 .
Can I display a chart for records from 12 to 11th of the next month . Likewise report will have sum of another value field for each segment of days (12th to 11th). ?