1 Reply Latest reply: Feb 12, 2018 2:26 PM by Sunny Talwar RSS

    How to control expression output by checking Todays date vs another date?

    John Blomqvist

      Hi,

       

      I want to control a information shown in a gauge based on today's date against a date table.

       

      Example:

       

      Show Dec 2017/18 data only after the PublishDate of 19/02/2018 is reached.

       

      Or in other words, If Today's date is less than or equal to 19/02/2018 then show Nov 2017/18 data, otherwise show Dec 2017/18 data.

      My PublishDate resides in a table like this:

       

      MonthYearPublishDate
      Nov 2017/1814/01/2018
      Dec 2017/1819/02/2018

      Jan 2017/18

      11/03/2018
      Feb 2017/1815/04/2018
      Mar 2017/1818/05/2018

       

      Does anyone know how to include this inside an aggregation such as count or sum? It is Set Analaysis I think but am a little stuck on how to wrtie it.

       

      This is a gauge so I have no dimensions, have to do this inside my aggregation expression.