Aggregate/Raw data reports

reporting via the aggregate report builder and raw data explorer breww's reporting suite is vast and provides the ability to pull together a huge range of data points the reporting suite is split across three main areas; pre built reports, aggregate data reporting and raw data reporting pre built reports there are a number of reports to choose from split across three different categories; sales, production & inventory and deliveries pre built reports cover an extensive range of data, such as cogs reporting, stock valuations, batch distribution and more aggregate report builder the custom aggregate data report builder allows reports to be configured across a number of metrics, timeframes and filters to create a report in the aggregate report builder, go to the reporting tab and under the aggregate report builder, select the type of report required reporting timeframe options, as well as any further brewwql filters can be specified in the screen as per the below screenshot report input options|690x263 primary reporting metrics then need to be specified a primary metric is required to run the report, but a second, optional metric can be defined if required extra grouping options are available for each metric report metrics|690x185 custom reports can be saved for easy future access and can be scheduled to be delivered to you automatically by email to schedule a report, firstly configure it as required (we recommend using relative dates, like 'last 12 months' instead of fixed specific dates on saved reports) and then save it for future access automatic delivery can then be automated on a user defined schedule (e g every monday morning), to your email address save report|690x54 raw data explorer start by choosing a dataset to report from (e g stock items, orders or products sold) data fields can be added, removed and reordered to configure the report to your requirements data fields can also span across different datasets which are linked, such as "joining" from an invoice to the customer who received the invoice and then onto (for example), the customer group brewwql filters can also be added to further filter which data will show the results will be shown in a table form as individual rows rather than aggregated together raw data reports be exported to excel for further manipulation and grouping if needed to sort the data in a raw data explorer, you will need to export it to excel this tool allows you to get access to all the core data in your account if there's a dataset that you can't access, but would like to, please feel free to request it to be added as with the aggregate report builder, these reports can also be saved for easy future access you're safe to play around with the options and try different things out in the reporting area without risking changing any of the underlying data, the only exception to this is the stock take function as with the aggregate report builder, you can use brewwqlto filter what results will show in your report you can then save the report for easy future access once that's been done the report will be listed (with your chosen name) in the "reporting" section of breww exporting reports exporting pre built reports once a 'pre built' report has been run, you will be able to export this via either the export to excel or export to csv button on the top right of the page exporting aggregate data reports aggregate data reports can be exported via the export to excel button towards the bottom of the page exporting raw data explorer reports raw data explorer reports can be exported by changing the output option under data to extract to export to excel and then selecting explore data sharing raw data explorer reports using "share codes" a share code allows you to share the "settings" for a raw data explorer report with others (such as the fields to include and the filters to apply) they don't share the data itself, so they can be shared between different breweries and safely posted publically on the breww community please see the dedicated guide reporting share codes docid\ mupjz0utxyybu0tbeut1z