We reviewed Helens LOS by patient ID broken down by observations and discussed the desire to show that as a stacked bar chart. This includes a discussion about the definition of what should be shown as the concept category for any period between observations.
We then looked at using an LOD to get point in time data – eg the last order sales, or the value of a patients last observation. And then we moved on to look at how to calculate when was the penultimate order date and return the sales value for that – or compare the latest “patient score” with their previous score to analyse increase or decrease.
We then reviewed aggregating dimensions with MIN, MAX and ATTR.