I have a list report I'd like to calculate an average rate by job title. For example there will be 10 or 12 job titles (sales rep,tech, etc.) I'd like to figure an average rate of the job title. I'm new to cognos so any assistance would be appreciated. Please let me know if I'm not being clear.
Quote from: Nickbruno on 18 Jul 2014 10:26:46 AM
I have a list report I'd like to calculate an average rate by job title. For example there will be 10 or 12 job titles (sales rep,tech, etc.) I'd like to figure an average rate of the job title. I'm new to cognos so any assistance would be appreciated. Please let me know if I'm not being clear.
Hi,
If the list is really simple - just the job title and the rate measure, all you need to do is to drag these two items into the list, then select the Rate column and change the Aggregate Function property to Average.
If your report is more complex, post back with details and we will advise the easiest solution.
Cheers!
MF.
Thank you! There are more fields I will post below. More so there are several employees with the same job description but different wage rates so i need cognos to look at all the employees with a job description of say "analyst" & calculate the avg rate for that job description.
Job Description. Employee ID. Department. Hourly Rate
Analyst 00011 Finance. 10.00.
Analyst. 00012. Finance. 12.00.
Analyst. 00013. Acctn. 10.00
Avg. 10.67
Thanks!
Quote from: Nickbruno on 18 Jul 2014 12:48:51 PM
Thank you! There are more fields I will post below. More so there are several employees with the same job description but different wage rates so i need cognos to look at all the employees with a job description of say "analyst" & calculate the avg rate for that job description.
Job Description. Employee ID. Department. Hourly Rate
Analyst 00011 Finance. 10.00.
Analyst. 00012. Finance. 12.00.
Analyst. 00013. Acctn. 10.00
Avg. 10.67
Thanks!
Ok - in that case, group the report on the Job Description column (select the column in the list then use the Group button on the toolbar) then select the Hourly Rate column and press the Aggregate button on the toolbar (looks like a sigma) - choose Average from the list of aggregations. This will add in the average rate as a footer at the end of each Job Description group.
Cheers!
MF.
Worked perfectly! Thank you!