Skip to Content

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.

ViewMode.png

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.


dynamic Text1.png

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.

/wp-content/uploads/2015/01/formular1_625197.png

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.

/wp-content/uploads/2015/01/sub_625198.png

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.

/wp-content/uploads/2015/01/formular2_625205.png

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.

ViewMode.png

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.

To report this post you need to login first.

6 Comments

You must be Logged on to comment or reply to a post.

  1. Laura VEGA

    Yes really cool.

    I was wondering why you can oly use measures in the Dynamic text?

    I am currently working on a demo for a customer and trying to display in a text box an attribute of the selected product in my board, but in reality only numeric calculations are allowed. Are there some plans to extend the feature?

    Thks

    Laura

    (0) 
    1. James Batchelor

      I am trying to do this as well.   I want to show what dimension value has a specific measure value..   ie.  Country Name where Max(sales).   Not just display max sales value.

      Its not straight forward if its possible.

      thanks

      james

      (0) 
  2. Mireille NOUMEN

    Hello

    Please is it possible to add a picture in the formula editor?

    I’m working on a demo and i want to display a picture in the text box, for some value of a measure and an attribute

    (0) 

Leave a Reply