The input data in this example use case consists of sales numbers in CSV format. This dataset is from here on, referred to as "sales". The data is collected in real-time from the regions "APAC", "AMERICAS", and "EMEA". We want to calculate the total-, average, and number of sales per minute. These numbers will be our KPIs, broken down per country and region.
Example - Input data
| timestamp | region | country | amount |
|---|---|---|---|
| 2017-03-08T13:53:52.123 | EMEA | Sweden | 123.50 |
| 2017-03-08T13:53:56.123 | APAC | India | 12.12 |
| 2017-03-08T13:53:59.123 | AMERICAS | US | 425.23 |