dhis2-devs team mailing list archive

[Jason Pickering <jason.p.pickering@xxxxxxxxx>]

Hi there.

I was able to create a reproducible example on the play server. If you look
quickly, you should be able to see  this favorite.

https://play.dhis2.org/2.30/dhis-web-pivot/?id=YNj2tzobrnB

which looks like this:
[image: image.png]

Here were the steps:

I defined an indicator for number of data elements:
Numerator: ART enrollment stage 1 + ART enrollment stage 2 + ART enrollment
stage 3 + ART enrollment stage 4
Denominator : 1
Indicator type: Number

2) Create a pivot with this indicator and add the "Implementing Partner"
category option groups.

You can also use the "Funding agency" groups as well.

I am 100% this feature works, as it is used quite frequently in the PEPFAR
instance of DHIS2.

I suspect something is not configured properly with  your category option
group set.

Give a try however on play.dhis2.org and it should work!

Best regards,
Jason



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

> 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
>


-- 
Jason P. Pickering
email: jason.p.pickering@xxxxxxxxx
tel:+46764147049