Benchmarking Tool not showing comparator data in CreateCustomGroup
I want to look at my statistical neighbours data on CIN rates of starts and ends. However nothing is coming up (see image below). Am I doing anything wrong? It is coming up with 0's.
I have gone into the CreateCustomgroup tab and pasted for example B1.05A and it is shown the correct column title - but no data is being pulled through. However the 18/19 data is shown in the main charts.
6 Views
The CreateCustomGroup tab appears only to pull the benchmarking from the most recent year listed in the datastore, which, in v3.8 is 2019-20 due to the new schools data, but we don't yet have 2019-20 CIN data so the corresponding CIN cells are currently empty (data new next month). In the meantime, if you go to cell P6 and change this formula:
{=INDEX(DATA_AllLAs!$J$7:$BRN$183,MATCH($B6,DATA_AllLAs!$D$7:$D$183,0),MATCH(P$4,DATA_AllLAs!$J$5:$BRN$5,0))}
So that it says the below instead (remember to hit Ctrl+Shift+Enter to make it an array formula, evidenced by the curly brackets at each end):
{=INDEX(DATA_AllLAs!$J$185:$BRN$361,MATCH($B6,DATA_AllLAs!$D$185:$D$361,0),MATCH(P$4,DATA_AllLAs!$J$5:$BRN$5,0))}
And then fill down, you'll see the 2018-19 data in that table instead.
I'll look at amending the formula so that it looks for the most recent year's data in the next release.