8 Replies Latest reply on Sep 13, 2018 11:29 PM by Mahfooj Khan

    Difference vs yesterday as just one number

    Tristan Calwell

      Hi community,

       

      I am working with partitioned tables in Big Query. Each day an entire table of "jobs" is created. Each "job" has and "job_Id" (unique) and an "ad_id" (duplicated) . Each table has an export date. Of course most of the job_ids will be the same each day except for changes.

       

      I need to show the change over one day to the next as just one number rather a table showing difference compared to prev period.

       

      I can get to totals and I can get the change, but I just want the highlighted value below as one number to use in a text string of "today there has been a increase/decrease of X jobs', in this case 47. So how do I just show the value of 47 for today?

       

       

      Thanks

       

      Tristan