Initially we reviewed Helens solution for looking at the next observation date so tjat we could map our a patient pathway based upon their changing status’s.
We then ran through 5 different ways to drill down through data, from the simplest method first:
1. Using hierarchies
2. Using dashboard filter actions
3. Using viz in tooltips
4. Using drill to another dashboard
5. Using single member drill through within a worksheet
so that we can select the most appropriate way for our use case and our user.