search

ebmdatalab / openprescribing

A Django app providing a REST API and dashboards for the HSCIC's GP prescribing data
https://openprescribing.net
MIT License
97 stars 26 forks source link

Allow users to breakdown analyse search results by component #391

Open lmfrench opened 7 years ago

lmfrench commented 7 years ago

Users would like the option to separate their analyse searches out into individual products if searching by a BNF section.

GP Pharmacists requested this as they wanted to be able to easily compare the prescribing of different products in their practice.

This would also work well with our price-per-pill work. People could use the analyse page to see trends over time for the brands/branded generics they are prescribing, and quickly see the impact of any schemes they have introduced.

Similar to #59 for the trends pages

sebbacon commented 7 years ago

I can see this would be beneficial but it needs some brainstorming on what the charts would look like. It would only make sense to subdivide the items/spending for a single CCG or practice, but at the moment the line charts show all CCGs in England or all practices in a CCG.

We've also discussed how the "hairball" is pretty useless on the line chart in any case. It might be better to replace non-selected CCGs-or-practices with deciles (as per measures).

If we did this (which is properly a separate issue) then adding subdivides on a line chart would not be compatible with also showing deciles, as it wouldn't make sense to show deciles for each subdivide. So the ability to show subdivides would probably become a toggle between that and showing deciles for the total.

If we implemented subdivides on the Trends pages, then this would largely be duplicating the functionality, leading me to wonder if we should be looking to merge Trends with analysis.

I don't have any answers yet, just making a note of the questions I've come up with so far when thinking about this.

lmfrench commented 7 years ago

Now that users can download their searches, perhaps we could add the option to download at product level even if searching at BNF section/chemical level.

This might work better once it is no longer mandatory to select a denominator

HelenCEBM commented 6 years ago

People wanting a csv with a whole chemical/para etc broken down into products/presentations is a common reason for them to need to request a custom extract, so could be useful as a download option.

Bengoldacre commented 6 years ago

addressed largely by fusing analyse page and measures.

brianmackenna commented 4 years ago

Myself and @inglesp have had a good use case for this feature when looking at our "hospital only measure". There has been a big drop off in prescribing in April 2020 but when you look at it on the analyse page its not possible to work out what has changed and too many to go through one by one the way the page is currently displayed.

(with this particular example an increase/decrease indicator on the "breakdown into individual presentation" might be a solution but also relevant to this issue)