Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I have written a Fractile expression and I want to use 2 set analysis's within the expression
Could soneone kindly take a look at the syntex and let me know where I am going wrong with the expression?
Time(Fractile( {<data_source_breaches={'Eye ED'}{$<FactDateNum = {">=$(=v_Start_Date_ED)<=$(=v_End_Date_ED)"}>} [Total Wait],0.95)/1440, 'hh:mm')
Kind Regards
Helen
Try:
=Time(Fractile( {<data_source_breaches={'Eye ED'}, FactDateNum = {">=$(=v_Start_Date_ED)<=$(=v_End_Date_ED)"}>} [Total Wait],0.95)/1440, 'hh:mm')
Hello
Thank you very much for your reply. However I am still returning Null values, although the expression is O.K
Thank you for your effort
Thanks
Helen
Try to post your sample qvw.