← Back to team overview

dhis2-users team mailing list archive

Re: How to apply disaggregation to indicators

 

Hi all,

Please let me put my steps here again for all to see.

I created data elements and applied categories. Entered data for all the
elements.

I created indicators by dividing all the data elements by another data
element. (I believe the categorization is lost at this point).

I created a category option group and with the same options used for the
data elements. I then created category option group set containing the
option group. In the option group and in the option group set, I selected
data dimension and data dimension type Disaggregation.

On visualizer app, i selected the indicators, the applicable period and
location, this gives me data. But when i applied the dimensions of the
category option group set, no error is displayed but no data to display. I
have attached the final chart and my layout arrangements.

By my understanding, this is expected since there was no connection between
the indicators and category option group set. The question is have I set
things up correctly? if not what did i miss or do wrongly pls?


On Thu, Jul 26, 2018 at 12:42 PM Olaleke Seweje <sewejeolaleke@xxxxxxxxx>
wrote:

> Yes, I believe. I went to reports->analytics and exported.
> Is that what you mean by refresh?
>
>
> On Thu, Jul 26, 2018 at 11:45 AM Jason Pickering <
> jason.p.pickering@xxxxxxxxx> wrote:
>
>> Did you do a full refresh of analytics after creating the group set and
>> before using the data visualizer?
>>
>> Regards,
>> Jason
>>
>>
>> On Thu, Jul 26, 2018 at 12:34 PM Olaleke Seweje <sewejeolaleke@xxxxxxxxx>
>> wrote:
>>
>>> Hello Jason,
>>> Thanks for your response but I tried your suggestion to no avail. Let me
>>> explain my steps in case there is something i did wrong.
>>>
>>> I created data elements and applied categories. Entered data for all the
>>> elements.
>>>
>>> I created indicators by dividing all the data elements by another data
>>> element. (I believe the categorization is lost at this point).
>>>
>>> I created a category option group and with the same options used for the
>>> data elements. I then created category option group set containing the
>>> option group. In the option group and in the option group set, I selected
>>> data dimension and data dimension type Disaggregation.
>>>
>>> On visualizer app, i selected the indicators, the applicable period and
>>> location, this gives me data. But when i applied the dimensions of the
>>> category option group set, no error is displayed but no data to display. I
>>> have attache the final chart and my layout arrangements.
>>>
>>> By my understanding, this is expected since there was no connection
>>> between the indicators and category option group set. The question is have
>>> I set things up correctly? if not what did i miss or do wrongly pls?
>>>
>>> Thanks.
>>>
>>>
>>> On Thu, Jul 26, 2018 at 9:14 AM Jason Pickering <
>>> jason.p.pickering@xxxxxxxxx> wrote:
>>>
>>>> Hi Peter,
>>>>
>>>> I may need to clarify my comment a bit. It will work with category
>>>> option group sets, *but not categories*. That seems like the feature
>>>> which is not supported.
>>>>
>>>> Try and create a category option group set which mirrors the category,
>>>> and which is also a dimension It should work after rebuilding analytics.
>>>>
>>>> See below for a trivial example from the PEPFAR system, which seems
>>>> quite similar to what you are looking at.
>>>>
>>>> [image: Selection_999(567).png]
>>>> ​
>>>>
>>>> In  this case, HTS_TST is defined from data elements which have
>>>> positive and negative category options as part of a category. How
>>>> ever a category option group set is used (instead of the category).
>>>>
>>>> Regards,
>>>> Jason
>>>>
>>>>
>>>> On Jul 26, 2018 10:06, "Peter D Lubambi" <plubambi@xxxxxxxxx> wrote:
>>>>
>>>> Hi Jason,
>>>> Thanks for this info, which version works? Or you mean it will work in
>>>> the coming versions?
>>>> I am currently using ver 2.29, and gives me conflict error - or i am
>>>> missing something on defining the indicator?
>>>> [image: image.png]
>>>>
>>>> Regards,
>>>> Peter Dotto Lubambi,
>>>> Skype: plubambi
>>>> Mobile: +255 786 087 087
>>>>
>>>>
>>>> On Thu, Jul 26, 2018 at 10:42 AM Jason Pickering <
>>>> jason.p.pickering@xxxxxxxxx> wrote:
>>>>
>>>>> Hi Peter and Olaleke,
>>>>>
>>>>> While this feature is not documented anywhere, it will work for
>>>>> indicators. Any applicable dimension (including categories and category
>>>>> option group sets) can be used with indicators in the pivots, when the
>>>>> indicator contains one of those dimensions.
>>>>>
>>>>> Not exactly sure how this would work with validation rules, but would
>>>>> be it would be good to hear your use case for this.
>>>>>
>>>>> Regards,
>>>>> Jason
>>>>>
>>>>>
>>>>>
>>>>> On Thu, Jul 26, 2018 at 9:33 AM Peter D Lubambi <plubambi@xxxxxxxxx>
>>>>> wrote:
>>>>>
>>>>>> Hi Seweje,
>>>>>> I think this is currently not supported, but it a feature that I have
>>>>>> been looking (probably week we need to vote for it in Jira).  Also, similar
>>>>>> thing with validation rules - Once you have created a validation rule for
>>>>>> the total data element to make it apply to their category options (for data
>>>>>> elements with the same category options).
>>>>>> Regards,
>>>>>>
>>>>>> Peter Dotto Lubambi,
>>>>>> Skype: plubambi
>>>>>> Mobile: +255 786 087 087
>>>>>>
>>>>>>
>>>>>> On Tue, Jul 24, 2018 at 6:16 PM Olaleke Seweje <
>>>>>> sewejeolaleke@xxxxxxxxx> wrote:
>>>>>>
>>>>>>> Hi all,
>>>>>>> Is there a way I can disaggregate indicators to get the chart below?
>>>>>>> So e.g. for an indicator called Implants Jadelle, there are 4
>>>>>>> classes namely In stock, stock out, Providing unknown, do not provide. The
>>>>>>> classes are shown as different colours on the each bar.
>>>>>>>
>>>>>>> For data elements, this is easily done as category options but is
>>>>>>> there a way to do something similar for indicators?
>>>>>>>
>>>>>>> Thanks.
>>>>>>>
>>>>>>> [image: indicators.jpg]
>>>>>>>
>>>>>>>
>>>>>>> --
>>>>>>> Regards,
>>>>>>> Leke Seweje
>>>>>>> _______________________________________________
>>>>>>> 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
>>>>>>>
>>>>>>
>>>>>
>>>>> --
>>>>> Jason P. Pickering
>>>>> email: jason.p.pickering@xxxxxxxxx
>>>>> tel:+46764147049
>>>>>
>>>>
>>>>
>>>
>>> --
>>> Regards,
>>> Leke Seweje
>>>
>>
>>
>> --
>> Jason P. Pickering
>> email: jason.p.pickering@xxxxxxxxx
>> tel:+46764147049
>>
>
>
> --
> Regards,
> Leke Seweje
>


-- 
Regards,
Leke Seweje

Attachment: Screen Shot 2018-07-26 at 11.31.05 AM.png
Description: PNG image

Attachment: Screen Shot 2018-07-26 at 11.31.23 AM.png
Description: PNG image


Follow ups

References