Create charts comparing all practices in [CCG] on a measure

[HelenCEBM]

Commonly requested by users. Eg. see at a glance which practices have changed in response to CCG policy. Avoids need for printing whole page full of charts, which in any case doesn't work well due to Highcharts issues.

Not really feasible as time trend charts (except maybe for smaller groups like PCNs) but could be done as a bar chart.

Example we could follow:

Or there may be other ways of presenting this.

Ideally we would have available:

• A choice of time periods to compare (e.g. years, quarters, months) and a choice of baseline comparison period (e.g. previous quarter (Q4 vs Q3) or matched quarter in previous year (Q4 2018-19 vs Q4 2017-18). Or sliding scales so people choose precise periods of interest.
• For all organisations
• A horizontal line for Organisation mean / median and/or National mean/median.
• Option to download data (for each month to allow other desired custom time periods or subsets of practices to be shown)

In the short term we could stick to doing this for:

• CCGs only
• latest 12 month period vs previous 12 month period

Options:

1. Individual pages for each measure (i.e. one chart per page).

• Title e.g "Pregabalin prescribed as Lyrica by practices in NHS AIREDALE, WHARFEDALE AND CRAVEN CCG - Performance snapshot"
• Add additional text e.g. "this chart shows how all the practices in [CCG] performed in the last 12 months compared to the previous 12 months. To see full time trends click [here]"
• These could be standalone pages under e.g. https://openprescribing.net/ccg/02N/lyrica/spinechart or https://openprescribing.net/ccg/02N/lyrica/snapshot
• Navigate from a CCG page, e.g. under the Explore option we could have:
  • Split the measure into charts for individual practices (time trends)
  • Show the measure as a bar chart for individual practices (latest 12 months)
• Sort order for practices would need to be decided:
  • suggest highest to lowest, in latest period
  • Might be useful to offer alphabetical (later) as well to allow comparisons between performance on different measures.

2. Embed at top of existing practice breakdown pages

• (e.g. https://openprescribing.net/ccg/02N/lyrica/)
• People may not realise the charts are still there below (especially if page is slow to load).
• We currently have savings and sort order detailed at top of page which are based on 6-month periods which may cause confusion.

3. Show all measures on one page

• This is quite a lot of charts
• Might be less useful for users who want to look at single measures, but if sorted in order of performance (somehow), it could help to highlight issues in a different way to what we currently offer.

[sebbacon]

To me this meshes with the discussion about making custom analysis and measures into the same thing, and with custom groupings.

For any combination of numerator and denominator, I think a user should be able to see:

• Time trends with deciles;
• Maps;
• Single point in time as spine chart and/or histogram; and, per this proposal:
• Compare two points in time

And they should be able to do all of these at any grouping level, e.g.:

• All practices in a CCG
• All practices in an STP
• All PCNs in a Region
• All EHR software types in England

[brianmackenna]

Related to #1748

[HelenCEBM]

Agree @sebbacon - however it seems that could take some time to implement, so if this can be done relatively quickly it would be very useful