Set analysis greater than p()

[morenoju]

Hi guys,

I need to change this expression so I get all link_date_time_15min values greater than the current possible value for start_timestamp.

This is the expression I have (works, but it's not what I need, since it only returns one value):

=aggr(ONLY({<[link_date_time_15min]=p(start_timestamp)>}[link_date_time_15min]),[link_date_time_15min])

I tried to replace =p(start_timestamp) by >p(start_timestamp) with no luck.

Is it a problem of syntaxis? Can you recommend anything?

Thanks

[morenoju]

Guys, I evolved a bit the master expression and the problem I'm having is that charts take forever to load.

I'm currently doing:

=if('$(=start_timestamp)'<=link_date_time_15min AND '$(=close_timestamp)'>=link_date_time_15min, timestamp(link_date_time_15min,'hh:mm'))

Is there any technique so the calculation of such a dimension doesn't take so long?

[morenoju]

I'm guessing that the problem is that in the if every possible link_date_time_15min gets check to see if it meets the condition and that's what's taking so much time (and CPU).

Do you know how I can reduce the set of link_date_time_15min that get checked?

Or maybe an alternative to IF?