Combine similar expressions from 2->1 bar chart failed to display data

[cmano]

Hello guys.

I have  a list where i select the Dimension (93x107 or 101x110) and i created 2 bar charts with below expressions:

1 chart:  

=If(WorkCenter_Descr='Σωλήνες της Πρέσας που προορίζονται για τους Πάγκους 1 & 3' and Dimension= '93 x 107' and MeasType='A' ,Avg(Dev)) 

2 chart:   

=If(WorkCenter_Descr='Σωλήνες της Πρέσας που προορίζονται για τους Πάγκους 1 & 3' and Dimension= '101 x 110' and MeasType='A' ,Avg(Dev))

I tried to create one bar  chart with both dimensions . 

When i choose from the list the 2 dimensions together chart can not display  data. If i pick one by one is okay?

Y axis & X axis are the same

Why its happening?

Thank you.

[deepanshuSh]

What expression are you using for the combined bar chart, that would affect the results that you are getting.

And secondly, the dimension that you are referring here is two values of the same dimension or completely two different dimensions?

[cmano]

I want to take the average.

i have this filter (with 3 choices): 

I have the expressions in the same bar chart:

=If(WorkCenter_Descr='Σωλήνες της Πρέσας που προορίζονται για τους Πάγκους 1 & 3' and Dimension= '101 x 110' and MeasType='A' ,Avg(Dev))

=If(WorkCenter_Descr='Σωλήνες της Πρέσας που προορίζονται για τους Πάγκους 1 & 3' and Dimension= '93 x 107' and MeasType='A' ,Avg(Dev)) 

List box:
Click only on : 93x107  see left image (i get data)

Click  only on : 101x110  see right image (i get data)

List Box
Click both : 93x107 & 101x110

 No data display...

 Any ideas?

Best regards

[RafaelBarrios]

Hi @cmano 

i think you are not doing it in the correct way.

what you are using as expression only going to works if you select a dimension value.

so,  what i think to need is the following:

use the field "Dimension" as dimension of the chart and as expression

Avg({< WorkCenter_Descr={'Σωλήνες της Πρέσας που προορίζονται για τους Πάγκους 1 & 3'},MeasType={'A'}   >}Dev)

it should show 3 bars, 1 for each dimension value.

OR

if you still want to use different expressions:

Dont set any dimension in the char

expression1

Avg({< WorkCenter_Descr={'Σωλήνες της Πρέσας που προορίζονται για τους Πάγκους 1 & 3'},MeasType={'A'},Dimension= {'93 x 107'}   >}Dev)

expression2

Avg({< WorkCenter_Descr={'Σωλήνες της Πρέσας που προορίζονται για τους Πάγκους 1 & 3'},MeasType={'A'},Dimension= {'113x 122'}   >}Dev)

expression3

Avg({< WorkCenter_Descr={'Σωλήνες της Πρέσας που προορίζονται για τους Πάγκους 1 & 3'},MeasType={'A'},Dimension= {'101 x 110'}   >}Dev)

Best,

[cmano]

Hello @RafaelBarrios that worked thank you.
But they want some additions (target on average, sd & target of sd:
i have create this :

Expressions : 

A

=If(WorkCenter_Descr='Σωλήνες της Πρέσας που προορίζονται για τους Πάγκους 1 & 3' and Dimension= '93 x 107' and MeasType='A' ,Avg(Dev))

=If(WorkCenter_Descr='Σωλήνες της Πρέσας που προορίζονται για τους Πάγκους 1 & 3' and Dimension= '93 x 107' and MeasType='A' ,TargetYear.Tave)

=If(WorkCenter_Descr='Σωλήνες της Πρέσας που προορίζονται για τους Πάγκους 1 & 3' and Dimension= '93 x 107' and MeasType='A' ,Stdev(Dev))

=If(WorkCenter_Descr='Σωλήνες της Πρέσας που προορίζονται για τους Πάγκους 1 & 3' and Dimension= '93 x 107' and MeasType='A' ,TargetYear.TStnd)

M

=If(WorkCenter_Descr='Σωλήνες της Πρέσας που προορίζονται για τους Πάγκους 1 & 3' and Dimension= '93 x 107' and MeasType='M' ,Avg(Dev))

and etc.

But they want something like these:

Able to see for each MeasType (A,M,T) per Dimension is it possible?

thank you