
Re: Diagram formula: Finding lowest Distance
Manish Kachhia Jul 3, 2015 11:31 AM (in response to Sabrina Richter )Sorry for (may be) a stupid question... !
How can we know that a company is closed
Can you provide one simple example for any order from your qvw?

Re: Diagram formula: Finding lowest Distance
Sabrina Richter Jul 3, 2015 11:49 AM (in response to Manish Kachhia )In this example there is just one Company which can be closed (OrderCompany). It maybe would make more sense to just close one of the two OrderCompanyDepartments. You can both select them in the green textbox. There, a selection means it is closed.
So you may "close"  or select Department 0200 which contains 2 orders.
Now the tables on the bottom should show, where the order are moved to according to the lowest distance Of course, "closed" companies must not be selected as "new". I may provide a bit more data > new example here!
Table with red box on the left:
lowest distance works (is it right?)
the company does not work (for Order 96288 it has to 521186215 (the lowest distance  company is closed) and for order 96761 company 521101145).
Table on the left:
Has to show these companies with both "1" as new Order in this example.

example.qvw 227.8 K

Re: Diagram formula: Finding lowest Distance
Stefan Wühl Jul 3, 2015 1:01 PM (in response to Sabrina Richter )For order 96761, isn't the new company #521183053 with a distance of 14,47?

Re: Diagram formula: Finding lowest Distance
Stefan Wühl Jul 4, 2015 6:25 AM (in response to Stefan Wühl )For department 0100, there seem to be AllCompanies with equal minimum distance. Which one should be chosen then?
edit:
Here is a demonstration of that observation. Multiple Allcompanies with same min distance.
Since I don't really understand how you get to these distances, you'll need to clarify / decide.

comm171160.qvw 228.8 K

Re: Diagram formula: Finding lowest Distance
Sabrina Richter Jul 6, 2015 2:15 AM (in response to Stefan Wühl )Well,
thank you very much! This is exactly what I was searching for. The problem with same minimum distances is a special one which we did not make a decision on it, yet. For instance, could you "just" tell me, how the count (distinct order) formula would look like if we take the statistical approach (one order which has two companies with same distance goes with 0.5 to each of them?)?
That would be great!
Thank you very much!

Re: Diagram formula: Finding lowest Distance
Stefan Wühl Jul 6, 2015 7:22 AM (in response to Sabrina Richter )That's not trivial.
Maybe like attached....

comm171160_2.qvw 229.5 K





