Display data of two tables (SAP HANA + Excel) in single Column Chart?


#1

Hello,
Is it possible to display data of two tables based on a ROUND_MONTH timestamp x-axis in a single Column Chart? Date fields of the two tables cannot be connected in the Data Model, because the months have duplicates.


#3

Hi,

we are currently working on recreating your example to find a solution for your use case.

Best,
Viana


#4

Hi,

to use a round_month on your connected columns, you can use the following formula:

ROUND_MONTH(TO_TIMESTAMP(“T_FORECAST_SERIES”.“SERIES_DATE”||’.’||“CELONIS_KAPA_MSU”.“MONTH”||’.2018’, ‘DD.MM.YYYY’))

When using this, you have to keep in mind that:

  • the date and the month have to have 2 digits, so when you have april as month, it has to be 04
  • in the solution, there is a hardcoded year 2018, but you can add a case when based on a time information so that you can flexibly choose the year
  • the tables have to be connected with each other in order to concatinate the columns

Best Regards,
Viana


#6

Thank you for the hint, Viana. I will check on Monday and give you feedback.

With best regards

Hans


#7

We use Celonis 4.4 on the Productive system where I try to display the two tables.


#8

The proposal does not work for our scenario because precondition 3 “the tables have to be connected with each other in order to concatinate the columns” cannot be satisfied. We are not able to connect (=JOIN) the two tables in the data model because we have duplicate date fields in both tables based on skills:

If it is not possible to display data of “unconnected” tables in a single Column Chart we have to arrange data in a different way.