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 <sewejeolal...@gmail.com> 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 <sewejeolal...@gmail.com> > 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.picker...@gmail.com> 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 <sewejeolal...@gmail.com> >>> 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.picker...@gmail.com> 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" <pluba...@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: 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.picker...@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 <pluba...@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 < >>>>>>> sewejeolal...@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. >>>>>>>> >>>>>>>> [image: 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.picker...@gmail.com >>>>>> tel:+46764147049 >>>>>> >>>>> >>>>> >>>> >>>> -- >>>> Regards, >>>> Leke Seweje >>>> >>> >>> >>> -- >>> Jason P. Pickering >>> email: jason.p.picker...@gmail.com >>> tel:+46764147049 >>> >> >> >> -- >> Regards, >> Leke Seweje >> > > > -- > Regards, > Leke Seweje > -- Jason P. Pickering email: jason.p.picker...@gmail.com tel:+46764147049
_______________________________________________ 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
