Visualise Daily Incidences

1 Problem Statement

A large number of incidences occurring over a long timeframe can make it challenging to spot trends.
The example shown is for daily incidence reporting over a year, but is adaptable to other timeframes.

2 Suggested Approach

We suggest a hybrid of the following techniques:

A	Listing Listing the number of incidences each day, with days arranged in a calendar format. Conditional formatting is used to identify at a glance relatively better/worse days
B.	A calendar is included alongside to enable quick references to specific dates
C.	Daily/weekly averages are shown above/beside the calendar listing
D.	Daily/weekly average charts are shown at the top

3. Rationale and Commentary

4. Applicability and Alternatives

5. Implementation

The case study was produced using Excel and an example workbook is at TODO LINK.

• The data consists of a date and number of incidences assigned to each date
• Sparklines are used to produce daily/weekly averages
• Conditional formatting is used to colour the number of incidences
• More complex conditional formatting is used to create the calendar so that other years or calendars starting on  other days can be quickly shown

6. Context

7. Tags

8. Document Control

Table