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

Improve this question
7
  • 1
    Have you set up group by in views?
    – Jayendra Kainthola
    Commented Nov 21, 2013 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
    Commented Nov 21, 2013 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?
    – Jayendra Kainthola
    Commented Nov 21, 2013 at 11:17
  • I am not sure what you mean by require output. I am new to drupal (8 weeks)
    – Miphesto
    Commented Nov 21, 2013 at 11:21
  • Please try this after removing grouping.
    – Jayendra Kainthola
    Commented Nov 21, 2013 at 11:39

2 Answers 2

Reset to default
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.

Improve this answer
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
    Commented Nov 22, 2013 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.)
    – Craicerjack
    Commented Nov 22, 2013 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
    Commented Nov 22, 2013 at 9:41
  • as noted in this article do you have any default sorts set?
    – Craicerjack
    Commented Nov 22, 2013 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
    Commented Nov 22, 2013 at 10:17
-1

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

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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