Hi,
I have a table that can either show Volumes or Ratios of Sales Orders fulfilling a particular criteria. I have a drop-down which allows the user to select Volume or Ratio and the numbers in the table update accordingly.
The issue is that when I flip to Ratio, I am not able to dynamically format the numbers as a %. Is there any way to specify the number format within the function editor?
Page 1 / 1
Hi,
I found a solution that ought to work soon:
Create a second variable called formatting. Then go to your drop-down and for each of your KPIs click Add another variable. Set the variable formatting to .2% for ratio (if you want to than 2 decimal points just change the 2 to a different number). If you want your Volume KPI to have the format #.##k then set formatting to .3s.
As a next step you would go to your dynamic KPI and write <%= formatting %> in the box next to Format. Unfortunately, this step currently doesnt work properly as Format doesnt yet accept variable inputs.
I have made a service desk ticket reporting the bug to our delivery team on your behalf so this solution should work as soon as they have fixed that. Please be patient with us. I will let you know if I have more information for you.
Best wishes,
Calandra
I found a solution that ought to work soon:
Create a second variable called formatting. Then go to your drop-down and for each of your KPIs click Add another variable. Set the variable formatting to .2% for ratio (if you want to than 2 decimal points just change the 2 to a different number). If you want your Volume KPI to have the format #.##k then set formatting to .3s.
As a next step you would go to your dynamic KPI and write <%= formatting %> in the box next to Format. Unfortunately, this step currently doesnt work properly as Format doesnt yet accept variable inputs.
I have made a service desk ticket reporting the bug to our delivery team on your behalf so this solution should work as soon as they have fixed that. Please be patient with us. I will let you know if I have more information for you.
Best wishes,
Calandra
Hi @c.eckert,
On top of this, Can we also have series color mapping to accept dynamic values?
It will very helpful if target of KPIs are dynamic basis on the selection.
KR,
Kalpesh
On top of this, Can we also have series color mapping to accept dynamic values?
It will very helpful if target of KPIs are dynamic basis on the selection.
KR,
Kalpesh
Hi Kalpesh,
I just tested it (in the IBC), yes colour mappings accept variables in the place of colour thresholds.
Just create a new variable for every threshold you want to have. And add them all to the drop-down where you select the KPI, setting the values for each variable so they suit that particular KPI and finally create a new colour mapping for the dynamic KPI in your OLAP table. Instead of writing a number for each threshold, write <%= your_threshold_variable_name %> in the boxes. Then when you select a KPI from the drop down the formula will change and so will the colour mapping thresholds.
Best wishes,
Calandra
I just tested it (in the IBC), yes colour mappings accept variables in the place of colour thresholds.
Just create a new variable for every threshold you want to have. And add them all to the drop-down where you select the KPI, setting the values for each variable so they suit that particular KPI and finally create a new colour mapping for the dynamic KPI in your OLAP table. Instead of writing a number for each threshold, write <%= your_threshold_variable_name %> in the boxes. Then when you select a KPI from the drop down the formula will change and so will the colour mapping thresholds.
Best wishes,
Calandra
Sorry, were using v4.5. 
No problem. I just checked. It works in Celonis 4.5 too
Hi Calandra!
Do you have a follow-up as to whether this custom formatting has been addressed?
When I try, it seems like the variable redirect is working, but even when I use .1f as the format, it formats it as a percentage.
Thank you,
Alex
Do you have a follow-up as to whether this custom formatting has been addressed?
When I try, it seems like the variable redirect is working, but even when I use .1f as the format, it formats it as a percentage.
Thank you,
Alex
Hi Alex,
as mentioned in the other topic, I will give an update on that matter there.
This is the link that guides you to the topic:
Conditional formatting based on variable Codes & Statements
Hi Alex,
unfortunately, I do not have an update on that matter. Our Product Management is prioritizing all Feature Requests. Therefore, I can not tell you a date when this feature will be in place. However, I will raise that Feature Request again and as soon as I have an update on it, I will post it in this topic.
Best regards,
Justin
Best regards,
Justin
as mentioned in the other topic, I will give an update on that matter there.
This is the link that guides you to the topic:
Conditional formatting based on variable Codes & Statements
Hi Alex,
unfortunately, I do not have an update on that matter. Our Product Management is prioritizing all Feature Requests. Therefore, I can not tell you a date when this feature will be in place. However, I will raise that Feature Request again and as soon as I have an update on it, I will post it in this topic.
Best regards,
Justin
Best regards,
Justin
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.