Dynamic Formatting in OLAP table

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

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

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

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

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