I have a report I created that shows sum of tickets per month, per user that were closed within a 12 month period.

Example:


When building this report I used the following function to identify tickets closed within a certain month.  I had to create 12 separate functions (for each month) to achieve the results I needed. But I am curious if there is a better way to do this?

if DateDiff ("m", {@Close Date conv}, CurrentDateTime) in 12 to 13 then 1 else 0
This function is then summarized (Sum) to show count of tickets closed 12 months ago.  The @Close Date conv is a function that converts my epoch DateTime.

While I do have the results I need I am now facing a new challenge with graphing the results.  I'd like to be able to see (in graph) the sum of all tickets closed per month but I am limited when I try to insert a chart using either Grouping or Advanced.  The only group I have is User and Advanced doesnt allow me (or at least I dont know how) to plot my total tickets per month against a per month axis.  I've tried so many different combos with data/available fields and getting nowhere.

I have the impression that my initial functions that are producing the results should be rewritten to allow my chart to be created correctly.

Thoughts?

Thanks for your time!


Edited by ultraca - 04 May 2011 at 3:56am

Almost there DBlank.



My sum's, in graph, arent doing what I expect though.  Interestingly, by adding consecutive values from my chart gives me the correct number from my Total Closed above:
533+493 = 1026 = 04/2010
493+586 = 1079 = 05/2010
586+771 = 1357 = 06/2010
...
...
354 + 42 = 396 = 04/2011

Not sure where I went wrong here but my Total Closed values are a sum of each months totals, which is what I based my chart on.

also are there duplicate data that needs to be accounted for?

hiding items do not exclude them from summaries. They still exist int he data that is being read so they have to be accounted for.

i need help with that, but mine is regarding inventory any help