Ok, this one is a bit tricky.

I want to create a chart with views that show me a single value from the content below.

So I have a content type with the following fields:

• category
• subcategory
• status
• index

As an example, these are the 4 nodes that I have now in the database:

category    subcategory status  index cars        a           1       1 cars        b           1       1 cars        c           1       1 cars        a           1       2 cars        b           1       2 boats       h           0       3 planes      k           1       1 

In my view I create a table with all the 4 fields except the subcategory and I also the status field aggregated as count. Also, the view is filtered by status == 1

I get this:

category    status  status(COUNT)   index cars        1       3               1 cars        1       2               2 planes      1       1               1 

What I need is:

1. For each category, only show for the greatest index;
2. Sum the number of status (COUNT) field;

So I basically need to get the value 3.

Is this even possible with views or it’s just an over complicated scenario and better to handle it with my own code?

Thanks.