I've tried taking out the serial number from the data but it still agggregates at the sub sub level...
I just learned something new: count distinct does not work on live connections to excel, access etc. So after i created an extract, I can do count distinct. i created a new field grouping the order number and description as a string and chose count distinct. This shows the correct values for number of orders but can't figure how to do a calculation based on this to yield the on time percentage i am looking for
Got the viz to come out right, but took a lot of ridiculous, tortuous calculations. Will upload the packaged workbook "On Time 2".
If anyone has a more elegant solution, will still appreciate some feed back.