The Malartu Document Reader is one of our most flexible data sources in your arsenal. Using the reader and a few formatting guidelines, you can quickly upload financial data from any Excel, CSV, PDF, JPG, or file type to your account and work with this data to calculate new KPIs.
The main formatting rules for a document to be correctly read in our reader are:
- Metric names are present and legible in a column
- There is a legible row specifying the date corresponding to any data point.
These are examples of readable files:
An example of an image or file that will not be read is:
This file won't work because the metrics are not organized in a way that clearly articulates which date corresponds to which data point. There are two dates for each metric and it isn't clear if the metric is the row name or within the column.
Mapping New Data from the Reader
Once the document reader has successfully read and pivoted the data from your sheet, you will give each new metric a name for Malartu to reference in the system.
First search your metric, if you can't find a synonymous name in the provided list, create a new metric.
- Give your new metric a name
- Set the aggregation: this is the logic that say "if I want to view 4 weeks of data as 1 month, do we sum, take the last figure, take an average of each week, etc."
Once all metrics are mapped, click submit and you can work with this data in your dashboards.