← Back to team overview

dhis2-users team mailing list archive

Re: Indicator Group Set Dimension in DHIS2.11 Pivot Table

 

Thanks Lars,

The system works as it is, just takes much longer to get to the same
result. Will share details with you.

Best wishes,
Busoye


On 29 April 2013 09:47, Lars Helge Øverland <larshelge@xxxxxxxxx> wrote:

> Hi Busoye,
>
> I get your point.
>
> Sorry to say we don't support indicator group sets for analysis yet. No
> doubt that it would be useful and a natural thing to implement. However I
> can't promise exactly when we will be able to do it - it will be a bit
> tricky from an implementation perspective and the roadmap is already a bit
> packed... But will work on it and let you know.
>
> best regards,
>
> Lars
>
>
>
>
>
>
> On Fri, Apr 26, 2013 at 9:42 AM, Busoye Anifalaje <busoye@xxxxxxxx> wrote:
>
>> Hi all,
>>
>> Is it at all possible to have indicator group sets added to the web-based
>> pivot table layout dimension (DHIS 2.11)? I am working on a data set where
>> all data elements have to be transformed to indicators because different
>> data elements have different weightings. This means that the values in the
>> data elements are not that useful and cannot be compared in any meaningful
>> analysis. Some background to this request are as follows:
>>
>> 1) The data elements I'm working with relate to scoring hospitals on a
>> set of predefined criteria.
>>
>> 2) Data elements are grouped into 1 of 5 different Standards Category
>> (Leadership, Workforce, Environment, Clinical Care and Quality)
>>
>> 3) Scores are: 0 (non-compliant), 1 (Partially compliant), or 2(Fully
>> compliant); It is also possible to indicate that a particular criteria is
>> "Not Applicable".
>>
>> 4) Each dataelement score (or criteria) has a weighting based on
>> important(0.25), Most Important (0.5) or Essential (1)
>>
>> 5) Each data element belongs to 2 groups: Standards Category and Weighting
>>
>> 6) An illustration:
>>                 i) Data Element1 is in the Leadership Standards Category
>>                 ii) Data Element1 has a score of 1 and assigned weighting
>> is Important;
>>                iii) Data Element1 Weighted Score = [score]*[weighting] =
>> 0.25
>>               iii)  Reports needs to aggregate by Standards (Leadership)
>> and Weighting (Important)
>>
>> Points (1) to (5) have been designed and working well. I created a custom
>> data entry form with both data elements and indicators. In the file
>> attached (i.e. Data Entry Screen...), the Columns, Max Score and Obtained
>> Weighted Score are calculated data elements created as indicators. The
>> Totals at the top (i.e. shaded row) are also indicators created separately
>> (as opposed to an automated aggregation function).
>>
>> The issue is with the reporting because I now essentially need groupings
>> based on indicators rather than data elements. The web-based pivot table is
>> great but I find that unless I can bring in indicator group sets, it is
>> impossible to create the required reports. The other option I considered
>> was designing a custom form based on the indicators but of course, this
>> didn't work. I have attached a file (Report Example) to give an idea of the
>> report output required.  Not sure if and how a standard report might help.
>>
>> Any advice would be most appreciated.
>>
>> Thanks.
>>
>> Kind regards,
>>
>> Busoye
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>

References