4 Replies Latest reply on Nov 14, 2012 12:16 PM by Chris Turnbull

# Matrix - Heatmap?

Hi All,

I am stuggling to create the attached with Tableau.

KS2 Level is the Level a student achieved when they were at Primary School and they are expected to improve by 3 Level by the next time they are tested in Secondary School. Scores *=10, A=9, B=8, C=7, D=6, E=5, F=4, G=3.

To get the levels of progress the KS2 Level is taken from the KS4 Grade Score.

All this means that the first Grid shows the following:-  Dark Green More than 3 Levels of Progress, Light Green = 3 Levels of Progress and Lilac is less than 3 Levels of Progress.

This Data will be pulled out of the MIS System and then aggregated in Tableau.  The National Data to the right is already Aggregated and will be just given to me as is.  I am guessing at a Heatmap where I create Calulated Fields that are assigned the designated colour the for each cell and then drop the Total on top but I am struggling with it.

Any help will be gratefully received as I am struggling.

Thanks

Chris

• ###### 1. Re: Matrix - Heatmap?

Hi

I have made some progress.  Its a bit long winded but what do you think of this.

Also if a cell is blank how would I go about colouring it.

Thanks

Chris

• ###### 2. Re: Matrix - Heatmap?

Hi ALL

I have had a little more succes and I now have the Matrix that I want.

How do I calculate a Student Total for each line and then use that Total in the % Calculations that I need.  I have tried a number of ways but as yet I have been unsuccessful.

Any help gratefully appreciated.

Thanks

Chris

• ###### 3. Re: Matrix - Heatmap?

Hi All

I am getting there as British Rail used to say.

This is my current position  all I need to do is create a calculation that will count on each line how many student are achieving the Progress and how many are exceeding Progress the problem is depending on the KS2 Level the calculation will be counting diffent columns.

For Example: Exceeding

If KS2

= 2 Then I would Count everything from A* to D for that Line

= 3 Then I would Count everything from A* to C for that Line

= 4 Then I would Count everything from A* to B for that Line

= 5 Then I would Count everything from A* to A for that Line

Expected

= 2 Then I would Count E

= 3 Then I would Count D

= 4 Then I would Count C

= 5 Then I would Count B

I cannot workout what the Calc wuld look like as I do not know how to Address the Columns.

As Always any help greatfully received.

Chris

• ###### 4. Re: Matrix - Heatmap?

Hi All

I think I am nearly there  but I am doing something - I have aged to reference the columns with Calculation1 and it gives me the numbers that I want but it is putting them on seperate lines.  What I actually need is the TOTAL that is calculated in calculation1 each row.

All help greatfully received or even a pointer to a decent tutorial would do.

Thanks

Chris