Search results

Hi there, I have 200,000 unique identifiers (for patients) and I'm trying to see whether they came back in to hospitals within 28days. So I have the unique identifier in one column and the dates in which they came in in another column. How can I write a formula which will look at the dates for...

Hello there, I am trying to use a format and conditional format to see if a target has been achieved. The formula / conditional format seems to work when there are number in the cells it is referring to, however, when the cells the formula refers to contains texts, it marks it as the target has...

Hi there, I have sparklines set up to feed off a pivot table. What I need to figure out is how to make it a rolling sparkline. For example, if the current month is March 2015, I want the sparkline to show January, Febuary and March 2015. If June 2015, I'd like the sparkline to display April...

Hi there, I'm trying to recreate Chandoo's KPI chart as per this link: http://chandoo.org/wp/2011/03/24/kpi-dashboard-revisited/ I can't seem to get my scatter markers to align (be in the centre) of the bar chart like in Chandoo's example I've attached my workbook, KPIChart_AS and Chandoo's...

Hi there, I'm trying to create a dashboard but am a little bit stuck. The objective of the dashboard is to show a manager's performance by month. I'm stuck on three parts of the dashboard: - I want to create an in-cell sparkline which will automatically update based with each month's newly...

Hi there, I need to answer the following questions but I'm not sure which formulas to use to achieve this: - proportion of doctors admitting 50% of all patients - proportion of patients admitted by the upper 50% of doctors - proportion of patient admitted by the lower 10% of doctors...

Hi, I have a dashboard that I've created using PowerPivot (OLAP cube). The dashboard updates daily to show current patients who are in hospital [today] and how many of them are at risk of readmission. This calculate a percentage of how many people are at risk. What I want to do is track on...

Hi there, I'm trying to develop a MDX calculated measure. I want to look at the most recent pathology results for a patient; however, a patient can have multiples of the same test done on different dates within the same hospital admission. I want Excel to give me the test result for the...

Hi all, I'm looking for way simple way to get the following information into one cell: I need to know the month names of the previous three months. So, if today's month is November, display text "Data is for months August, September, October." Thanks in advance for your help!

Hi there, I'm wondering if someone might have a work around/formula for what I’m trying to achieve. I need to get the “rolling” three month aggregate figures for a dimension - let’s say Falls (in column E of the table below), for the ward at each campus. The data looks as in the image...

Hi there, I'm comparing data from two different sources and need an efficient way to do it. I have one Excel workbook with two sheets - RAS EpSelect 0101-0106 and RAS HCP 0101-0106. Both worksheets have mostly the same data but is distributed over different columns. The data I'm using has...