Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have below expression in chart
=COUNT({<[Status] -= {'SalesCounter','Ground'}>}DISTINCT CustomerID)
I need to add one more column Region to above expression.
The region have blanks and 3,4. But I need to add only Region =3,4.
How to add the Region to the existing expression? Can anyone suggest me.
Thanks.
=COUNT({<[Status] -= {'SalesCounter','Ground'}, Region = {'3','4'}>}DISTINCT CustomerID)
=COUNT({<[Status] -= {'SalesCounter','Ground'}, Region = {'3','4'}>}DISTINCT CustomerID)
Thanks. how to change the same expression if I need to show all integers in Region except blanks?
=COUNT({<[Status] -= {'SalesCounter','Ground'}, Region = {'*'}>}DISTINCT CustomerID)
Region = {'*'}
or Create below in your script
IF(IsNull(Region) or Len(Trim(Region))=0, 0, 1) as RegionNotNullFlag
Now instead of Region = something......use
RegionNotNullFlag= {'1'}