How to use Calculated Dimension in Script Level ?

nikhilgarg — Sun, 21 Jun 2015 13:46:35 GMT

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

Re: How to use Calculated Dimension in Script Level ?

swuehl — Sun, 21 Jun 2015 14:00:42 GMT

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)