Hello
I am struggling to get something new I need to add to work in my
pivot table
My data is at the lowest granularity and is at person level
I have built an inline statement in my script
Part of my in_line statement is:
Inline_Monthly:LOAD *, autonumber(Level1_Month&'#'& Level2_Month&'#'& Level3_Month&'#'& Level4_Month,'Inline_Monthly_Key') as Inline_Monthly_Key INLINE [
'Level Order_Month', 'Levela Order_Month', Level1_Month, Level2_Month, Level3_Month, Level4_Month,
3, 1, 'TOTAL TIME SPENT IN A&E DEPT','ADMITTED', '95TH CENTILE', '<=04:00'
I then start looking at my in_line statement and start assigning data
concatenate
(Inline_Monthly_Data)
loadautonumber
('TOTAL TIME SPENT IN A&E DEPT' &'#'&'ADMITTED' & '#' &'95TH CENTILE' &'#' & '<=04:00','Inline_Monthly_Key') as Inline_Monthly_Key,
MonthYear as Inline_Monthly_MonthYear,
[Total Wait] as Inline_Monthly_Data_A,
'ED' as Inline_Monthly_DataSource
Resident main_data
where 'MAIN_ED_PostQVD' = data_source
and [Patient Admitted?]=1
and ED_Adult/Paeds = 'Adult'
;
I then have a pivot table which references the assigned auto number:
if (Level3_Month='95TH CENTILE',time(Fractile({<Inline_Monthly_DataSource={ 'ED'} >} Inline_Monthly_Data_A,0.95)/1440,'hh:mm')
I have been asked to provide a list box where the user can select between Adult/Paediatrics, so I thought I would simply need to add an extra line to the script (Highlighted) in red and then right the script again, but where ED_Adult/Paeds = 'Paediatrics'
For some reason my efforts have not worked. Based on the information provided can anyone help me get this right so the user can select Adult or Paeds from a list box?
Thanks
Helen
