2 Replies Latest reply: Jul 26, 2018 1:02 PM by donato donato RSS

    Count data of yesterday

    donato donato

      Hi all,

       

      I want to count the number of the activations that happened only yesterday. In particular i want to count all the activation that have happened on a particular channel (VP) and I want to see only the activations happened yesterday.

       

      My fields are:

      ACTIVATION_CHANNEL for the channel

      ACTIVATION_DATE for the date).

      ACTIVATION is what I want to count

       

      I used the set analysis and i managed to see the activations that have happened from yesterday until the date I'm checking the report (if I check the report today at 6pm I can see all the activations happened yesterday and today untile 6 pm

       

      This set analysis is working

      count(distinct{$<ACTIVATION_CHANNEL={'VP'},ACTIVATION_DATE = {">$(=Date(Today()-2,'YYYYMMDD'))"}>}ACTIVATION)

       

      If I use the following set analysis I can see the activations happened today

      count(distinct{$<ACTIVATION_CHANNEL={'VP'},ACTIVATION_DATE = {">$(=Date(Today()-1,'YYYYMMDD'))"}>}ACTIVATION)

       

      However, I'm not able to see the activation happened only yesterday.

       

      I tried the following set analyses but they are not working:

       

      count(distinct{$<ACTIVATION_CHANNEL={'VP'},ACTIVATION_DATE = {"$(=Date(Today()-2,'YYYYMMDD'))"}>}ACTIVATION)

      this one is the same as the first set analysis but without the >


      count(distinct{$<ACTIVATION_CHANNEL={'VP'},ACTIVATION_DATE = {">$(=Date(Today()-2,'YYYYMMDD'))<$(=Date(Today()-1,'YYYYMMDD'))"}>}ACTIVATION)


      count(distinct{$<ACTIVATION_CHANNEL={'VP'},ACTIVATION_DATE = {">$(=Date(Today()-2,'YYYYMMDD'))"},ACTIVATION_DATE = {"<$(=Date(Today()-1,'YYYYMMDD'))"}>}ACTIVATION)



      Here, an example of the format of the ACTIVATION_DATE field


       

      ACTIVATION_DATE
      20170908
      20170920
      20170904
      20170905
      20170907
      20170906
      20180222
      20171108
      20171120
      20171116
      20171114



      Do you have any suggestion how to show only the activation of yesterday?


      Thank you in advance