DHIS Mobile

Introduction DHIS2 provides a range of options to allow data entry from mobile devices, including a dedicated GPRS/3G J2ME client, a SMS based client, and a version of DHIS2 which has been optimized specifically for mobile browsers. Each of these solutions will be described in detail in the following sections. Collection of data in the field can be technically challenging and expensive. Mobile phone solutions has the potential to significantly reduce the complexity of deploying a distributed data collection system. Using a simple Java client installed on a mobile phone or a web browser which works on the mobile phone, field workers can report directly to the DHIS2 database through their mobile device. - While mobile phone solutions have a great potential, it is also an area that can be difficult to "get right". Phones lack processing power and have a small display, need to be charged and often makes the most sense in areas where mobile network coverage is weak and patchy. + While mobile phone solutions have a great potential it is also an area that can be + difficult to "get right". Phones lack processing power and have a small display, + need to be charged and often makes the most sense in areas where mobile network coverage is + weak and patchy. There are currently three main mobile solutions for DHIS2, and we continue to evolve these as well as look at other possible solutions: === added file 'src/docbkx/en/dhis2_user_man_using_pivot_table.xml' --- src/docbkx/en/dhis2_user_man_using_pivot_table.xml 1970-01-01 00:00:00 +0000 +++ src/docbkx/en/dhis2_user_man_using_pivot_table.xml 2013-03-07 17:59:30 +0000 @@ -0,0 +1,151 @@ + + + + Using Pivot Table +

+ Pivot Table overview + The pivot table module enables users to create pivot tables, using all available data + dimensions in DHIS 2. A pivot table is a dynamic tool for + data analysis which lets you quickly summarize and arrange data according to its dimensions. + Examples of data dimensions in DHIS 2 are data elements (explaining what the data means), + periods (representing the time aspect) and the organisational hierarchy (representing the + geographical location of the data). From these dimensions you can freely select dimension + items to include in the pivot table. + A pivot table can arrange data dimensions on columns, + rows, and as filters. + When you place a data dimension on columns, the pivot table will display one column per + dimension item. If you place multiple data dimensions on colums, the pivot table will display + one column for all combinations of the items in the selected dimensions. When you place a data + dimension on rows, the pivot table will display one row per dimension item in a similar + fashion. The dimensions you select as filters will not be included in the pivot table, but + will aggregate and filter the table data based on the selected filter items. + The workflow for creating a simple pivot table is: + + + Select dimension items in the left menu, for instance a few data elements. + + + Click "Layout" on the top menu and arrange the data dimensions as columns, rows, and + filters. You can leave the selection as it is if desired. + + + Click "Update". + + + Based on the demo database, a pivot table approximately as below will be displayed. Notice + how indicators are listed on columns and periods as rows. + + Example pivot table with indicators on columns and periods as rows. + + + + + + +

+ Selecting dimension items + The left menu will list sections for all available data dimensions. From each section you + can select any number of dimension items. As an example, you can open the section for data + elements and select any number of data elements from the available list. You can select an + item by marking it and clicking on the arrow in the section header or simply double-clicking + on the item. Before you can use a data dimension in your pivot table you must at least select + on dimension item. + For the indicator and data + element dimensions you must first select one or all groups from the group list. + You can then select data elements from the list of available items. + For the period dimension you can choose between fixed + and relative periods. An example of a fixed period is "January 2012". To select fixed periods + start by selecting a period type from the period type list. You can then select periods from + the list of available periods. Relative periods are periods relative to the current date. + Examples of relative periods are "Last month" and "Last 5 years". Relative periods can be + selected by ticking the checkboxes next to each relative period. The main advantage of using + relative periods is that when you save a pivot table favorite, it will stay updated with the + latest data as time goes by without the need for constantly updating it. The "Rewind one + period" option will make the relative periods relative to the current date subtracted by one + period. This is useful to manage situations where there is a gap between the end of the + reporting period and the time when data is entered into the system. + For the organisation unit dimension you can select any + number of organisation units in the hierarchy. To select all organisation units below a + specific organisation unit, right click and click "Select all children". To manually select + multiple organisation units, click and hold the Ctrl button + while clicking on organisation units. You can tick "User organisation unit" or "User + organisation unit children" in order to dynamically insert the organisation unit or units + associated with your user account. This is useful when you save a pivot table favorite and + want to share it with other users, as the organisation units linked with the other user's + account will be used when viewing the favorite. + + Selection of fixed and relative periods. + + + + + + +

+ Arranging the table layout + After selecting data dimensions it is time to arrange your pivot table. Click "Layout" in + the top menu to open the layout screen. In this screen you can position your data dimensions + as table columns, rows or filters by clicking and dragging the dimensions from the dimensions + list to the respective column, row and filter lists. You can set any number of dimensions in + any of the lists. For instance, you can click on "Organisation units" and drag it to the row + list in order to position the organisation unit dimension as table rows. + + The table layout screen. + + + + + + + After you have set up your pivot table you can click "Update" to render it, or click + "Hide" to hide the layout screen without any changes taking effect. Since we in our example + have selected both the period and organisation unit dimensions as rows, the pivot table will + generate all combinations of the items in these dimensions and produce a table like + this: + + Pivot table where organisation units and periods are repeated on rows. + + + + + + +

+ Using table options + Several table options are available when working with a pivot table. Open the options + screen by clicking on "Options" in the top menu. The following options are available: + + + Show sub-totals: Display sub-totals in the table for each dimension. In the screenshot + in the previous section, notice how subtotals are generated for each of the periods in the + period dimension. + + + Hide empty rows: Hides empty rows from the table. This is useful when looking at large + tables where a big part of the dimension items do not have data in order to keep the table + more readable. + + + Display density: Controls the size of the cells in the table. Can be set to + "comfortable", "normal" and "compact". The "compact" option is handy in order to fit large + tables into the browser screen. + + + Font size: Controls the size of the table text font. Can be set to "large", "normal" + and "small". + + +

+ Downloading data + You can download the data in the current pivot table by clicking on "Download" in the top + menu. The data can be downloaded in Microsoft Excel and CSV format. The downloaded data table + will have one column per dimension. You can easily create a pivot table in Microsoft Excel + from the the downloaded Excel file by clicking on "pivot table" in the top panel, then + clicking on "create pivot table", marking the data range in the spreadsheet before clicking + "OK". +

+ === modified file 'src/docbkx/en/dhis2_user_manual_en.xml' --- src/docbkx/en/dhis2_user_manual_en.xml 2012-08-05 17:59:52 +0000 +++ src/docbkx/en/dhis2_user_manual_en.xml 2013-03-07 17:59:30 +0000 @@ -21,6 +21,7 @@ + === added directory 'src/docbkx/en/resources/images/pivot_table' === added file 'src/docbkx/en/resources/images/pivot_table/basic_pivot.png' Binary files src/docbkx/en/resources/images/pivot_table/basic_pivot.png 1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/pivot_table/basic_pivot.png 2013-03-07 17:59:30 +0000 differ === added file 'src/docbkx/en/resources/images/pivot_table/period_dimension.png' Binary files src/docbkx/en/resources/images/pivot_table/period_dimension.png 1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/pivot_table/period_dimension.png 2013-03-07 17:59:30 +0000 differ === added file 'src/docbkx/en/resources/images/pivot_table/pivot_rows.png' Binary files src/docbkx/en/resources/images/pivot_table/pivot_rows.png 1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/pivot_table/pivot_rows.png 2013-03-07 17:59:30 +0000 differ === added file 'src/docbkx/en/resources/images/pivot_table/table_layout.png' Binary files src/docbkx/en/resources/images/pivot_table/table_layout.png 1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/pivot_table/table_layout.png 2013-03-07 17:59:30 +0000 differ