Today is 24th post of this blog series and I am suprised that I can continue to post blog every week. I got some reply from who loves Celonis in the world and it is my fun to continue posting. Celonis is releasing new functionarity year by year and I am interested in catching up them and thinking how these functions help my clients. After listening to next week’s Celonis World Tour Webiner in Tokyo, I will get more inspiration to write blog.
Until this post I mainly shared how to calculate KPIs in PQL and not mentioned about visual components that is one of the characteristic of Celonis, because I believe correct calculation is basis of quality assurarance. After you can verify calculation result in OLAP table, it is easily convert to visual component then decorate it as you like. Today I would like to show how to do it, and tips of decoration.
Today I try to visualize the result of days between Ship and Invoice in Handle NULL efficiently in Aggregation Function post. As mentioned before, first step is to create OLAP table for counting Invoice within a day etc. For visualization I determined month of Ship Goods as dimension. Below is the result of OLAP table.
Second step is converting component type. After verifying OLAP table you will right click it and go to setting, then simply change component type. In this case I choose column chart.
Resulting appearance is not good enough because three columns appear per one month. So as third step I would like to change it to stacked bar chart.
Again go to settings and choose Data series: within a day at the top dropdown. Then scroll down to the buttom and tick Stacked button. Same operation is done against Data series: over a day then two columns are stacked successfully.
How about total column ? I would like to use it to display total number but would not like to stack. Go to Data series: total then select Line chart in Alternative type dropdown, then height of node of line is same as that of stacked bar. Next change to transparent in Series color button and tick Display data labels. Finally line is disappeared and only total number is displayed like legend of stacked bar. Below is process of converting OLAP table to final appearance.
Even if this process is not applied (e.g. histogram), you should first create OLAP table then manually copy PQL to visual component for keeping calculation quality.
Kaz
This post’s program can be downloaded here then push to your environment by content-cli.