Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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'))
Hi Agnivesh,
Can you try this:
=SubStringCount(Concat(GetFieldSelections(Dimensions, '|',20), '|'),'Country')
SubStringCount(Concat(GetFieldSelections(Dimensions, '|',20), '|'),'Country Description')
Regards,
Mayank
Try these
=SubStringCount(Concat(DISTINCT '|' & %Dimensions_Geo & '|'),'|Country|')
=SubStringCount(Concat(DISTINCT '|' & %Dimensions_Geo & '|'),'|Country Description|')
what 20 is doing ?
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&'|')
this is not mandatory you can ignore this
its not working
Can you share a sample?