Extrapulate data from last known data plot

[tinkerz1]

Hi,

As my data stops mid year on a monthly scale, and I would like to take the last known data point and contuinue it over the entire data range.

Can this be done in set analysis?

=sum(distinct if([Status]='Open',[MSII Threshold Data]))

Thanks

[krishna_2644]

=sum({$<[Status]={'Open'}>} DISTINCT [MSII Threshold Data])

[tinkerz1]

Hi,

Thanks for the set analysis code but the issue is no date data for the Threshold Data, the set analysis code will work only if there is date data, my date column has other dates in it, that means only partial data for the thresholds against the other dates.

Thanks,