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?
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,
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.
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.
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).
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,
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?
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,
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?
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,
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?
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?
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,
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?
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
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!
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,
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?