...with today’s searches in cell C2: =ARRAYFORMULA(SUMIF(Today!$A$16:$A, $B2:$B, Today!$B$16:$B)) For each row, this formula looks through column A of the ‘Today’ report, finds the search term from column B of...
...week =TODAY()-WEEKDAY(TODAY(),1) ISO reporting week If you prefer reporting from a Monday to Sunday here are the formulas. Monday of last complete week =TODAY()-WEEKDAY(TODAY(),1)-5 Sunday of last complete week =TODAY()-WEEKDAY(TODAY(),1)+1...
...the code, and ensuring that the code does what we expect it to, but because we have written an R package, it’s also very easy for us to institute tests...
...surprising: 53% of the time, manual coders disagreed about how a survey should be coded. We can see this in the chart below, which shows how often volunteer coders applied...
...registering to vote via GOV.UK. Today's usage topped out at 6.21pm with almost 8500 people online at once. Looking at applications by age group it's plain to see that under...
If you visit our homepage now you’ll see it says 813 service dashboards. That's over 700 more than this time last week. Up until now performance data was in two...
...decided: what to include where to host it how to display the information What to include Sarah and I, the performance analysts, met the scrum team and talked about the...
...of the team. We need to show metrics that lets the team learn what’s working well, what could be better and to improve. We decided to take the same approach...
...meant that there was more time to focus on analysis, quality assurance, and explaining what the statistics were showing. What’s in a name? …pain, if an ampersand does it contain!...
...code open and reusable, and the team told us that DVLA as a whole is now proposing to adopt this process. The process will include additional controls, reflecting the organisation’s...
Related content and links
About this blog
This is a cross government blog about our work with data and the way we’re using performance analysis and data science techniques to improve service delivery and policy outcomes, and our work to find, access and use open government data.