Skip to main content
Solved

KPI - Variable - Limit Characters of Expression

thorsten.schne
Level 3

Hi everyone,

I created a Chart and face the problem that the expression of the KPI does not fit into the tooltip.

 

 

Option 1: Is there a setting to change the size of the tooltip box?

Option 2: Alternatively I wanted to limit the characters of the variables. Could you help me to insert a LEFT or RIGHT statement? My syntax does not work.

 

<%= MyVariable %> --> Full text is shown

<%= LEFT(MyVariable,10) %> --> Only show the left 10 characters

Best answer by Anonymous

thorsten.schne wrote:

Hi Marc,

 

Expanding your post helped to see your full response.

 

I inserted an image below to better explain my question

2021-05-26_12-28-08 

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'KPI size2

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

View original

A
  • Anonymous
  • May 26, 2021

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:

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

regards

Marc

thorsten.schne
Level 3

Hi Marc,

 

Expanding your post helped to see your full response.

 

I inserted an image below to better explain my question

2021-05-26_12-28-08 

Any help is appreciated.

 

A
  • Anonymous
  • May 26, 2021
thorsten.schne wrote:

Hi Marc,

 

Expanding your post helped to see your full response.

 

I inserted an image below to better explain my question

2021-05-26_12-28-08 

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'KPI size2

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

Reply


Community Code of Conduct