Groupby

Thu, 22 Jan 2015 07:23:13 GMT

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?

Re: Groupby

anbu1984 — Thu, 22 Jan 2015 07:59:32 GMT

In Script

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

In Chart,

Dimension: Month

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