100% Stacked bar chart (not adding to 100%).

[Daryn]

Hi, once again I am troubling the experts! 

Thanks to Or's help I have my OTIF measures. However trying to get the stacked bar charts to total 100% is proving to be another challenge.

I have read several questions & answers and reviewed 'Total' but still seem to be missing something!

My dimension is a date.

= Date ([ERDAT.autoCalendar.YearMonth], 'MMM.YY')

I have three separate measures for my OTIFS.

Early:   

COUNT ( (IF ([WADAT_IST] < [WADAT],VBELN ))) / COUNT (VBELN )

On Time:

COUNT ( (IF ([WADAT_IST] = [WADAT],VBELN ))) / COUNT (VBELN )

Late:

COUNT ( (IF ([WADAT_IST] > [WADAT],VBELN ))) / COUNT (VBELN )

Results in >

I have tried the following variation with each of my measures (just changing the <,=,> per measure)

count (IF ( [WADAT_IST] = [WADAT], VBELN )) / COUNT ( TOTAL <[ERDAT.autoCalendar.YearMonth]>  (VBELN))

Results in >

Thank you all in advance for any help, suggestions or a solution!

Regards

Daryn

[Vegar · Accepted solution]

It could be that you are missing WADAT or WADAT_IST for some of your data points. You need to investigate your data. I suggest you create a straight table with a couple of relevant dimensions (Such as year month) and the following measures to start your investegation.

• Early:   COUNT ( (IF ([WADAT_IST] < [WADAT],VBELN ))) 
• On Time: COUNT ( (IF ([WADAT_IST] = [WADAT],VBELN )))
• Late: COUNT ( (IF ([WADAT_IST] > [WADAT],VBELN )))
• Total: COUNT (VBELN )

[Daryn]

Thank you Vegar for taking the time to help and respond. You are correct (of course), there do appear to be some blank  WADAT_IST entries!  I will have to see if they can be resolved. Appreciated.

Regards, Daryn.

PS. For now I got around that (using nullcount)