Build a very simple module with 2 fact table, 1 dimension table. Both fact table join to dimension table.
Create new dashboard, create simple calculation
test = fact1.measure1 + fact2.measure1
Drag test to the dashboard, also drag column from dimension table to the dashboard as filter. Unfortunately, when select value from list of filter, simple calculation test value is NOT changed as expecting. Monitor SQL script, selected filter value does not included to the script.
This basically means dashboard does not has the capability to analyze data from different fact table?
It works for me. Is this what you were doing?
QuoteThis basically means dashboard does not has the capability to analyze data from different fact table?
No, it works for me.