Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a functional Trend line as follows:
linest_m(total aggr(avg([Fare]),[Booking Date]),[Booking Date])*[Booking Date] +
linest_b(total aggr(avg([Fare]),[Booking Date]),[Booking Date])
I'd like to restrict the Trend line measure to [Domestic/International] = 'Domestic'. But, I cannot seem to quite work out the syntax.
Has anyone done this before?
THANKS
Perhaps this?
linest_m(total aggr(avg({<[Domestic/International] = {'Domestic'}>} [Fare]),[Booking Date]),[Booking Date])*[Booking Date] +linest_b(total aggr(avg({<[Domestic/International] = {'Domestic'}>} [Fare]),[Booking Date]),[Booking Date])