Home Forums From Data to Dashboards Winter 2021 Discussion 3 (DTDW21) Reply To: Discussion 3 (DTDW21)

Rebecca Smeltzer

The best type of graph to show ranking is a bar/column graph. To make ranking very clear to see, the pivot table can be formatted to display the service categories ranked in descending order of claims, this will create a pivot chart with the bars also displayed in proper ranking order (service category with the highest number of claims to the lowest). For both the Northern and Eastern Zones, Curative Care Visits have the most number of claims, 1110 claims and 987 claims, respectively. For the Northern Zone, Speech Therapy is ranked last with only 1 claim, while in the Eastern Zone Inpatient Medical and Inpatient Obstetrics are ranked last, both with 2 claims.