Groupby

[#1]

Hi,

I have columns (status1,status2,status3) and (Month1,Month2,Month3)  in  table1,table2,table3 respectively.

I have concatenated those columns as Status and Month.

Now my query is:

If status=closed I want the count of ID's groupby Month i.e In jan how many ID's are closed?

[anbu1984]

In Script

Load Month,Count(Status) Resident Table Where Status='Closed' Group by Month;

In Chart,

Dimension: Month

Expr: Count({<Status={'Closed'}>}Status)