Unique Visits

[#1]

Hi All,

I have a requirement that i have to Count Distinct Students Attended in a Month, Next month and so on

so IF one student was attending the whole year it would be 12 Attends, Even if he was coming to school everyday?

[anbu1984]

Load StudentID,Year(DateAttended) As Year,Count(DISTINCT Month(DateAttended)) Group By StudentID,Year(DateAttended);

Load StudentID,Date#(DateAttended,'DD/MM/YYYY') As DateAttended Inline [

StudentID,DateAttended

100,1/1/2015

100,1/2/2015

100,2/2/2015

101,1/2/2015 ];

[#3]

Hi,

i want to use the code in Front End Expression on a straight table.

Regards.

[anbu1984]

In Front End,

Use StudentID,Year As dimension and Use Count(Distinct Month) as expression

Load *,Year(DateAttended) As Year,Month(DateAttended) As Month;

Load StudentID,Date#(DateAttended,'DD/MM/YYYY') As DateAttended Inline [

StudentID,DateAttended

100,1/1/2015

100,1/2/2015

100,2/2/2015

101,1/2/2015 ];