Differences

This shows you the differences between two versions of the page.

--- transactions-extraction [2025/08/09 20:19] – created editor
+++ transactions-extraction [2025/08/14 16:24] (current) – editor
@@ Line 4: / Line 4: @@
 Click the "Export" button on the transaction page to download the data.
-Note that the export requires multiple filters to avoid exporting large amounts of data. For the current purpose, click on "Filters" under "Tx Type" and enter 4 (Input Distribution). To remove a filter, click the Clear Filter link next to the pagination.
+Note that the export requires multiple filters to avoid exporting large amounts of data. For the current purpose, click on "Filters" under "Tx Type" and enter 4 (Input Distribution). To remove a filter, click the Clear Filter link next to the pagination.\\
+{{ ::wiki:server:wiki:server:browsing-the-data:transactions:data-extraction:0export.png?nolink |}}
+Open the exported CSV in Excel and insert a pivot table to sum up the data. For example, you can get an item-community map by adding districts and communities to the rows, details/names to the columns, and details/quantity totals to the values.\\
+{{ ::wiki:server:wiki:server:browsing-the-data:transactions:data-extraction:1pivottable.png?nolink |}}
-Open the exported CSV in Excel and insert a pivot table to sum up the data. For example, you can get an item-community map by adding districts and communities to the rows, details/names to the columns, and details/quantity totals to the values.