Field called Customer - if the first Character equals a 'W' then count the number of customers

[#1]

either within the Load process or within the Dashboard -

how can I check if the first character is the letter 'W' from the customerID field - and if Yes - Count

[#2]

Hi,

Try the following -

=Count({$<[Customer Name]={'w*'}>}[Customer Name])

I hope this helps

Thanks

Nick

[Miguel_Angel_Baeyens]

Hello,

In the chart expression

Count({< customerID = {"W*"} >} customerID)

In the script, using a flag (for example)

Table:LOAD customerID, If(Left(customerID, 1) = 'W', 1, 0) AS customerCountedFROM source

And then in your chart

Sum(customerCounted)

Hope that helps

[hector]

Hi

i'm not sure what you want, but you can do something like this in the script

If(left(CustomerIDField,1) = 'W', CustomerID, null()) as Customer_wo_W

OR

if(wildmatch(CustomerIDField,'W*'), CustomerID, null() as Customer_wo_W

then in the object use the expression

count(Customer_wo_W)

OR

with set analysis something like

count({<CustomerID = {"W*"}>}CustomerID)

Hope this helps

Rgds

[#5]

OK - that worked. thank you