avg/day 1

[paverley]

Hello

I want to calculate the average amount of tickets per day. This is an extract of my list.

So first off all , the number of days need to be counted per month. Not simply 30 or 31, but count numer of days on which a ticket was opened. I was thinking of DistinctCount, but...
Secondly i need to make a graph of this and it doesn't seem to work

Help?

31/10/2003 20:25:19 IM59180 CCEB
31/10/2003 21:09:21 IM59182 CCEB
31/10/2003 20:33:04 IM59183 CCEB
31/10/2003 20:37:59 IM59184 CCEB
31/10/2003 20:46:46 IM59185 CCEB
31/10/2003 20:39:44 IM59187 CCEB
31/10/2003 21:19:54 IM59188 CCEB

Tickets in 10/2003 9.449

 

[paverley]

tickets in .... is a GROUP off course

 

[lbass]

I don't think you should have a group on tickets. Insert a group on your datetime field and then choose "Print on change of month". Then create a formula {@date}:

date({table.datetime})

Then create a formula {@ave}:

distinctcount({table.ticket},{table.datetime},"monthly")/ distinctcount({@date},{table.datetime},"monthly")

To create a chart, choose "advanced layout". Use {table.datetime} as your "on change of" field, and while it it is highlighted, go to order->and choose "for each month". Then add {@ave} as your summary field (with no summarization).

-LB

 

[paverley]

i think it's the good direction but he keeps telling me "there must be a group that matches this field

 

[paverley]

sorry i was too quick, i created a wrong group!!!!
and last but not least, it works
thanks-a-lot !!!!!!!!!