Display Partial Text in Data Label

#1

I have created a Data Label and linked it to a viewParameter Member filter.


But I want to display only partial information in the Data Label. For instance, one of the values in the Member filter is 'No. 1 - XYZ (2)'. If I select this, the connected Data Label should display only 'XYZ'. Is it possible to concatenate the Data Label display?

#2

To do this after filtering, you would have to use JavaScript. An example would be to use the .split method and then pass the result to another label on the Data Changed action and hide the Data Label.


If you want to use the built-in functionality in Dundas BI, you would have to do the manipulation on the data cube level, before the filtering. The String transform should do the trick for this case.

#3

Thanks, Elia. Guess, will have to learn JavaScripting. But, it is too vast by itself. What's the best way to learn JavaScript for Dundas BI?

#4

If you are completely new to JavaScript, you should probably start with a simple online tutorial, like the one from w3schools, to get familiar with the syntax. These usually do not take much time.


In terms of Dundas BI, you should start with our articles Writing scripts using developer tools and Staying organized while developing scripts. For your specific situation, the article Reading data from a visualization by script would be a good reference as well, and from there you learn by doing.


Good luck, and enjoy! :)

#5

Thanks a lot, Elia.