0 Replies Latest reply: May 20, 2017 9:38 AM by van Ivanov RSS

    Projection  of data in tables

    van Ivanov

           Hi I have two tables for  2016 & 2015.  I want to  create dashboard for years 2017-2020 reflecting the data from 2015/6 like  a projection for the future.  How can it be done?  I know how to create dashboards but cannot come up with a solution on how to project the data for years to come.???  Thanks

       

       

              

      REGION1 2 3
      Records1Searches2Hits3Records1Searches2Hits3Records1Searches2Hits3
      Africa4,00021,000,0005,000211,0002,813,000 1,700219,0002,620,0001,000
      Americas40,000196,000,000183,0003,600,0008,639,000 1,70010,854,000456,100,00017,500
      Asia17,00010,000,00011,000146,000538,000 5,2003,690,000333,630,0008,000
      Europe91,000653,000,000222,0003,340,000132,471,000 113,50039,600,000856,000,000110,000
      TOTAL152,000880,000,000421,0007,297,000144,461,000 122,10054,363,0001,648,350,000136,500

       

       

       

       

       

       

       

      1 1 3
      Records1Searches2Hits3Records1 Searches2Hits3Records1Searches2Hits3
      Africa15,00020,000,0005,000216,000 2,656,0002,500236,00022,600,0002,000
      Americas47,000260,000,000122,0003,600,000 8,279,0002,2001,300,000523,000,00026,000
      Asia17,00017,000,00014,000133,000 879,0002,0006,700,000250,000,00015,000
      Europe92,000590,000,000277,0003,300,000 175,000116,00049,500,000850,000,000111,000
      TOTAL171,000887,000,000418,0007,249,000 11,989,000 122,70057,736,0001,645,600,000154,000