Splitting a Tie! (A97)

Topic

New Reply

I have used Top Values = 10 in a query to select data for a Pareato Graph. For the most part this works fine but if there is a tie for 10th and 11th place then the query returns 11 results and spoils my graph

I have thought of adding a very small random number to the results, which would break the tie but be small enough not to affect the apparent result. The problem is that this does not cure the problem but just reduces the probability of it happening.

I was wondering if anyone has another approach to this problem?

Peter

Reply | Quote

Replies

In your query, add a field with an expression that combines your value field formatted with 0 and any other field you know will be different. ex an ID field that you also format with 0. Sort the query on this new expression. something like this:
Expr1: Format([ValueField],”000000″) & Format([IDField],”000000″
Be sure to have enough 0 to cover the greatest number of digits in the fields.

Reply | Quote

Thanks Francois, will give that a try

Peter

Reply | Quote