View Single Post
 
Old 11-25-2014, 05:40 AM
andytheanimal andytheanimal is offline Windows 7 32bit Office 2010 32bit
Novice
 
Join Date: Oct 2014
Posts: 10
andytheanimal is on a distinguished road
Default Visual Graphic of contacts with a service

Hi all, I'm looking for a visual representation of how many times and lengths, that someone uses a service.

My data strucutre will in effect be a crosstab with dates and 4 types of service. Some services can be used multiple times a day (so I would need to have a visualisation that this occurs) and one service, the patient may stay for a number of days so I need to show this length.

I've started the attached to give an idea of my data structure. For multiple service uses on the same day, I've assigned them values of 1 and 1.5 to distinguish that they're still in service 1, but allows the visual representation to show that they're different. Hope this all makes sense, very hard to explain!
Attached Images
File Type: png Untitled picture.png (55.0 KB, 13 views)
Reply With Quote