How to use Calculated Dimension in Script Level ?

[nikhilgarg]

Hello,

I have attached a chart. In this chart, i am using the Calculated Dimension. But i don't want to use that calculated dimension and rather want to use Calculated dimension in script level. But no idea how to do it. Can anyone help me in this?

Thanks

[swuehl · Accepted solution]

Maybe like this:

Table1:

Load * Inline [

ClientId, ClientName , Status

1, Client1, Accepted

1, Client1, Rejected

2, Client2, ClientAccepted

3, Client3, DealerAccepted

4, Client4, Accepted

5, Client5, ClientAccepted

6, Client6, Accepted

7, Client7, DealerAccepted

7, Client7, Rejected

8, Client8, DealerAccepted

9, Client9, Rejected

10, Client10, Rejected

11, Client11, ClientRejected

12, Client12, DealerRejected

13, Client13, Rejected

13, Client13, DealerAccepted

14, Client14, ClientRejected

15, Client15, Rejected

16, Client16, ClientRejected

17, Client17, ClientRejected

18, Client18, Rejected

];

Counts:

LOAD

  ClientId,

  count(if(match(Status, 'Accepted', 'ClientAccepted', 'DealerAccepted'),Status)) as Accepted

RESIDENT Table1

GROUP BY ClientId;

LEFT JOIN (Counts)

LOAD

  ClientId,

  count(if(match(Status, 'Rejected', 'ClientRejected', 'DealerRejected'),Status)) as Rejected

RESIDENT Table1

GROUP BY ClientId;