Skip to main content

Hello All,

Could you help me to advise on how to classify the bucketing with the help of coloring in pivot table which is recently develop in new view. We are able to provide the color classification in Olap Table however i am afraid it is not yet possible in pivot table.

Please Help

Regards,

Apurva

 

In a pivot table, you can change the color of cells based on the values they show. You can use color gradients or set color thresholds to highlight important numbers. The color can either fill the whole cell or just highlight the number inside it—similar to how it works in a regular table.

 

Refer to the following link → https://docs.celonis.com/en/pivot-table.html#UUID-6779ed0e-3606-6b85-eb5d-ed1ce64f4e53_section-idm234922659651312


Hi Abhishek,
Hope you are doing well.

Thank you for the response.

I tried the way you suggested me. However in mentioned above settings we can only classify the color with minimum, maximum and median values.
For the post i have created, in that scenario, I am trying to classify it for more than 3 values. You can refer below image again. With the help of above setting you advised, is not giving the result as expected.

Could you advise other way to achieve it?

Regards,

Apurva

 


 The new Pivot Table component in Celonis Views does support cell coloring, but its options are currently limited compared to the OLAP/Table component.
- In Pivot Tables, you can apply color using threshold and gradient coloring based on metric values. This allows you to visually distinguish ranges (e.g., min, medium, max) with different colors. However, the configuration is not as flexible as in OLAP/Table components, where you can define more granular or custom color mappings using PQL or multiple thresholds.
- As of the latest updates, custom PQL-based coloring (which would allow for more complex or multi-bucket color rules) is not supported in Pivot Tables. This feature was removed to avoid confusion, and users are encouraged to submit enhancement requests if they need more advanced coloring options. You can still use custom PQL coloring in the Table component, but not in Pivot Tables at this time. For more details, see the official documentation and community discussion:
  - Pivot Table documentation: https://docs.celonis.com/en/pivot-table.html
  - Community update on custom coloring: https://www.celopeers.com/s/rightanswer#solutionid=250721041558370&csid=12Summary of what you can do in Pivot Tables:
- Use threshold coloring (e.g., set a value where the color changes from green to yellow to red).
- Use gradient coloring (smooth color transitions between min, center, and max values).
- You cannot currently define more than three discrete color buckets or use custom PQL for advanced color logic in Pivot Tables.Recommendation: 
If you need more than three color buckets or advanced logic, use the Table component instead of the Pivot Table for now. For feature enhancements, consider submitting your request via the Celonis Product Portal or consult your Value Engineer for suppor