I looked at your book and have questions
with respect to the first and second question you you are using a running total - but the expression needs a dimension to "run across'
there is nothing in the viz and therefore nothing in the table to run across
What was your expectation ?
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
I'm not tracking with you - in a business sense don't know what you are trying to show
I'm also not tracking with the analysis
the plot that you made without "Order id" in the vies is only a single data point (i.e. the underlying table is a single value
with that there is nothing to use in a running sum
if I drop order ID on the detail there are now a total of 5009 marks - which is the distinct count of all the orders in the d/b
the formula you are using to determine Bad or Good orders is based on percentile =.5
percentile works on the number of marks in the table - at .5 it returns the value at which 50% of the marks are above the value and 50% below
that said when you plot
this will always form a line of approximately 45% and will end at 100%
so going full circle - not certain what the business question is here and how to create a viz that will help with the understanding