topic Re: Why does this string not work?!?!?! in Connectivity & Data Prep

Why does this string not work?!?!?!

Mon, 23 May 2016 14:56:28 GMT

Product_Type__c-={'LearningSpace Enterprise', 'LearningSpace Pro', 'Replay', 'Replay One', 'METIVision', 'N/A', 'LearningSpace One', 'LearningSpace', 'UltraPortable Replay', 'Replay Connect + Replay One', 'LearningSpace Go', 'LearningSpace One VHA', 'Meti-FX', 'LS Connect + LS One'}>}Status)

Re: Why does this string not work?!?!?!

rubenmarin — Mon, 23 May 2016 15:30:09 GMT

Hi Dan, did you tried? Syntax checker will mark as an error after the '-=' but it works.

Also, the field name has a double underscore ( _ ) between 'Type' and 'c'?

Re: Why does this string not work?!?!?!

sunny_talwar — Mon, 23 May 2016 15:31:55 GMT

May be you need a function to begin with?

Concat({<Product_Type__c-={'LearningSpace Enterprise', 'LearningSpace Pro', 'Replay', 'Replay One', 'METIVision', 'N/A', 'LearningSpace One', 'LearningSpace', 'UltraPortable Replay', 'Replay Connect + Replay One', 'LearningSpace Go', 'LearningSpace One VHA', 'Meti-FX', 'LS Connect + LS One'}>}Status)

Re: Why does this string not work?!?!?!

Mon, 23 May 2016 15:33:21 GMT

The double underscore is correct, and the code checks OK but it does not actually perform the request, anything after the first product type does not effect the calculation, and i have verified that that product types contain data.

Re: Why does this string not work?!?!?!

rubenmarin — Mon, 23 May 2016 15:39:22 GMT

Hi Dan, not sure, I don't see any problem in the string. I did something similar with a larger string and worked... maybe in the rest of the expression?

Note that you're doing a '-=', so it have to count all types except the ones you are writing.

Re: Why does this string not work?!?!?!

Mon, 23 May 2016 15:40:23 GMT

it does not like that either

Re: Why does this string not work?!?!?!

Mon, 23 May 2016 15:43:05 GMT

Count({$<Region__c={'United States'},createdquarter={'4/1/2016'},Return_Visit__c={'yes'},

I am trying to count everything except these products, so the -= is correct, it will disregard the first product in the string just not the following ones.

Re: Why does this string not work?!?!?!

sunny_talwar — Mon, 23 May 2016 15:56:02 GMT

Have tried adding Product_Type__c as dimension and you happen to see all other Product_Type__c which you have tried to exclude?

Would you be able to share a sample?

Re: Why does this string not work?!?!?!

Mon, 23 May 2016 16:12:01 GMT

I was able to get the code to work but not by modifying code, I ran both halves of the expression individually then joined them and it worked. The expression is the same except one variable in the first half, i am basically counting with and with out the variable and then dividing to get a percentage.

Count({$<Region__c={'United States'},createdquarter={'4/1/2016'},Return_Visit__c={yes},

Count({$<Region__c={'United States'},createdquarter={'4/1/2016'},

Re: Why does this string not work?!?!?!

sunny_talwar — Mon, 23 May 2016 16:24:22 GMT

I think you should create a flag in the script and then use that in your set analysis statement

LOAD Product_Type__c,

If(Match(Product_Type__c, 'LearningSpace Enterprise', 'LearningSpace Pro', 'Replay', 'Replay One', 'METIVision', 'N/A', 'LearningSpace One', 'LearningSpace', 'UltraPortable Replay', 'Replay Connect + Replay One', 'LearningSpace Go', 'LearningSpace One VHA', 'Meti-FX', 'LS Connect + LS One'), 0, 1) as Flag

....

FROM Source;

Count({$<Region__c={'United States'}, createdquarter={'4/1/2016'}, Return_Visit__c={yes}, Flag = {1}>}Status)

Count({$<Region__c={'United States'}, createdquarter={'4/1/2016'}, Flag = {1}>}Status)