8 Replies Latest reply: Jan 10, 2018 11:04 AM by Juan Moreno RSS

    Using Set Analysis to ignore filters

    Juan Moreno

      Hi all,

       

      I know this has been asked a lot of times, but no matter what I've read in other posts, I don't manage to get a expression that works for me.

       

      I'm making a chart comparing current speeds to historical speeds. For the current I'm using:

       

      avg({1}{<link_timestamp={'$(=Max({1}link_timestamp))'}>}speed_mph)

       

      This way I get the most current (maximum timestamp) speed values. The problem is that I'm using some filters such as WeekOfDay (Monday, Tuesday... etc.) that work fine for the historical, but not for the current.

       

      E.g. Today's Wednesday. If I choose Tuesday as WeekOfDay, I see the historical speed average for Tuesdays (good) but the current speed graph is gone since today is not Tuesday.

       

      It makes sense, but I want make the current speed expression ignore filters, so it never disappears no matter the filter selections.

       

      Any help?

       

      Thanks much!