Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello guys.
I have 3 dimensions (93 x 107, 101 x 110, 113 x 122 ) on a List Box.
Each dimension have 3 points ( A=Begin, M=Middle, T=End).
I want to create a bar chart with all dimensions and all the points.
At each point i want :
Average
Target on average
Standard Deviation
Target on Standard Deviation.
Target on average & Target on standard deviation are prefixed values that QV reload them from script.
Until now i have create 3 separate bar chart for each value.
Expressions:
Average A
=If(WorkCenter_Descr='Σωλήνες της Πρέσας που προορίζονται για τους Πάγκους 1 & 3' and Dimension= '101 x 110' and MeasType='A' ,Avg(Dev))
Target on Average A
=If(WorkCenter_Descr='Σωλήνες της Πρέσας που προορίζονται για τους Πάγκους 1 & 3' and Dimension= '101 x 110' and MeasType='A' ,TargetYear.Tave)
Standard Deviation A
=If(WorkCenter_Descr='Σωλήνες της Πρέσας που προορίζονται για τους Πάγκους 1 & 3' and Dimension= '101 x 110' and MeasType='A' ,Stdev(Dev))
Target on Standard Deviation A
=If(WorkCenter_Descr='Σωλήνες της Πρέσας που προορίζονται για τους Πάγκους 1 & 3' and Dimension= '101 x 110' and MeasType='A' ,TargetYear.TStnd)
Average M
=If(WorkCenter_Descr='Σωλήνες της Πρέσας που προορίζονται για τους Πάγκους 1 & 3' and Dimension= '101 x 110' and MeasType='M' ,Avg(Dev))
Target on Average M
=If(WorkCenter_Descr='Σωλήνες της Πρέσας που προορίζονται για τους Πάγκους 1 & 3' and Dimension= '101 x 110' and MeasType='M' ,TargetYear.Tave)
Standard Deviation M
=If(WorkCenter_Descr='Σωλήνες της Πρέσας που προορίζονται για τους Πάγκους 1 & 3' and Dimension= '101 x 110' and MeasType='M' ,Stdev(Dev))
Target on Standard Deviation M
=If(WorkCenter_Descr='Σωλήνες της Πρέσας που προορίζονται για τους Πάγκους 1 & 3' and Dimension= '101 x 110' and MeasType='M' ,TargetYear.TStnd)
etc.
Is it possible to combine these 3 to 1 bar chart?
Like the below?
Best reagrds