3 Replies Latest reply on Nov 15, 2018 8:15 AM by Akram Ebrahim

# Number of children who do not repeat

Hİ,

How I can calculate the number of children attending in our classes, among months unrepeated. As shown below, I tried to calculate the number of participants from two centers by using polling date (Centers: Boynuyoğun and K.maraş),in grand total I can get 2.013 unrepated number (by use count distinct) I want to show the calculation of this number month by month. It is important that there is different calculation method between in a month and grand total because the calculation is repeteadly in each months but not in grand total (unrepeateadly).

• ###### 1. Re: Number of children who do not repeat

Hi Erkan,

Try this calculated field below:

{INCLUDE Datetrunc('month',[Date dimension]),Isim : COUNTD(Children Dimension)}

• ###### 2. Re: Number of children who do not repeat

Thanks for your help Mr Akram Ebrahım. I tried your formula, but ıt dıdn t give the result which ı want. You can see the result below.

• ###### 3. Re: Number of children who do not repeat

Hi Erkan,

The problem is,

This month children1 to children10 attended the classes. -> Count 10

Consider only 2 new children have joined this month. So same 8 children (Children 1 to 8) also they attended the classes for last month as well.

Here the same name will reappear on the each month, if you watching them month on month they will be present unique in all three months .

Ex: Countd(Children Name)

For Each Month

------------------

Nov-18 : 10

Oct-18: 8

Sep-18: 8

--------------------

Grand Total = 10 ( Actual Children)

----------------