I have been trying the past few hours to implement an Interval Match where the last date field that I'm looking for is before the departure date field.
This is the Script for the Interval Match with the fields that I'm using:
Date_90_dayss: LOAD date as date90 RESIDENT History_OnTheBooks;
In this table example, the idea is that when I choose that Date (09/21/2020) which is the date90 field, all the values to be shown must be before the departure date.
This is the set analyisis that I'm using for the values Rate, Room night and Total Revenue:
Rate: Sum ({$<type_sya={"adsyad"}>} total_revenue) / Sum({$<type_sya={"adsyad"}>} room_night)