7 Replies Latest reply: Sep 5, 2016 11:38 AM by David Arroyo de la Peña RSS

    Count problem

    David Arroyo de la Peña

      Hello,

      first of all I apologize because I can't upload an example app of this matter. So I'm going to write a paralel example of my problem.

       

      Imagine a table with the following fields:

       

      MONTH: month when a person has travelled

      PERSON: person who has travelled

      TRAVELTYPE: business/pleasure

       

      Persons can travel each month for business, for pleasure, both, or no travel. So records would seem like that:

       

      JANUARY - PERSON1 - BUSINESS

      JANUARY - PERSON1 - PLEASURE

      JANUARY - PERSON2 - BUSINESS

      FEBRUARY - PERSON1 BUSINESS

      FEBRUARY - PERSON2 - PLEASURE

      FEBRUARY - PERSON3 - BUSINESS

      ...

       

      I need to configure a pie chart showing persons that never has travelled for pleasure. In my example data would be a pie chart showing 1 person with no pleasure travel (PERSON3) and 2 persons with some pleasure travel (PERSON1 and PERSON2).

       

      I've been trying with a "PleasureTravelCounter" 0/1, but I don't get it.

       

      Any help in spite of my explanation?

       

      Best regards,

      David.