Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dimension:
LOAD * INLINE [
_Dimention
ProductName
ProductID
Office
OfficeCity
OfficePhone
OfficeCountry
];
and i have a productName in Product Table too,i created a pivot table with dimentions as ProductNAme ,Office etc and given expression as below,
=SubStringCount(Concat(_Dimention,'|'),'ProductName')
can any expalin how that expression working
i guess you are asking about adhoc reporting.
=SubStringCount(Concat(_Dimention,'|'),'ProductName')
concat will create a string with delimter '|'.
for example: A|B|C|D|E|F|B
substring will return count of the word/letter you mentioned in substring count
in mentioned example if we write as substringcount('A|B|C|D|E|F|B','B')
the above will return 2 as B is repeating two times.
in your example the substringcount(concat()) will retune 1 as ProductName is repeated once in the _Dimension.
as it returns one,the conditon enable and become true.
so when even you click on _Dimension the count shows 1 and condition will enable and chart will display respective selection.
Hope it helps you.
Regards
Om
Let's talk with inline
_Dimension is the field which contains A, B, C, D ??
So, Concat(_Dimension, '|') -- Will return A|B|C|D
From here, We are going to use
SubStringCount(concat(_Dimension, '|'), 'C') -- Which contains one as Count
i guess you are asking about adhoc reporting.
=SubStringCount(Concat(_Dimention,'|'),'ProductName')
concat will create a string with delimter '|'.
for example: A|B|C|D|E|F|B
substring will return count of the word/letter you mentioned in substring count
in mentioned example if we write as substringcount('A|B|C|D|E|F|B','B')
the above will return 2 as B is repeating two times.
in your example the substringcount(concat()) will retune 1 as ProductName is repeated once in the _Dimension.
as it returns one,the conditon enable and become true.
so when even you click on _Dimension the count shows 1 and condition will enable and chart will display respective selection.
Hope it helps you.
Regards
Om
Thank you so much ,it held me a lot
you are welcome Vignesh