The Indigo Excel Application is driven from data from within the FastStats system. Therefore to make these statistics available for FastStats users to allow them to do more detailed analysis with these definitions. In order to save time, Adroit have recreated the statistics from the Indigo Application within FastStats, using a combination of cubes and tree visualisations.
These objects use the same definitions which are applied to produce the statistics in Indigo, therefore as a result users can dig deeper to understand how any definitions have been applied. They are also able to adjust these definitions for their own purposes if required.
The FastStats Indigo Replication objects can be found within the “My Discoverer Folder” area within the “Folder Explorer” in FastStats Discoverer. The full path is: My Discoverer Folder/Public/Standard Templates/Blog/Indigo Stats Replication. Within this folder there is a folder for each report within Indigo.
Depending on the report, some reports are replicated within one FastStats object, in other the report may be presented in a number of different objects. This depends on the complexity of the report and nature of the information which is being presented.
Firstly, let’s look at what these some of these items look like. In the Indigo App metrics appear in tables within the report, these metrics are in separate boxes. In this example I am using the “Overall Report”.
In FastStats, we can’t present the information is quite the same way. However in the example below, based on the object called “Indigo – Overall Report (All Gifts)”, the statistics are presented as as a block within a table by default. In the below example we have “Number of Gifts” as the first section, next is the “Gross Fundraising Income”, etc. The layout of the statistics can be change by moving the Σ icon. Similarly the dimensions can be changes to any relevant dimensions within the FastStats system, in the case I have used age band by gift payment date (years). I could if I so wished, could change this to charity by gift payment month for example. Additionally I could add additional dimensions such as Age Band, Charity & Country for example.
In the majority of cases, where it is appropriate there is a table within the cube, which shows a country view (i.e. figures in local currency) and a table for a global view. Which shows values in US Dollars. Therefore care must be taken when working at a “Local” view that, to ensure that different currencies are not aggregated together.
Going forward we are intending to write more articles which show how these specific templates could be used in practice.