Common string problem in Ad HOc reporting

[agni_gold]

Hi Friends,

I have 2 dimensions name

Country

Country Description

now i have created ad hoc report and when i am selection Country Description then country dimension is also activating , please help .

=SubStringCount(concat(%Dimensions_Geo,'|'),'Country')

=SubStringCount(concat(%Dimensions_Geo,'|'),'Country Description')

i have also tried

=SubStringCount(concat(hash256(%Dimensions_Geo),'|'),hash256('Country'))

=SubStringCount(concat(hash256(%Dimensions_Geo),'|'),hash256('Country Description'))

[mayankraoka]

Hi Agnivesh,

Can you try this:

=SubStringCount(Concat(GetFieldSelections(Dimensions, '|',20), '|'),'Country')

SubStringCount(Concat(GetFieldSelections(Dimensions, '|',20), '|'),'Country Description')

Regards,

Mayank

[sunny_talwar]

Try these

=SubStringCount(Concat(DISTINCT '|' & %Dimensions_Geo & '|'),'|Country|')

=SubStringCount(Concat(DISTINCT '|' & %Dimensions_Geo & '|'),'|Country Description|')

[agni_gold]

what 20 is doing ?

[agni_gold]

I have Country stored in one variable and country Description stored in another variable  ,

but it is not working

=SubStringCount(concat(distinct '|'&%Dimensions_Geo&'|'),'|'&vL_FN_Dimension_Geo3&'|')

=SubStringCount(concat(distinct '|'&%Dimensions_Geo&'|'),'|'&vL_FN_Dimension_Geo4&'|')

[mayankraoka]

this is not mandatory you can ignore this

[agni_gold]

its not working

[sunny_talwar]

Can you share a sample?