2

Need to count field specific value in Views. I have 2 content types "project" and "task" In the task i have reference field for project (assign task to project) And another field "task_status" as a list: closed / open

I want to calculate the closed and total tasks so i can get the results in percentage:
closed_task / total_task * 100 How can i get the count for closed tasks value ?

Sorry for my bad English :)

0

You first create a views to show the list of open or closed task.

create a views with content type "project" remove all field then add a relation on task referenced field ,add title field with consider that you select relation field for it (because we want load task title instead of project title) then add filter "task_status" equal to close,then enable exaggeration and on title.and finally for better result you can get the title(or nid ) of project with contextual filter . it help you you can get only the list of tasks form specified project.( and finally create another page in that views with only one change, status=open ).

  • Thanks zhilevan ! I need to count the total and the closed task for that project. How can you do Math expression from one view to another ? – Schiwe Jun 14 '15 at 9:14
  • not it is not need, you can use https://www.drupal.org/project/views_field_view – Yusef Jun 14 '15 at 12:15

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.