on 09-03-2008 4:52 PM
Hi,
I want to create a line chart that shows the count of a field at a particular date for the last year (preferably by month).
I have created the chart, but it only shows the count of a field that were created in that month, rather than the total altogether during that month.
any ideas?
thanks
Dave
Let's say you want the day of the month (greatest) to be the 15th.
Use the DAY function to pull ONLY that data into the report.
Record selection formula:
Day () <= 15
Then simply do the line chart by month and the months will only include days 1 thru 15 data
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Maybe i wasn't clear enough -
I'm reporting on the level of calls that come into our IT helpdesk. We send out a weekly report to our business customers showing the number of calls logged by Category.
I want to show on a line chart, the number of calls that have been outstanding over the last year.
any ideas?
thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
95 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.