Also unique on (event_internal_id, router_statistics, symbol_statistics)
I have a very simple pivot table showing only the data from the 1st table, i.e. SUM(amount) per date, region, symbol
What business needs is to be able to discover under which conditions SUM(amount) from the 1st table is better / worse when filtering amount_i from the 2nd table
Example of filters:
amount_1 > 50 AND amount_2 BETWEEN 10 and 20 for router_statistics R1 and symbol S1
AND
amount_1 < 30 AND amount_3 >= 10 for symbol S2, regardless of the router_statitistics
Does any of you experts know how to achieve this in an optimal way?
