Rails Daily/Monthly Report <p>Report</p> <p>I need to create a daily report + monthly report with this records.. All records is from one table and under one field('nature' is the name of my field)..</p> <pre><code>Calls Texts Emails </code></pre> <p>Is there any possible way to create a single query that will generate this daily report + monthly report.?</p> <p>Ex.</p> <pre><code> Day1 Day2 Day3 etc.. Total Calls 20 23 23 ... 66 Texts 120 125 130 ... 375 Emails 50 60 55 ... 165 Total 190 208 208 ... 606 </code></pre> <p>If not, please tell how to do it the simplest way, and how to this on rails.?</p> <p>Thanks in advance...</p>