EventStats will convert your raw temporal data into capacity planning intelligence. Start by supplying EventStats with a dataset with start-end dates (ie admissions) or just single date points along with 1 or more dimensions (ie patient id, hospital number, Snomed code). You can also provide data fields to count or average, such as a mortality flag or an in-patient cost field.
Choose your analysis parameters, ie by day, by hour, which dimension fields to use & group by & which data & function to use and Event Stats will show you the graph, pivot & raw data.