topic 100% Stacked bar chart (not adding to 100%). in App Development

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

Daryn — Tue, 19 Apr 2022 09:13:14 GMT

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

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

Vegar — Tue, 19 Apr 2022 09:47:10 GMT

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 )

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

Daryn — Tue, 19 Apr 2022 10:51:05 GMT

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)