Trend Line WITH Set Analysis

jdean1012 — Sat, 16 Nov 2024 04:06:37 GMT

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

Re: Trend Line WITH Set Analysis

Anil_Babu_Samineni — Fri, 15 Nov 2019 02:54:04 GMT

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])

topic Trend Line WITH Set Analysis in App Development

Trend Line WITH Set Analysis

Re: Trend Line WITH Set Analysis