Set analysis with point in time reporting

gt_nyc — Mon, 11 Oct 2021 16:30:03 GMT

I am trying to show the value of our sales pipeline over time: I have an independent generated calendar listing every Mondays and each Sales campaign is versioned with version validity dates.
So users should be able to pick a Monday and see the sales amount for all the versions valid at that time.

generated calendar field= report_date
versions field: version_fromdate, version_todate.

But no matter what I try, all versions are selected regardless of their date range:

sum({$<report_date={'>=version_startdate'}> * <report_date={'=<version_enddate'}>} booking_line.prorated_net_amount)

sum({<report_date={"$(='>=' & Date(version_startdate) & '<' & Date(version_enddate))"}>} booking_line.prorated_net_amount)

topic Set analysis with point in time reporting in App Development

Set analysis with point in time reporting