Count Expression

[vikasgupta]

Hi friends

I have following data set :

Name   Id

01/01/13  02/01/13  03/01/13 ........ 30/01/13

abc

1

P

P

A

P

xyz

2

P

P

P

P

I wants to count total number of absent at particular date and name wise total number of absent from one month data set.

Thanks

Vikas

[MayilVahanan]

HI

Use CrossTable and convert the data set into name, id, date and attendance.

Then you can convert date into month using month() function and u can achieve ur requirement

Hope it helps

[kaushiknsolanki · Accepted solution]

Hi,

     You need to use the CrossTab option.

     Have a look at the QVW file and Excel file attached here with.

Regards,

Kaushik Solanki

[jagan]

Hi Vikas,

Try transforming this data to normal format by using CrossTable(),

Crosstable (Date, Status, 2) Load * from DataSource;

You can check help document for further help.

Hope this helps you.

Regards,

jagan.