Sample data

Group1 - B-1234
Group2 - B-1234, B-2345, B-5678
Venue1 - B-5678, 1234


with interval
-----------------
Groupbys: []
Response: no of days * (1 record with sums of common triggers for selected locations)
| date       | new_visitors | visitors | visits| recurring_visitor | dwell_average 	| dwell_sum		  |
|:-----------|:-------------|:---------|:------|:------------------|:---------------|:--------------|
| 2017-09-01 | 3137         | 3311     | 5000  |	3000		         |	40    	  	 	|	400	     	    |
| 2017-09-02 | 3137         | 3311     | 5000  |	3000		         |	40	      	 	|	400	     	    |



Groupbys : [GROUP, VENUE, TRIGGER]
Response: No of records = (no of days) * (sum of all triggers)  = 2*6 = 12

| date       | group  | new_visitors | visitors | visits| recurring_visitor | dwell_average | dwell_sum	 |  venue 	  | trigger 	| identifier | origin	|
|:-----------|:-------|:-------------|:---------|:------|:------------------|:--------------|:-----------|:-----------|:----------|:----------|:---------|
| 2017-09-01 | Group1 | 3137         | 3311     | 5000	|	3000			        |	40			      |	400	       | 			      | B-1234		| 1234		  | beacons  |
| 2017-09-01 | Group2 | 3137         | 3311     | 5000	|	3000			        |	40			      |	400	       |			      | B-1234		| 1234		  | beacons  |
| 2017-09-01 | Group2 | 3137         | 3311     | 5000	|	3000			        |	40			      |	400	       |			      |	B-2345		| 2345		  | beacons  |
| 2017-09-01 | Group2 | 3137         | 3311     | 5000	|	3000			        |	40			      |	400	       |			      |	B-5678		| 5678		  | beacons  |
| 2017-09-01 | 		    | 3137         | 3311     | 5000	|	3000			        |	40			      |	400	       |	Venue1	  |	B-5678		| 5678		  | beacons  |
| 2017-09-01 | 		    | 3137         | 3311     | 5000	|	3000			        |	40			      |	400	       |	Venue1	  |	1234		  | 1234		  | geofences|
| 2017-09-02 | Group1 | 3137         | 3311     | 5000	|	3000			        |	40			      |	400	       | 			      | B-1234		| 1234		  | beacons  |
| 2017-09-02 | Group2 | 3137         | 3311     | 5000	|	3000			        |	40			      |	400	       |			      | B-1234		| 1234		  | beacons  |
| 2017-09-02 | Group2 | 3137         | 3311     | 5000	|	3000			        |	40			      |	400	       |			      |	B-2345		| 2345		  | beacons  |
| 2017-09-02 | Group2 | 3137         | 3311     | 5000	|	3000			        |	40			      |	400	       |			      |	B-5678		| 5678		  | beacons  |
| 2017-09-02 | 		    | 3137         | 3311     | 5000	|	3000			        |	40			      |	400		     |	Venue1	  |	B-5678		| 5678		  | beacons  |
| 2017-09-02 | 		    | 3137         | 3311     | 5000	|	3000			        |	40			      |	400		     |	Venue1	  |	1234		  | 1234		  | geofences|

Groupbys : [GROUP, VENUE]
Response: No of records = no of days * (no of locations)  = 2*3=6

| date       | group  | new_visitors | visitors | visits| recurring_visitor | dwell_average | dwell_sum	 |  venue 	  |
|:-----------|:-------|:-------------|:---------|:------|:------------------|:--------------|:-----------|:-----------|
| 2017-09-01 | Group1 | 3137         | 3311     | 5000	|	3000			        |	40			      |	400	       | 			      |
| 2017-09-01 | Group2 | 3137         | 3311     | 5000	|	3000			        |	40			      |	400		     |			      |
| 2017-09-01 | 		    | 3137         | 3311     | 5000	|	3000			        |	40			      |	400		     |	Venue1	  |
| 2017-09-02 | Group1 | 3137         | 3311     | 5000	|	3000			        |	40			      |	400	       | 			      |
| 2017-09-02 | Group2 | 3137         | 3311     | 5000	|	3000			        |	40			      |	400		     |			      |
| 2017-09-02 | 		    | 3137         | 3311     | 5000	|	3000			        |	40			      |	400		     |	Venue1	  |


Groupbys : [GROUP, TRIGGER]
Response: No of records = no of days * (sum of all triggers for the groups)  = 2*4=8

| date       | group  | new_visitors | visitors | visits| recurring_visitor | dwell_average | dwell_sum	 |  venue 	  | trigger 	  | identifier | origin	|
|:-----------|:-------|:-------------|:---------|:------|:------------------|:--------------|:-----------|:-----------|:------------|:-----------|:---------|
| 2017-09-01 | Group1 | 3137         | 3311     | 5000	|	3000			        |	40			      |	400	       | 			      | B-1234		  | 1234		   | beacons  |
| 2017-09-01 | Group2 | 3137         | 3311     | 5000	|	3000			        |	40			      |	400		     |			      | B-1234		  | 1234		   | beacons  |
| 2017-09-01 | Group2 | 3137         | 3311     | 5000	|	3000			        |	40			      |	400		     |			      |	B-2345		  | 2345		   | beacons  |
| 2017-09-01 | Group2 | 3137         | 3311     | 5000	|	3000			        |	40			      |	400		     |			      |	B-5678		  | 5678		   | beacons  |
| 2017-09-02 | Group1 | 3137         | 3311     | 5000	|	3000			        |	40			      |	400	       | 			      | B-1234		  | 1234		   | beacons  |
| 2017-09-02 | Group2 | 3137         | 3311     | 5000	|	3000			        |	40			      |	400		     |			      | B-1234		  | 1234		   | beacons  |
| 2017-09-02 | Group2 | 3137         | 3311     | 5000	|	3000			        |	40			      |	400		     |			      |	B-2345		  | 2345		   | beacons  |
| 2017-09-02 | Group2 | 3137         | 3311     | 5000	|	3000			        |	40			      |	400		     |			      |	B-5678		  | 5678		   | beacons  |

CASE 4
Groupbys : [VENUE, TRIGGER]
Response: No of records = no of days * (sum of all triggers for the venue)  = 2*2=4
| date       | group  | new_visitors | visitors | visits| recurring_visitor | dwell_average | dwell_sum	 |  venue 	  | trigger 	| identifier | origin	|
|:-----------|:-------|:-------------|:---------|:------|:------------------|:--------------|:-----------|:-----------|:----------|:----------|:---------
| 2017-09-01 | 		    | 3137         | 3311     | 5000	|	3000			        |	40			      |	400	       |	Venue1	  |	B-5678		| 5678		  | beacons  |
| 2017-09-01 | 		    | 3137         | 3311     | 5000	|	3000			        |	40			      |	400	       |	Venue1	  |	1234		  | 1234		  | geofences|
| 2017-09-02 | 		    | 3137         | 3311     | 5000	|	3000			        |	40			      |	400	       |	Venue1	  |	B-5678		| 5678		  | beacons  |
| 2017-09-02 | 		    | 3137         | 3311     | 5000	|	3000			        |	40			      |	400	       |	Venue1	  |	1234		  | 1234		  | geofences|

CASE 5
Groupbys : [TRIGGER]
Response: No of records = no of days * (sum of all distinct triggers) = 2*4=8
| date       | new_visitors | visitors | visits| recurring_visitor | dwell_average | dwell_sum | trigger 	| identifier | origin	  |
|:-----------|:-------------|:---------|:------|:------------------|:--------------|:----------|:---------|:-----------|:---------|
| 2017-09-01 | 3137         | 3311     | 5000	|	3000			        |	40			      |	400	       | B-1234		| 1234		   | beacons  |
| 2017-09-01 | 3137         | 3311     | 5000	|	3000			        |	40			      |	400	       | B-2345		| 2345		   | beacons  |
| 2017-09-01 | 3137         | 3311     | 5000	|	3000			        |	40			      |	400	       | B-5678		| 5678		   | beacons  |
| 2017-09-01 | 3137         | 3311     | 5000	|	3000			        |	40			      |	400	       | 1234		  | 1234		   | geofences|
| 2017-09-02 | 3137         | 3311     | 5000	|	3000			        |	40			      |	400	       | B-1234		| 1234		   | beacons  |
| 2017-09-02 | 3137         | 3311     | 5000	|	3000			        |	40			      |	400	       | B-2345		| 2345		   | beacons  |
| 2017-09-02 | 3137         | 3311     | 5000	|	3000			        |	40			      |	400	       | B-5678		| 5678		   | beacons  |
| 2017-09-02 | 3137         | 3311     | 5000	|	3000			        |	40			      |	400	       | 1234		  | 1234		   | geofences|

CASE 6
Groupbys : [GROUP]
Response: No of records =no of days *  (no of groups)
| date       | group  | new_visitors | visitors | visits| recurring_visitor | dwell_average | dwell_sum	 |  venue 	  |
|:-----------|:-------|:-------------|:---------|:------|:------------------|:--------------|:-----------|:-----------|
| 2017-09-01 | Group1 | 3137         | 3311     | 5000	|	3000			        |	40			      |	400	       | 			      |
| 2017-09-01 | Group2 | 3137         | 3311     | 5000	|	3000			        |	40			      |	400		     |			      |
| 2017-09-02 | Group1 | 3137         | 3311     | 5000	|	3000			        |	40			      |	400	       | 			      |
| 2017-09-02 | Group2 | 3137         | 3311     | 5000	|	3000			        |	40			      |	400		     |			      |

CASE 7
Groupbys : [VENUE]
Response: No of records = no of days * (no of venues)
| date       | group  | new_visitors | visitors | visits| recurring_visitor | dwell_average | dwell_sum	 |  venue 	  |
|:-----------|:-------|:-------------|:---------|:------|:------------------|:--------------|:-----------|:-----------|
| 2017-09-01 | 		    | 3137         | 3311     | 5000	|	3000			        |	40			      |	400		     |	Venue1	  |
| 2017-09-02 | 		    | 3137         | 3311     | 5000	|	3000			        |	40			      |	400		     |	Venue1	  |