transactions-extraction

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision		 Previous revision
transactions-extraction [2025/08/10 12:35] – editortransactions-extraction [2025/08/14 16:24] (current) – editor
Line 5: Line 5:
 Click the "Export" button on the transaction page to download the data. 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.\\
-{{::browsing-the-data:transactions:data-extraction:0export.png?nolink&600|}}+{{ ::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.\\ 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.\\
-{{::browsing-the-data:transactions:data-extraction:1pivottable.png?nolink&600|}}+{{ ::wiki:server:wiki:server:browsing-the-data:transactions:data-extraction:1pivottable.png?nolink |}}
  
  • transactions-extraction.1754829323.txt.gz
  • Last modified: 2025/08/10 12:35
  • by editor