If Script

[Anonymous]

Hi Everyone,

i am using the following script for pulling the data(count of name )  only for those which have status = Reopen or WIP

Count(if (Status ='Re-open'or 'WIP ' , Name, 0) )

But this script is not giving me the correct total.

Please assist

[Gysbert_Wassenaar]

Try: Count({<Status={'Re-open','WIP '}>} Name)

And make sure if it's 'WIP' or 'WIP ' (with an extra trailing space after the P). They are two different values.

[Anonymous]

Count(if (Status='Re-open') or (Status='WIP'), Name,0))

[#4]

Try this,

Count(Distinct(if(match(Status,'Reopen','WIP'),Name)))

[Gabriel]

Hi,

Are you doing this logic in the script or UI.

If you are doing it in the script then use flag

here is an example

Data:

LOAD * , IF(Status = 'Complete',1,0) AS Status_Flag Inline
[
Currency ,      amount, Status
001,                1000,Complete
002,                1500, WIP
003,                1500,WIP
004, 2000, Complete
005,                1000,Complete
006 ,                500, Complete
];

And then in your chart use Set Analysis to count Status_Flag

[Anonymous · Accepted solution]

hi

try!

Count({$<Status={'Re-open','WIP '}>} Name)

or

if (Status='Re-open' or Status='WIP', count(Name),0)

Regards!

Jannet

[pratap6699]

Count({<Status={'Re-open','WIP '}>} Name)

[Anonymous]

Hi Jannet,

Thanx, finally its here !!!

Cheers..

[pratap6699]

in script level

if (Status='Re-open' or Status='WIP', count(Name),0)

[Anonymous]

You  welcome!!  Guarav

Regards.