Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Chart for Oldest Call Waiting for Multiple Skills

Status
Not open for further replies.

Stinney

IS-IT--Management
Nov 29, 2004
2,029
US

I have a multiple skill real time report. The report will show the time for the single oldest call waiting for multiple skills.

However, if I create a chart and the only data item is the OLDESCALL field, it will separate the chart into each skill. I can't sum the time, I can't average it, can't specify "TOP", how can I get this to show a chart for only the single oldest call waiting in multiple skills?

- Stinney
"Scire ubi aliquid invenire possis, ea demum maxima pars eruditionis est"

"To know where to find anything is, after all, the greatest part of education"

 

Found that my other report was not reporting on the single skill with the oldest call waiting. Looks like I was able to fix once I realized I could change the select to MAX(OLDESTCALL).

- Stinney
"Scire ubi aliquid invenire possis, ea demum maxima pars eruditionis est"

"To know where to find anything is, after all, the greatest part of education"

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top