# Ticket #1854 (new story)

## LeMill statistics module

Reported by: | hans | Owned by: | anonymous |
---|---|---|---|

Priority: | blocker | Milestone: | 2.7 |

Component: | generic | Version: | |

Keywords: | Cc: | ||

Time planned: | Time remaining: | ||

Time spent: |

### Description (last modified by hans) (diff)

This user story describes the statistics module of LeMill. Statistics module will replace the current statistics page: http://lemill.net/lemill_tool/showStats

General requirements:

- Statistics module should be accessible for reviewers and managers.
- All data in statistics module should be displayed as a tables.
- Each table should be downloadable in CSV format.
- Statistics module is clean XHTML without LeMill design (tables can grow much wider than 800px)

In the first implementation the statistics module should contain the following tables:

**Number of members** (country, number of users by date, estimated number of users, estimated percentage). Number of users is calculated for the beginning of each month (we should have this data since may 2006). Estimated number of users is calculated with the following formula:
number_of_users_in_country / ((total_number_of_users - number_of_users_without_country)/total_number_of_users)

https://lemill.org/trac/attachment/ticket/1854/number_of_users_table.pdf

Other tables with quantitative data should look similar:

Number of published web pages (language, 01.05.2006, …, 01.11.2008, percentage)

Number of published presentations (language, 01.05.2006, …, 01.11.2008, percentage)

Number of published exercises (language, 01.05.2006, …, 01.11.2008, percentage)

Number of published lesson plans (language, 01.05.2006, …, 01.11.2008, percentage)

Number of published school projects (language, 01.05.2006, …, 01.11.2008, percentage)

Number of published pilots (language, 01.05.2006, …, 01.11.2008, percentage)

Number of media pieces (01.05.2006, …, 01.11.2008)

Number of references (language, 01.05.2006, …, 01.11.2008, percentage)

Number of print resources (language, 01.05.2006, …, 01.11.2008, percentage)

Number of methods (language, 01.05.2006, …, 01.11.2008, percentage)

Number of tools (language, 01.05.2006, …, 01.11.2008, percentage)

Number of groups (first language, 01.05.2006, …, 01.11.2008, percentage)

## Attachments

## Change History

### comment:4 Changed 11 years ago by pjotr

We might want to generate the whole statistics data once a day, and maybe save it as some static html pages or something. This way it would not start taking too many resources. We should also add the time and date of generation so that person would know what time does the statistics refer to (in addition it would also tell us if something is wrong and statistics does not get recalculated).

### comment:6 Changed 11 years ago by hans

Actually for this quantitative data it is even OK if these tables are generated once in a month on the first date. This data is used in presentations / articles / etc. In these cases it is not crucial to have real-time data.

I will change the priority to blocker, because it is now possible to start working with the ticket.

**Note:**See TracTickets for help on using tickets.

More tables will come. I will keep this ticket in

waitingstatus until most important tables are described.