Hello Lei Chen,
Thanks for your advice. It was great learning how to use LOD expressions.
I made a few changes on my calculations and got the data I wanted:
First, getting my Delivery analysis by SO:
Then getting it by SO Item:
Now I need to get a Graph (could be Pie, Bar, etc), that could show me what is the percentage of DIFOT in general, i.e., including 2 or more SO's... or even given a certain period of time.
I made several tentatives, but could not achieve any satisfactory result.
Could you provide some more sample data, so that I will be able to explorer more with the viz.
I created a Worksheet where I see the DIFOT report:
When I try to create a graph based on this data, this is what I usually get (which is not correct):
I need a pie graph that shows me only the percentage of Sales that were delivered on time and the percentage that were not delivered on time.
And when I remove the Sales Order from the filter, the report get even worse:
Not sure what I am doing wrong here.....
Your support is very much appreciated.