Configure a Grafana dashboard using Elastic Search (no setup needed)

I have an Elastic Search index being populated with customers information throughout time. Every time a customer have some of it's information changed, a new object is put in the index (with the timestamp). Connected to the Elastic Search I have Grafana. The objects look like this (simplified version): { "date": "2018-11-10T12:10:16.345Z", "id": "1", "name": "John Doe", "status": "Pending Documents", "statusTimeout": "date": "2018-11-16T12:10:16.345Z", "owner": "Paul" } { "date": "2018-11-13T12:10:16.345Z", "id": "2", "name": "Maria", "status": "Pending Documents", "statusTimeout": "date": "2018-11-15T12:10:16.345Z", "owner": "Robert" } { "date": "2018-11-14T12:10:16.345Z", "id": "2", "name": "John Doe", "status": "Documents Received", "statusTimeout": "date": "2018-11-20T12:10:16.345Z", "owner": "Michael" } The freelancer will receive a user/password to access the Grafana web app and the job is to create a Dashboard where I'll be able to see: [MILESTONE 1] A list of "owners" with the number of customers depending on the "statusTimeout" information: Considering today being 2018-11-14; Example: Paul (expired by +2 days: 0, expired yesterday: 0, expiring today: 0, expiring tomorrow: 0, expiring in +2 days: 0) Michael (expired by +2 days: 0, expired yesterday: 0, expiring today: 0, expiring tomorrow: 0, expiring in +2 days: 1) Robert (expired by +2 days: 0, expired yesterday: 0, expiring today: 0, expiring tomorrow: 1, expiring in +2 days: 0) Note that the first record is being ignored since there is a newer record for the customer John Doe. [MILESTONE 2] - The same list, but for all the owners: All (expired by +2 days: 0, expired yesterday: 0, expiring today: 0, expiring tomorrow: 1, expiring in +2 days: 1) [MILESTONE 3] - A graph of "status" showing the minimum, the maximum and the average time spent in this status;