Here in Bangladesh they are very found of the Data Status feature of the Indian Data Analyzer module.
One key feature there is to not only see the percentage of datasets reported (which is available in DV, Pivots, GIS as well), but to also see the count of values collected for each data element/categoryoptioncombo (or data element total count).
This gives a much better detail to which parts of a dataset that is used (and not used), and also potentially to look at data elements that are very rarely used and therefore potential candidates for removal in the next revision of forms etc.
Would it be possible to add an option in Pivot Tables to change the aggregation method for data values to count?
This could be useful in DV and GIS as well, but I think Pivot Tables is the most suitable place for this kind of “data browsing”.
Ola
···
Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo
Mobile: +47 48069736
Home address: Eftasåsen 68, 0687 Oslo, Norway. Googlemaps link
Hi Ola,
I think it makes a lot of sense. The “Data browser” of course offers this type of functionality, but it is sort of buried inside the admin module. We have used it here in Zambia for the same purpose, but it was developed a long time before the pivot table module, so much of this could really be done better nowadays with the PT. Would be useful here as well.
Best regards,
Jason
···
On Tue, Jun 3, 2014 at 11:17 AM, Ola Hodne Titlestad olati@ifi.uio.no wrote:
Hi,
Here in Bangladesh they are very found of the Data Status feature of the Indian Data Analyzer module.
One key feature there is to not only see the percentage of datasets reported (which is available in DV, Pivots, GIS as well), but to also see the count of values collected for each data element/categoryoptioncombo (or data element total count).
This gives a much better detail to which parts of a dataset that is used (and not used), and also potentially to look at data elements that are very rarely used and therefore potential candidates for removal in the next revision of forms etc.
Would it be possible to add an option in Pivot Tables to change the aggregation method for data values to count?
This could be useful in DV and GIS as well, but I think Pivot Tables is the most suitable place for this kind of “data browsing”.
Ola
Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo
Mobile: +47 48069736
Home address: Eftasåsen 68, 0687 Oslo, Norway. Googlemaps link
in pivot table in 2.15 try going to options > aggregation type > count and see if that covers it.
Lars
···
On Tue, Jun 3, 2014 at 11:17 AM, Ola Hodne Titlestad olati@ifi.uio.no wrote:
Hi,
Here in Bangladesh they are very found of the Data Status feature of the Indian Data Analyzer module.
One key feature there is to not only see the percentage of datasets reported (which is available in DV, Pivots, GIS as well), but to also see the count of values collected for each data element/categoryoptioncombo (or data element total count).
This gives a much better detail to which parts of a dataset that is used (and not used), and also potentially to look at data elements that are very rarely used and therefore potential candidates for removal in the next revision of forms etc.
Would it be possible to add an option in Pivot Tables to change the aggregation method for data values to count?
This could be useful in DV and GIS as well, but I think Pivot Tables is the most suitable place for this kind of “data browsing”.
Ola
Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo
Mobile: +47 48069736
Home address: Eftasåsen 68, 0687 Oslo, Norway. Googlemaps link
Hi Ola,
I think it makes a lot of sense. The “Data browser” of course offers this type of functionality, but it is sort of buried inside the admin module. We have used it here in Zambia for the same purpose, but it was developed a long time before the pivot table module, so much of this could really be done better nowadays with the PT. Would be useful here as well.
On Tue, Jun 3, 2014 at 11:17 AM, Ola Hodne Titlestad olati@ifi.uio.no wrote:
Hi,
Here in Bangladesh they are very found of the Data Status feature of the Indian Data Analyzer module.
One key feature there is to not only see the percentage of datasets reported (which is available in DV, Pivots, GIS as well), but to also see the count of values collected for each data element/categoryoptioncombo (or data element total count).
This gives a much better detail to which parts of a dataset that is used (and not used), and also potentially to look at data elements that are very rarely used and therefore potential candidates for removal in the next revision of forms etc.
Would it be possible to add an option in Pivot Tables to change the aggregation method for data values to count?
This could be useful in DV and GIS as well, but I think Pivot Tables is the most suitable place for this kind of “data browsing”.
Ola
Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo
Mobile: +47 48069736
Home address: Eftasåsen 68, 0687 Oslo, Norway. Googlemaps link
