Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
In Script
Load Month,Count(Status) Resident Table Where Status='Closed' Group by Month;
In Chart,
Dimension: Month
Expr: Count({<Status={'Closed'}>}Status)