Line Chart

[Former Member]

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

[Former Member · Accepted solution]

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

[Former Member]

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

[Former Member]

Okay. So the particular day of the month has nothing to do with it?

How do you know if the calls are still outstanding (or not)? Is there a case closed date that may be filled in if it is closed?

Give us more info and it'll help with a quicker answer.

[Former Member]

No it doesn't matter what day of the month it is. I just want to show the trend of opens calls for a particualr category over 1 year.

I'm using Select Expert to show only 'Open' or 'On Hold' calls.

[Former Member]

So what kind of date fields are available?

Date of initial call?

Date call was closed?

[Former Member]

Date call was created (it's called eCreationTime) is available.

[Former Member]

Just use the category for the on-change-of field in the line chart and then a count of the calls for the Show Value

[Former Member]

>= dateadd ("yyyy", -1, )

This will work as long as you have no creation dates past the current date (date report is run).