The Long file output of a Ranking Consumption - Trade Area Report includes Incidence and Incidence % fields that aren’t present in the dashboard output.
Note: The example below is showing dollar values as the consumption data but if you were using a non-dollar variable, the 'Consumption Unit' column or 'Aggregate $' column is still total aggregate consumption.
Ranking Consumption - Trade Area Report: Dashboard output:
Ranking Consumption - Trade Area Report: Long File Download
Field Name Reconciliation
|Consumption Unit||-||Aggregate $|
|% Comp||-||% Incidence|
|Base Consumption Unit||-||Base Aggregate $|
|Base Unit/Hhld||-||Base $/Hhld|
|Base % Comp||-||Base % Incidence|
|Index Unit/Hhld||-||Index: $/Hhld|
|Index % Comp||-||Index: $/Incidence|
The Incidence values in the Long File Download are the aggregate consumption values of the variable.
- Aggregate $
- % Incidence
- Base Aggregate $
- Base $/Hhld
- Base % Incidence
- Index: $/Hhld
- Index: $/Incidence