# Presenting TOP 10 diseases (Number of in-patients by diseases) in our hospital

D

#### D.Salman

Dear Experts,
Kindly, I am looking for a way to present (by using one of the available graphs) the TOP 10 diseases (Number of in-patients by diseases) in our hospital on a quarterly basis, the problem is, if I want to compare between first and second quarters, sometimes a certain diseases is one of the TOP 10 in Q1 and not one of the TOP 10 during Q2, so how can I depict this issue?

#### Jen Kirley

##### Quality and Auditing Expert
Staff member
Re: Presenting TOP 10 diseases

I wouldn't make this harder than it needs to be.

If you are comparing the same diseases from time period to time period, I would use a histogram with paired bars or stacked bars.

If one or more of the top 10 diseases is replaced by a different one, you could use two histograms; one for each quarter.

I would be tempted to add another bar to the stacked or paired bar histogram; one of the original 10 would show the first quarter's figure only, while the 11th would show the second quarter's disease only. It seems to me this would most clearly communicate the trending from one period to the next.

C

#### chergh - 2008

Re: Presenting TOP 10 diseases

Another option may be to use pie charts.

With a pie chart you could show the top 10 as individual segments and have an 11th segment as others. You can then use a split to give a breakdown of the others. i have attached an example of what I mean as I don't find it easy to explain.

#### Attachments

• 21.5 KB Views: 187

#### Jim Wynne

Staff member
Re: Presenting TOP 10 diseases

Dear Experts,
Kindly, I am looking for a way to present (by using one of the available graphs) the TOP 10 diseases (Number of in-patients by diseases) in our hospital on a quarterly basis, the problem is, if I want to compare between first and second quarters, sometimes a certain diseases is one of the TOP 10 in Q1 and not one of the TOP 10 during Q2, so how can I depict this issue?
A different chart for each quarter?

#### Darius

##### Quite Involved in Discussions
Re: Presenting TOP 10 diseases

Agree with Jennifer
If you are comparing the same diseases from time period to time period, I would use a histogram with paired bars or stacked bars.
....
I would be tempted to add another bar to the stacked or paired bar histogram; one of the original 10 would show the first quarter's figure only, while the 11th would show the second quarter's disease only. It seems to me this would most clearly communicate the trending from one period to the next.
But take in account, staked bars gives you the view to the trend, paired bars gives you the view to the comparison.

Maybe I would use both or add a line trend to the paired bars chart in wich I could add the "stacked" value.

D

#### D.Salman

Dear Experts,
I have attached the available data, you can see that diseases F available in quarter one but not available in quartet two, we have a new diseases which is Z.
Kindly, can you educate me, because till know I didn’t get the idea?

#### Attachments

• 14 KB Views: 513

#### Coury Ferguson

##### Moderator here to help
Staff member
Super Moderator
Maybe try using a Pivot Table, using the existing data in the sheet. The Pivot Table can be "drilled down" to specifically identify certain things. It will also change when the data has been modified.

I was playing with the sheet attached, but it wouldn't create a Pivot Table. I will play with it some more, to see if I can create the Pivot Table and attached the file here.

#### Darius

##### Quite Involved in Discussions
This is the way I see it

Paired bars and "trend" (aka increment / decrement of the particular sickness).

#### Attachments

• 21 KB Views: 344
Informational I am presenting a webinar Thursday - "Data Driven Decision Making" - 19 November 2020 Statistical Analysis Tools, Techniques and SPC 5
T Visually Presenting Effectiveness of Multiple Corrective Actions Nonconformance and Corrective Action 4
Q Presenting the Root Cause result in a one slide .ppt Powerpoint file Problem Solving, Root Cause Fault and Failure Analysis 8
E Internal Audits - Presenting Audit Findings to Upper Management General Auditing Discussions 19
Draft FDA Guidance on "Presenting Risk Information in Prescription Drug and Device" US Food and Drug Administration (FDA) 1
K Format for presenting capability study results? Statistical Analysis Tools, Techniques and SPC 7
What shoud i do if our company top management has been changed. Oil and Gas Industry Standards and Regulations 8
Example Process orientation to the process leadership, management, goals (tasks of the top management) ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 10
OSHA Top Ten webinar, March 31 (free online) [Deleted] Misc. Quality Assurance and Business Systems Related Topics 1
Top 10 operational risks of 2019 for business continuity planning Business Continuity & Resiliency Planning (BCRP) 6
Resources for Planning for top quality Business Continuity & Resiliency Planning (BCRP) 6
Informational ISO 13485 Certificates Top 10 Countries - 2004 to 2017 ISO 13485:2016 - Medical Device Quality Management Systems 0
Informational ISO 14001 Certificates Top 15 Countries - 1999 to 2017 ISO 14001:2015 Specific Discussions 3
Functional Gage for TOP applied at RFS Design and Development of Products and Processes 5
Doing both a top-down and a bottom-up risk assessment - How to combine ISO 14971 - Medical Device Risk Management 6
Is CE Mark needed for a small DAC audio board on top of a Rasberry PI? CE Marking (Conformité Européene) / CB Scheme 1
About ionizers - How far can we place a table top ionizer from the IC devices Manufacturing and Related Processes 1
Medical Device News ECRI – 2019 Top 10 Health Technology Hazards Medical Device and FDA Regulations and Standards News 0
Top Management Change Prior to Certification ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 12
Top 10 Major and minor NC's during IATF 16949:2016 Audits IATF 16949 - Automotive Quality Systems Standard 8
Q Risks Examples in Top Management ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 7
Q Additional KPI to Top Management beside Quality Objectives ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 6
Top Executive Management ISO 9001:2015 and IATF 16949 Overview IATF 16949 - Automotive Quality Systems Standard 4
What defines Top Management after a Merger? Quality Management Review (9.3.1) Management Review Meetings and related Processes 1
Root Cause Challenge: The guy at the top ... Problem Solving, Root Cause Fault and Failure Analysis 4
ECRI Top 10 Health Technology Hazards for 2017 Other Medical Device and Orthopedic Related Topics 3
L Auditing Top Management - Meeting Competency Requirements and Questions to Ask General Auditing Discussions 11
Q Who can Change goals and kpi of top management? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 8
Engaging Top Management ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 8
15 minute Top Management presentation on ISO 9001:2015 ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 23
FTA-Top/Down approach to Risk Analysis ISO 14971 - Medical Device Risk Management 2
OHSAS 18001:2007 4.4.1 Top management appointee Occupational Health & Safety Management Standards 8
A Creative ways to access Expert Information when you can't afford a top \$ Consultant Misc. Quality Assurance and Business Systems Related Topics 7
D Best Engineering Practices related to Top Assembly Drawings Document Control Systems, Procedures, Forms and Templates 6
R Performance Qualification on a Table Top Centrifuge ISO 13485:2016 - Medical Device Quality Management Systems 3
Can an Auditor question Top Management decision to approve deviation? IATF 16949 - Automotive Quality Systems Standard 30
Differences between Top Management, Management & Organization ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 5
ISO 9001:2015 Structure - Top Level Clauses ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 18
T Uncertainty (Top Down Method)! Auditor argues that this is not enough Measurement Uncertainty (MU) 14
Redundant BOMs - Maintaining a Reference Only BOM on our Top Level Assembly Drawings Document Control Systems, Procedures, Forms and Templates 7
C Recommended Sealing for Granite Top in a Clean Room US Food and Drug Administration (FDA) 1
"Top Gear" (UK) Jeremy Drives a Reliant Robin Funny Stuff - Jokes and Humour 8
M The requirement for Communication via Top Management Quality Manager and Management Related Issues 4
FWIW: Top Reported OSH Violations Occupational Health & Safety Management Standards 5
ISO Systems Annual Report to Top Management example wanted IATF 16949 - Automotive Quality Systems Standard 10
M Helping Top Management Prepare for an ISO 14001 Audit ISO 14001:2015 Specific Discussions 4
Quality Policy without Top Management Signature Quality Manager and Management Related Issues 37
Questioning Top Management on The Quality Policy during Internal Audits Internal Auditing 7
B Categorization of Customer Complaint: Making Customers feel they are Top Priority Customer Complaints 4
L QMS for Service Company - Top Management wants to take the role of QMR Quality Manager and Management Related Issues 5