Expression In Script

[Anonymous]

I have the below expression in the chart properties and I would like to add in the scrip. Can someone show me the best approach?

Expression in Chart - count({<Status={[Pended]}>}distinct ID)

how would that look in the scrip? Can I use a IF Statement, this is what I have below...

     Count(IF(Status= 'Pended','')) as TotalPends

[Anonymous]

My dimensions are, Status & ID. Count the # of ID when my status = pended.

I have about 30 other calculations that I need to create in the script. Keeping as simple as I can.

[sunny_talwar]

Would you be able to share a sample?

[Anonymous]

In a straight table without expression embedded in the chart I would like to see.

See attached example. I need to see (distinct)totals for the two columns that I created TotalPend and TotalId

DESCRIPTION	ID	STATUS	COUNTstatus	TOTALPENDS
TOTAL			7	4
FIVE	5	PENDING	1	1
FOUR	4	DENIED	1	0
ONE	1	PENDING	1	1
SEVEN	7	PENDING	1	1
SIX	6	APPROVED	1	0
THREE	3	PENDING	1	1
TWO	2	APPROVED	1	0

[Anonymous]

Added an example

[sunny_talwar]

Did you forget to add data to the table here?

[Anonymous]

ADDED DATA

[sunny_talwar]

This?

[Anonymous]

Yes but I do not want to create expressions. There's not a way to create in the script?

[sunny_talwar]

Looking for something like this?

Script:

TEST:

LOAD * Inline [

ID, DESCRIPTION, STATUS

1, ONE, PENDING

2, TWO, APPROVED

3, THREE, PENDING

4, FOUR, DENIED

5, FIVE, PENDING

6, SIX, APPROVED

7, SEVEN, PENDING

];

Join(TEST)

LOAD Count(STATUS) AS COUNTstatus

Resident TEST;

Join(TEST)

LOAD Count(STATUS) AS COUNTPENDS

Resident TEST

Where STATUS = 'PENDING';

[Anonymous]

No, I assumed this would be a standard question but maybe I'm not being clear enough. I need what you have in your first example but without the expression in the chart. Is there not a way to create the expression in the script???