reference line question

amien — Wed, 13 Aug 2014 08:25:03 GMT

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 | 10

100 | 20

100 | 0

Re: reference line question

sujeetsingh — Wed, 13 Aug 2014 08:26:52 GMT

Check the linking first

amien — Wed, 13 Aug 2014 08:35:35 GMT

!added example

amien — Wed, 13 Aug 2014 08:37:01 GMT

not sure what you mean .. but i added an example