Combine data from 3 different charts

cmano — Tue, 11 Oct 2022 06:48:09 GMT

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

topic Combine data from 3 different charts in App Development