How to apply disaggregation to indicators

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

···

Regards,

Leke Seweje

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,

image

···

Peter Dotto Lubambi,

Skype: plubambi
Mobile: +255 786 087 087

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

image

···

Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

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

Regards,

image

···

Peter Dotto Lubambi,

Skype: plubambi
Mobile: +255 786 087 087

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

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

image

image

···

On Jul 26, 2018 10:06, “Peter D Lubambi” plubambi@gmail.com 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.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@gmail.com 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@gmail.com 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@gmail.com 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.

indicators.jpg


Regards,

Leke Seweje


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp


Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

Did you do a full refresh of analytics after creating the group set and before using the data visualizer?

Regards,

Jason

···

On Jul 26, 2018 10:06, “Peter D Lubambi” plubambi@gmail.com 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.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@gmail.com 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@gmail.com 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@gmail.com 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.

indicators.jpg


Regards,

Leke Seweje


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp


Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

Yes, I believe. I went to reports->analytics and exported.
Is that what you mean by refresh?

···

On Jul 26, 2018 10:06, “Peter D Lubambi” plubambi@gmail.com 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.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@gmail.com 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@gmail.com 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@gmail.com 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.

indicators.jpg


Regards,

Leke Seweje


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp


Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

Regards,

Leke Seweje

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?

image

image

···

On Jul 26, 2018 10:06, “Peter D Lubambi” plubambi@gmail.com 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.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@gmail.com 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@gmail.com 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@gmail.com 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.

indicators.jpg


Regards,

Leke Seweje


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp


Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

Regards,

Leke Seweje

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

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

  1. 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 Jul 26, 2018 10:06, “Peter D Lubambi” plubambi@gmail.com 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.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@gmail.com 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@gmail.com 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@gmail.com 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.

indicators.jpg


Regards,

Leke Seweje


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp


Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049