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
REGION | | 1 | | | | 2 | | 3 | |
| | | | | | | | | | |
Records1 | Searches2 | Hits3 | Records1 | | Searches2 | Hits3 | Records1 | Searches2 | Hits3 |
| |
Africa | 4,000 | 21,000,000 | 5,000 | 211,000 | 2,813,000 | | 1,700 | 219,000 | 2,620,000 | 1,000 |
Americas | 40,000 | 196,000,000 | 183,000 | 3,600,000 | 8,639,000 | | 1,700 | 10,854,000 | 456,100,000 | 17,500 |
Asia | 17,000 | 10,000,000 | 11,000 | 146,000 | 538,000 | | 5,200 | 3,690,000 | 333,630,000 | 8,000 |
Europe | 91,000 | 653,000,000 | 222,000 | 3,340,000 | 132,471,000 | | 113,500 | 39,600,000 | 856,000,000 | 110,000 |
TOTAL | 152,000 | 880,000,000 | 421,000 | 7,297,000 | 144,461,000 | | 122,100 | 54,363,000 | 1,648,350,000 | 136,500 |
| | 1 | | | | 1 | | 3 | |
| | | | | | | | | | |
Records1 | Searches2 | Hits3 | Records1 | | Searches2 | | Hits3 | Records1 | Searches2 | Hits3 |
| | |
Africa | 15,000 | 20,000,000 | 5,000 | 216,000 | | 2,656,000 | | 2,500 | 236,000 | 22,600,000 | 2,000 |
| | | | | | | | | | | |
Americas | 47,000 | 260,000,000 | 122,000 | 3,600,000 | | 8,279,000 | | 2,200 | 1,300,000 | 523,000,000 | 26,000 |
| | | | | | | | | | | |
Asia | 17,000 | 17,000,000 | 14,000 | 133,000 | | 879,000 | | 2,000 | 6,700,000 | 250,000,000 | 15,000 |
| | | | | | | | | | | |
Europe | 92,000 | 590,000,000 | 277,000 | 3,300,000 | | 175,000 | | 116,000 | 49,500,000 | 850,000,000 | 111,000 |
| | | | | | | | | | | |
TOTAL | 171,000 | 887,000,000 | 418,000 | 7,249,000 | | 11,989,000 | | 122,700 | 57,736,000 | 1,645,600,000 | 154,000 |