I have a report grouped as outlined below. Basically, I am trying to calculate the number of tickets for each status under each system type. There is probably a very simple answer that I am missing. (Note: Alignment of these three columns may be off in my posting). Any suggestions?
System...
I am retrieving data using Cognos Impromptu that includes date-time fields. It is a rather large database. I am looking to calculate averages and trend based on day of week (i.e. average Monday). What is the easiest way to pull my report and convert the date-time fields to day?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.