Contract buckets based on Country

[madhuqliklondon]

Hi all, 

I am trying to bucket some of the contract information explained in excel,  I have tried with where column name = column name and few examples looking at community but nothing seems to be working as expected.  I can create a calculated dimension but I would like to use this in set analysis. 

Few details on the request 

A sim contract has a contract type and it can be paid or free, where the contract is issued is a country of origin and they can visit any country as a roaming country.  for example if we take UK customers they can use the sim in the UK or they can visit eligible roaming countries and vice versa.  So I am trying to bucket these scenarios. please see the excel attached (apologies for the poor analogy).

Thanks in advance. 

[NitinK7 · Accepted solution]

Hi,

find below attached application.

[madhuqliklondon]

Hi Nitin, 

Thank you very much for your time and support, very useful logic, can you check last 2 expressions please, they must be kind of the opposite, like Inbound Vs Outbound.  Please see attached file, I have updated with comments. 

[NitinK7]

Hi,

Sorry I did't understood , can you please explain in brief .

[madhuqliklondon]

Hi Nitin, 

sure, if we take the UK as an example 

No of visits of Free contracts in that country (where issued in another country) In: Counting free customers visits visiting the UK, their country of origin is Not the UK. 

No of visits of Free contracts in another country (where issued in this country) Out: Counting free customers visits visiting other countries from the UK, their country of origin is the UK. 

hope this makes sense.  Thank you