|Version 1 (modified by 11 years ago) ( diff ),
Table of Contents
Charts can be used to quickly and easily visualise data. As Sahana Eden can contain larges amount of informations, Charts can be a valuable tool for presenting this information to Users to support their analysis and decision making.
Types of Charts:
- Line Charts - for quantitate data over time
- Bar Charts - for quantitate data associated with a label
- Pie Charts - for quantitate data associated with a label
Ideally the Sahana Eden framework would be able to be configured to produce a chart method for any resource.
- A Regional Project Manager can use a bar chart to compare the number of projects in different countries and which hazards those projects are addressing to identify needs for new programs (eg. 2 Variable Bar Chart showing the count of projects by Country and Hazard)
- A Project Manager can use a chart to see what types (themes) for projects are being implemented in a specific country for a specific hazard to see if there are best practices to follow or potential for innovation. (eg. 2 Variable Bar Chart showing the count of projects by Hazard Theme filtered by a country )
- A Project Assistant can use a chart to compare the number of beneficiaries in different communities to ensure that all communities are benefiting equally (eg. 2 Variable Bar Chart showing the sum of Beneficiaries by L4 and Beneficiary Type)
- A Project Manager can use a chart to compare the amount of funding different donors are giving to find out who the major donors are. (eg. 1 Variable Bar Chart showing the sum of Funds Contributed by Organisation filtered for a specific project). They may then want to view this data in tabular form.
- A Project Assistant can use a chart to view the cumulative number of beneficiaries over time for a specific project/location (eg. Line Chart showing the cumulative sum of Beneficiaries over time filtered for a specific project. Multiple Lines could be shown for different Beneficiary Types)
- A warehouse manager can monitor the stock levels of a specific item in different warehouses to decide if any need to be transferred (eg. 1 Variable Bar Chart showing the quantity of an Item in different warehouses filtered for a specific item)
- A Staff Manager can use a chart to compare the number of staff in different offices to get an overview of the size of each operation (eg. 1 Variable Bar Chart showing the count of Staff by different offices)
- A Volunteer Coordinator can can use a chart to find out which communities have gaps in their number of volunteers (eg. 1 Variable Bar Chart showing the count of Volunteers by different communities). They may then want to then view these numbers on a map.
Many of these requirements are documented based on the assumption that charts will be implemented with a similar method to the current report method. Some of these requirements could also improve the current implementation of Reports.
- Be able to filter the data which is used to generate the chart using S3Search widgets.
- 2 dimensional Bar Chart
- Pick Row / Column based on result of filter
- Automatically associate the aggregate function based on the type of field used for the value.
- String fields will always be aggregated by Count
- It may be desirable to always aggregate an integer/double by sum to avoid confusing users
Currently charts can be generated as part fo the S3Report. However as these are not initially displayed, users may over look these. Hopefully the data generated for this Report view can be utilized for the generation of the charts.