I have a dimension which has a length of around 150 characters.
Instead of using the complete name in the dimension label for each bar, I want to be able to use a substring (the first substring or the last substring) in the label for Dimension in the chart visualization.
For Example, if the deptname is ADFDFDDFDDFQQ4GR44DFFDFDFEGBJNUDFDFDNIONIN/ADFDFDFI/ADFDADFEBRR7FDFD/DADFWRVDFD, i want the chart to only display (say) its last substring which is 'DADFWRVDFD' and so on for every bar in the dimension.
Is there anything we can do using aggregate function for the dimension label for the chart or something like that?
if u want to diplay above dept NAME ,start string eg- ADFD it can be done in Presentation tab> Legend> mark on Show legend-Dept NAME & then mark on Limit Legend(Characters) as 4 then you will get the ADFD.