Hi.
In perfect it should look like this:
Table schema in first post - base structure that stopped my work.
Responses with no offers means calls with 0 NumberOfSearchResults or cases when this log is absent.
For single call there always log with SearchLocations, but for this call log with NumberOfSearchResults can be absent.
According to my logic, as all logs have RequestId, we can use it for grouping.
Long story short: i need to know number of calls that returned no offers for the route per Tenant grouped by GDS and how many % of calls had no offers.
I should not attach 3 logs. Third one is about filtered results and it something that would be nice to include to the table, but it is optional.