I used the google graphics engine to add graphs in key places. There are essentially 3 places where graphs are placed.
- When you're comparing one set of numbers to another set with key field (required) or multiple key fields, theoretically, you'll end up with numbers that equal each other, except for those that don't. So a graph is generated automatically that shows the amounts that match... They basically form a 45 degree line. Those that do not match fall outside the line. You can mouse over any point to see what's off.
- If you're looking at only one set of data because you want to find out certain things about the data. It's not a reconciliation situation. Like let's say you want to check for strange activity in vendor accounts. So you can upload a table with disbursements. Each line will have an amount and a vendor. Crush will create something like an Excel Pivot table that summarizes the disbursements by Vendor. But Crush will also show a graph that plots the number of vendor transactions against the sum of all of the transactions. So you can quickly isolate the vendors with infrequent payments, but big amounts. Crush also will highlight Vendors that are paid lots of little checks and one big check. So you'll be able to see how they will Skew.
- When you sum up a bunch of items by a key field, like a vendor, you can click on a popup that displays all of the rows that sum to that key field. It's very similar to a drill down on an Excel pivot. You can now click a link that will display a Histogram of those numbers. So you can quickly see if there is something strange going on.
RSS Feed
