The connection of two sources through the parameter

[vladimirdzeb]

Hi.
There is the following task, maybe someone will have ideas with solutions.

Incoming data:
Table_1: 

• created_date (loan disbursement date)
• order_id (unique contract number)

Table_2: 

• arcdate (archived date)
• order_id (contract number)
• amount (loan balance at archive date)

Parametr_1:

• A decimal number from 1 to 60 (in increments of 1) that the user of the report enters.

Task:

Display a table that will contain the following information:

1. created_date (value with Table_1, this field is displayed in the filter)
2. count_order (the number of contracts created_date with Table_1)
3. sum_amount (the amount of the balance of all loans issued in created_date c Table_1 on the date arcdate_X c Table_2)

Arcdate_X = created_date + Parametr_1

Who has any ideas ?

[v-yuta-msft]

@vladimirdzeb ,

Your requirement is not clear. Could you please share some sample data, and share more details about the logic?

Regards,

Jimmy Tao