BMt: Why don't "custom group" subtotals always add to 100%?
If you look at, for example, the %s of S47s completed within each timescale band, depending on the LAs in your custom group, the total may not make 100%. Why is this?
9 Views
top of page
Data to Insight is not a software supplier in the traditional sense -- we're here to help local authority (LA) colleagues get work done and share it with each other. The best thing about Data to Insight is the community of analysts who are doing and sharing great work through this network.
We recognise that different LAs want different levels of engagement with our work. As such, we offer four key collaboration approaches to suit different users’ information needs.
D2I Toolkit
Public·5 members
bottom of page
This is a known issue, but we don’t have a better solution than is already in place. Open to suggestions.
If you look at Data_AllLAs, at the bottom of each year’s data there’s a calculation row showing the average for the custom group selected. If one or more LAs in the custom group have suppressed data for a given measure, those averages will be necessarily incomplete. It’s particularly noticeable when you have a set of related measures like the S47 timescales bands, which for any one LA should add up to 100%. But if some LAs is the custom have suppressed data in different measures across the four columns, the percentages aren't drawing from the same pools. So the averages aren’t comparable and won’t add to 100%.