Hi All,
Iam trying to find SD and UCL for the hours between 'Order date' and 'Ship date' in Quarter wise. So the 'hours' calc which is in Row shelf should not be Aggregated
so changed to dimension(Non-Aggr) but for finding SD and UCL iam summing it while using functions. Can someone please look into it and correct me where im making error.
Plz find dashboard attached
Thanks,
Sambi
Hi All,
Can anyone have a look into above Problem and I took UCL formula as UCL = Mean+(3*SD) and what am finding difficult is calculations on Non-Aggr field which placed in row shelf. Based on UCL i need to give Cond.Formatting like above UCL the color of data points should change.I tried to mockup data in above workbook which is replica of my issue..I got stuck here so experts pls guide me how to get over this issue