Hi Thorsten,

for option 1, most KPIs have a set of parameters that can be accessed from the Settings area. For example, in a bar chart, you can define the size of the Dimension Axis:

for option 2, the statement should not be put inside the variable name but outside: LEFT(<%=MyVariable%>, 10)

regards

Marc

Hi Marc,

Expanding your post helped to see your full response.

I inserted an image below to better explain my question

Any help is appreciated.

Hi Thorsten,

OK, I didn't catch that it was the KPI title that you wanted to limit 'dynamically'. After a couple of trials, I think I managed to get it how you want:

• I already have my variable 'TEST' that holds either 'FIRST_OCCURRENCE' or 'LAST_OCCURRENCE' in my case.
• first I create a formula that will hold the requested statement to limit the length. I called my formula 'SHORT' and it reads the first 10 characters of my variable 'TEST': LEFT ('<%=TEST%>', 10). Note that here the variable is set between single quotes. You could also use a variable for the limit (10) if you want to have it changeable, but without quotes.
• then I call the formula in a variable of type 'static value' called SHORT_TXT: KPI (SHORT)
• in the KPI name, I call variable 'SHORT_TXT'

whenever I change my variable 'TEST' with the dropdown, it changes the title of the KPI accordingly.