Show total of votes by membership type and weight in a consultation

[sauloperez]

Description

- As an: admin
- On page: /admin/consultations/<consultation_name>/results
- I want to be able to do:

• See the number of votes by membership type and for each question
• See the number of votes by membership type and weight for each response

Acceptance Criteria & Tests

The admin needs to be able to see how many votes of each membership type each of the possible responses received, along with their particular weights. For example, in a coop with consumers and producer members, each response should show the count of votes from consumers and the count from producers and display which weight within the coop they have.

[sauloperez]

The easiest approach to prototype this would be to add subitem in the sidebar to leads the admin to our separate results page so we don't deal with the core's calculations.

[sauloperez]

This is a sample of the results table we want

Membership type	Weight	Answer	Number of votes
Consumer	2	Si	3
Consumer	2	No	1
Producer	1	Si	1
Producer	1	No	1
Producer	2	Si	2
Producer	2	No	0

[sauloperez]

Platoniq/decidim-verifications-direct_verifications#2 enables us to query like:

SELECT metadata->>'type' AS type, count(*)
FROM decidim_authorizations
GROUP BY metadata->>'type'

    type    | count 
------------+-------
 consumidor |     1
 productora |     1
(2 rows)

so we should be all set 👌