need help by set analysis

[maternmi]

Hello,

I need help by set analyses.

I would like to display the pickup reliability for each selected month in comparision to the total amount of order in this month, unfortunately I don't know how. What I get is the pickup reliability of each month in comparison to the total amount of orders of all selceted months.

The field Pickup_Reliability_Type contains 3 value types, a) not relevant, b) reliable, c) unreliable

The ID is "%VBELN.%UEPOS", its combination of order number and order position

The month filed  C_MonthYear is combination of month and year

My dimensions are C_MonthYear and Pickup_Reliability_Type

I used following expression in the bar chart:

count({$<Pickup_Reliability_Type = {'reliable'}>} distinct %VBELN%UEPOS) / count({$<Pickup_Reliability_Type = -{'not relevant'}>} distinct total %VBELN%UEPOS)

I hope you can help me.

Thanks!

BR

Michael

[tresesco]

For 9.2013 I find 31% logical. Can you please explain the logic of expecting 40% (w.r.t. your sample app)?

[maternmi]

If you select only 09.2013 you will get a pickup reliability of 40% (4 of 10 orders) --> is the correct value

If you selct two or more months then the pickup reliability changes to 20% (4 of 20 orders ) or to 13% (4 of 30 orders) because  the 4 relialbe orders from Semtember will be divided through the total order amount of all selected months.

How can I show in one chart the reliability of each month?

Sep: 04 of 10 orders = 40%

Okt; 06 of 10 orders =60%

Nov: 03 of 10 ordes =30%

[tresesco]

Michael Matern wrote:

If you select only 09.2013 you will get a pickup reliability of 40% (4 of 10 orders) --> is the correct value

If I select only 09.2013, I get 31% !

[maternmi]

Hi,

have you change anything on the expression?

count({$<Pickup_Reliability_Type = {'reliable'}>} distinct %VBELN%UEPOS) /count({$<Pickup_Reliability_Type = -{'not relevant'}>} distinct total %VBELN%UEPOS) 

Best regards,

Michael

[stabben23 · Accepted solution]

Hi put in <C_MonthYear> after distinct total

//Staffan

[maternmi]

Hi Staffan,

very simple! Thanks! Have you any document which explain the set analysis?

Best regards,

Michael

[stabben23]

Hi Michael,

Not what I know, but this means that you calculate only on this dimension in the total. You can use sevral like <Dim1,Dim2,Dim.....>.

//Staffan

[maternmi]

Hi Staffan,

Thanks!

Michael