The other week we were lucky enough to have a post-Covid visit to one of our customers, where we learned more about how their part of the NHS uses the public data sets PublicView stores and processes.
It turned out that the customer needed to process data for sets of ICS "member" organisations (Trusts or CCGs), so they could see how those individual constituents were affecting the ICS's overall performance for specific metrics. Our systems supported ICS level comparisons, but we'd missed that customers would need to review which of their member organisations (CCGs or Providers) were contributing to the metric, and how.
The report they were producing manually is shown at the bottom of the page here, with deep red blocking on what was an Excel spreadsheet derived from our system data.
PublicView Screen Shot
We thought that the user's approach to colouring in table cells to draw attention to it was a good idea. So we took it and built it into our systems. We hope that'll save a lot of effort each month, and mwill spread our customer's good idea more widely. Our version of the tbale is responsive and reactive - you can tweak the colours in real time, and sort or step through or drill into the data as you'd expect.
We also realized that even if you're not managing an ICS, this sort of display could be useful, so it'll be released in a few days for all users, not just ICS users. Oh, and it works on your mobile phone too!
If any other customers are performing "down stream" processing of data from PublicView, please get in touch and tell us what you're doing. If we can, we'll code it up so it's automatic.
Customer Spreadsheet
Recent Posts
- Top 100 Hospitals 22 May 2022
- Continuing Health Care metrics 16 May 2022
- Maternity Replaces Board Scorecard 15 May 2022
- Conference Season 04 May 2022
- Better Blog Search 04 May 2022
- Board Reports and Headlines 02 May 2022
- More ICS Support 25 Apr 2022
- Innovation in the NHS 22 Apr 2022
- Easter Eggs 16 Apr 2022
- New Financial Year New Data 14 Apr 2022
- New Cloud 03 Apr 2022
- Good Ideas 29 Mar 2022
- Additions and Fixes 26 Mar 2022
- System Updates 21 Mar 2022
- Public View joins BCN Group 14 Mar 2022
- End to natural births targets 23 Feb 2022
- SOF and HCPS Reports 16 Feb 2022
- Diagnostic Activity Metrics 09 Feb 2022
- Search 02 Feb 2022
- Accessibility 28 Jan 2022