I am trying to calculate the average mark of a module (subject) at a particular time for all the students who have been assessed.
Sorry I can't pa
ASSESS TYPE field. Assessments can be made up of two parts e.g. Coursework and Oral Exam
RANKING TOTAL: The total for the individual part of an assessment is called the RANKING TOTAL. I have added the AVG(RANKING TOTAL) to this shelf.
MODULE TOTAL: This is the total for a module of study (usually the two added together but I don’t calculate this, the Module Total is already in the data source) e.g. Criminal Law L5 etc.
I would like to have a bar chart that shows the
AVG(Ranking Total) by ASSESS TYPE AND
AVG (Module Total) by MODULE/LEVEL
Is it possible to combine the graph into one?
Message was edited by: Angelique van der Linde
Hi - Packaged workbook attached.
Hi Angelique,
Looking for something like this?
Create calculated field for coursework, oral exam and criminal law :
Place them into blended axis, measure values in row shelf, measure anmes into color and column shelf :
In last do alias by rightclickng on xaxis headers.
Please mark as correct and helpful if this helps.
Thanks,
Shruten
