Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
find below attached application.
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.
Hi,
Sorry I did't understood , can you please explain in brief .
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