With the SAP Lumira 1.22 release you can now create text elements that contain dynamic text and will be updated when the dataset is refreshed, ensuring up-to-date content*. For this blog I am focusing on infographic but this can be applied to text boxes in boards and reports as well.
Looking at the following infographic piece, I have 2 numbers in my text elements, which come right from my data. Note that previously I was able to archive a similar effect by adding numeric charts, but adding dynamic elements to a text object is easier and more flexible than the numeric chart.
Let’s look how this can be done.
Assume you have added a text box to your infographic. As part of the Text Properties you can see a Dynamic Text button.
On pressing this button a formula editor appear. In this editor you give the formula a name, select the dataset that you want to use and define your formula. For the first text I like to show all submission to my contest, hence I am only selecting the submission measure from the list and press OK.
The value will be added with a light blue highlighting behind it indicating that it is a dynamic text. This highlighting will not be shown in preview or view mode. You can format this dynamic text just like any other text object.
Now I like to show the number of countries that participated in the contest. I don’t really care about the exact number and want to show only multiple of 10, hence adding a formula as dynamic text.
The exact number of participating countries is 41, but thanks to my formula in the infographic only 40+ is displayed, which is the right level of detail that was intended for this infographic.
If you have any comments, please let me know or submit an idea in IdeaPlace.
*For infographics page refresh on open needs to be set in order for the text to refresh.