0

I have created a points table for a race event and would like to sort the results in a specific order.

I am working with a table view that contains 3 sort criteria:

  1. the race event (working fine done via table settings)
  2. class of a car A, B , C and
  3. the points each driver receives.

I would like the order to be A then points B then points C then points regardless of what class has the highest points.

Problem:

If for example a C class car has points higher than any B class car then the stacking order is ACB. As soon as any B class car gets higher points than the C class car then the order is ABC (how I would like it). This can be seen in class A where Driver 2 has the lowest points of all.

I have tried re arranging the sort order but that does nothing.

Screen shot of the problem

7
  • 1
    Have you set up group by in views? Nov 21 '13 at 9:46
  • Hi Molot, Thank you for the quick reply. Yes in the table settings I have grouped by Event then by Class
    – Miphesto
    Nov 21 '13 at 11:07
  • I think, the issue is that you have grouped the element. Could you share your require output, so we can suggest you alternative? Nov 21 '13 at 11:17
  • I am not sure what you mean by require output. I am new to drupal (8 weeks)
    – Miphesto
    Nov 21 '13 at 11:21
  • Please try this after removing grouping. Nov 21 '13 at 11:39
0

Can i suggest removing the grouping and getting the single table to display as you would like it and then once you have done that apply the grouping. It sounds as if youre sorting by points not by car class - can you change the sort to car class then add the group.

Or group by event and then sort by car class and points.

6
  • I removed all the grouping other than event. I added sort by car class and it sorted by car class. As soon as points are introduced into the sort criteria it overrides the car class and sorts by points. Numbers appear to take precedence over letters
    – Miphesto
    Nov 22 '13 at 9:26
  • in your view can you rearrange the sort so that the sort by car class is on top of the sort by points? (in the sort box click on the arrow on the add button and it should give you a rearrange option.) Nov 22 '13 at 9:37
  • That was the first thing I tried and it made no difference. As soon as points are introduced into the sort, it takes precedence.
    – Miphesto
    Nov 22 '13 at 9:41
  • as noted in this article do you have any default sorts set? Nov 22 '13 at 9:49
  • Thank you Craicerjack I added a relationship to the vocabulary and added weight to the vocabulary as mentioned in the article. Added the relationship to the Car class in the sort criteria and now I have grouped class A B C then points in the class..... Many Thanks to all for the help Best Regards Alan
    – Miphesto
    Nov 22 '13 at 10:17
-1

You can use hierarchical select module which has good option for customizing the hierarchical points

2
  • Hi Manu kumar, Thank you for the quick reply. I will have a look at this
    – Miphesto
    Nov 21 '13 at 11:08
  • I think, Hierarchical select will not use in this condition. Its only sort the select box, not view result. Nov 21 '13 at 11:16

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.