In this tutorial, you will learn how to set up a data export. Each export si defined in the export object.
What you'll create
This is the export window, where you can download the export in a CSV file.
Let's have a look at our customers dataset one more time. We will identify the properties that will be included in our export. Note that all active filters and the map selection are counted in the exports.
The requirement is to export customers, who have made a transaction bigger than 3000 CZK, to give them a special voucher.
The properties we want to include are:
|Customer's age group||string|
The export object will look like this:
Add this export object to the project using
addMetadata. Now we just need to add the export reference to the
Before we perform the export, we have to apply the required filter first.
histogram filter on the
Also, don't forget to that the map window should contain all available areas.
The export is available after clicking the Menu button in the top left corner ( ), and selecting Export.
Select Transactions export and hit Export.
The selected columns, as well as metric results will be present in the transactions_export.csv file. You can see that the metric results do not hold much informational value, because the metrics are not computable for each transaction (e.g. turnover value of one transaction equals to the
This is the
stores dataset we've added in the previous tutorial.
|Store web link||string|
|Designated parking lot||string|
|Number of employees||integer|
We won't put any filters on this export and we'll export these properties:
It is possible to include properties from other datasets in an export. We will include some properties from datasets of the Administrative units dimension we've added in one of the previous tutorials.
cast_obec_dwh.nazev - the city district where the store is located
okres_dwh. - name of the county
kraj_dwh. - name of the region
Add the object using
addMetadata and add the export reference to the
Push the object using
pushProject. Then repeat the export process, but select Stores export and hit Export.
You can see that the stores_export.csv contains all six stores, with respective results of all metrics in all city districts.