On Time In Full Percentage Wise

[#1]

Hello Everyone,

I need to devlop a chart showing otif percentage values

below is my sample data

PO ID	Quantity	Delivery date
1212	50	10/1/2012
1213	50	13/1/2012
1214	50	15/1/2012

PO ID	Quantity delivered	Actual Delivery Date
1212	50	11/1/2012
1213	40	13/1/2012
1214	50	15/1/2012

i need to delevop charts with like below one

Header 1	Header 2
Ontime	66.66%
OnFull	66.66%
OnTime OnFul	33.33%

Can some one help me out

[#2]

He Vikram,

You could try joining the tables.

And then create flags for ontime,onfull and  OnTime OnFull.

For example:

If(Delivery Date=Actual Delivery Date and Quantity<>Quantity delivered,1,0) as Flag_OnTime

If(Delivery Date<>Actual Delivery Date and Quantity=Quantity delivered,1,0) as Flag_OnFull

If(Delivery Date=Actual Delivery Date and Quantity=Quantity delivered,1,0) as Flag_OnTimeOnFull

Hope this helps.

Gr.

Frank

[swuehl · Accepted solution]

Creating some flags in the script is probably a good idea.

If you want to do it in the front end, you can start with creating a straight table chart with no dimension and three expressions:

=count(if([Delivery date]=[Actual Delivery Date],[PO ID])) / count([PO ID])

=count(if(Quantity=[Quantity delivered] ,[PO ID])) / count([PO ID])

=count(if([Delivery date]=[Actual Delivery Date] and Quantity=[Quantity delivered],[PO ID])) / count([PO ID])

Set an appropriate number format for the percentages in number tab and check 'Horizontal' option in presentation tab.

Regards,

Stefan