How to select two column from two different table using the CALC_THROUGHPUT?

Hi,

Not enough details to help you solve it, but if you would like to connect two tables that does not have clear connection please get familiar with PU_FUNCTIONS maybe it will be helpful:

Pull Up Aggregation (celonis.com)

Regards,

Marcin

According to the documentation, with CALC_THROUGH you can only refer to a single column

CALC_THROUGHPUT ( begin_range_specifier TO end_range_specifier, timestamps [, activity_table.string_column ] )

If the columns are in different activity tables, maybe you could use MERGE_EVENTLOG

If they are in the same acrtivity table, then I guess you can:

• create a new activity with the eventime of the second column.
• use datediff to compute the delta between the 2 columns and add it to the activity as a new column

It depends what you want.

HTH