...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...
...but are particularly useful for code in text files for example R or Python code. Whilst git can be used locally on a single machine, or many networked machines, git...
...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...
Today (5 Feb) is National Voter Registration Day and Performance Platform data clearly shows the impact of this UK wide campaign. As I write this over 3000 users are currently...
...places - the Performance Platform and the Transactions Explorer. Over the past year we’ve been looking to integrate these two products and today we’ve brought them together. Moving everything to...
...time. Also, our service has very low volumes, so usually the number on the site right now is zero. The team were still interested in how today is going, and...
...The new dashboard includes: a ‘Today so far’ section showing the number of people at key stages in the online journey (including completions) – updated every 5 minutes a trend...
...was standardised (e.g. 'Epsom & Ewell' was always named 'Epsom and Ewell'), an 'ONS name' table was imported into the database too. This table contained local authority names, ONS codes...
...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.