1. You should have the DATE_ID key between your tables formatted the same. Here is load script that will do so:
Order:
LOAD timestamp#(ORDERDATE_ID, 'MMDDYYYYhh:mm') as ORDERDATE_ID,
date(floor(timestamp#(ORDERDATE_ID, 'MMDDYYYYhh:mm')),'MMDDYYYY') as DATE_ID,
COUNT
FROM Data.xlsx
(ooxml, embedded labels, table is ORDER);
Customer:
LOAD date#(DATE_ID,'MMDDYYYY') as DATE_ID,
CNT_CUSTOMER
FROM Data.xlsx
(ooxml, embedded labels, table is CUSTOMER);
Profit:
LOAD date#(DATE_ID,'MMDDYYYY') as DATE_ID,
AMOUNT
FROM Data.xlsx
(ooxml, embedded labels, table is PROFIT);
Once you set your data up like this, you can use DATE_ID as a dimension in a line chart, which will then allow you to compare all 3 tables (see the top line chart in my example file that is attached).
2. To only pick a date on a chart and to have it not affect anything else on the report, give the chart a different alternate state (you can create alternate states in Settings > Document Properties > General > Alternate States (button), then add the alternate state to the chart in Chart Properties > General > Alternate State (dropdown), see the top line chart in my example file that is attached).
3. This is where you use the original ORDERDATE_ID field which is no longer a key between the tables for the date time, and the DATE_ID for just the date (see the bottom two line charts in my example file that is attached).
