i have a simple line chart:
dimension : Date
Expression : SUM(Value)
now i have another table which contains the following columns:
start date campaign, end date campaign, target
i want to use this table to plot a reference line i my chart.
this line should be plotted across the campaign start date and end date.
i tried this:
sum({<Date={">=$(=min([Start Date]))<=$(=min([End Date]))"}>} [Target])
but gives me only 2 records (facts for 2 days) while i would expect 5 records:
target | value
100 | 0
100 | 0
100 | 10
100 | 20
100 | 0
