Skip to main content
Question

Dynamic Formatting in OLAP table

  • July 24, 2019
  • 7 replies
  • 95 views
B
Level 2
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?

7 replies

C
Level 0
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
.
Level 5
  • .14600835
  • Level 5
  • July 29, 2019
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
C
Level 0
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
.
Level 5
  • .14600835
  • Level 5
  • July 29, 2019
Sorry, were using v4.5.
C
Level 0
No problem. I just checked. It works in Celonis 4.5 too
A
Level 1
  • alex.hellw
  • Level 1
  • March 11, 2020
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
J
Level 0
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
Community Code of ConductAccessibility statement