Unable to filter data on Data Visualizer using Organization Unit Group Set filter

Hello,

We were trying to filter data on Data Visualizer using Organization Unit Group Set filter. We are unable to get the expected result. Instead, we get an error saying : No Values Found.

PFA, the screenshot for the same.

Here Population is an Organization Unit Group Set having two Organization Unit Groups RP and GP.

The bar shows the combined value for all org units associated to both RP and GP.

Can you please help us understand what is the problem. Is it some bug or are we missing something?

···

Thanks,

Mansi Singhal

Hi Mansi,

which version are you running? If it is 2.16+, are you able to reproduce your issue in one of our demos?

https://apps.dhis2.org/demo (2.16)

https://apps.dhis2.org/dev (trunk)

···

On Tue, Nov 4, 2014 at 2:07 PM, Mansi Singhal msinghal@thoughtworks.com wrote:

Hello,

We were trying to filter data on Data Visualizer using Organization Unit Group Set filter. We are unable to get the expected result. Instead, we get an error saying : No Values Found.

PFA, the screenshot for the same.

Here Population is an Organization Unit Group Set having two Organization Unit Groups RP and GP.

The bar shows the combined value for all org units associated to both RP and GP.

Can you please help us understand what is the problem. Is it some bug or are we missing something?

Thanks,

Mansi Singhal


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

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

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

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

Hello Jan,

We are on trunk( Version 17355). We are not able to filter data on Data Visualizer based on Organization Unit Group Set in the demo app(https://apps.dhis2.org/dev ) as well.

We are getting different error though, that says: Indicators cannot be specified as filter.

Don’t know if we are missing something.

Also, I am unable to see “Analytics and Data Mart” under Reports.

Just for your reference, what I did is:

Data was already present for Badija And Baoma under Bo. I was able to see charts for them in Data Visualizer. I created new Organization Unit Group Set called MyGroupSet in demo app. This has two Organization Unit Groups, Group1(associated with Badija) and Group 2(associated with Baoma). When i am trying to filter charts based on Organization Unit Group Set Filter, I am getting the error as said.

Can you help us figuring out what is wrong?

···

On Tue, Nov 4, 2014 at 6:59 PM, Dan Cocos dcocos@gmail.com wrote:

Hi Mansi,

Have you generated the Analytics?

Dan Cocos
BAO Systemswww.baosystems.com

T: +1 202-352-2671 | skype: dancocos

On Nov 4, 2014, at 8:26 AM, Jan Henrik Øverland janhenrik.overland@gmail.com wrote:

Hi Mansi,

which version are you running? If it is 2.16+, are you able to reproduce your issue in one of our demos?

https://apps.dhis2.org/demo (2.16)

https://apps.dhis2.org/dev (trunk)


Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp

On Tue, Nov 4, 2014 at 2:07 PM, Mansi Singhal msinghal@thoughtworks.com wrote:

Hello,

We were trying to filter data on Data Visualizer using Organization Unit Group Set filter. We are unable to get the expected result. Instead, we get an error saying : No Values Found.

PFA, the screenshot for the same.

Here Population is an Organization Unit Group Set having two Organization Unit Groups RP and GP.

The bar shows the combined value for all org units associated to both RP and GP.

Can you please help us understand what is the problem. Is it some bug or are we missing something?

Thanks,

Mansi Singhal


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

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

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

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

Regards,

Mansi Singhal

+91 9900246052

Hey Dan,

We generated the Analytics. It seems this is some other problem.

···

On Wed, Nov 5, 2014 at 10:28 AM, Mansi Singhal msinghal@thoughtworks.com wrote:

Hello Jan,

We are on trunk( Version 17355). We are not able to filter data on Data Visualizer based on Organization Unit Group Set in the demo app(https://apps.dhis2.org/dev ) as well.

We are getting different error though, that says: Indicators cannot be specified as filter.

Don’t know if we are missing something.

Also, I am unable to see “Analytics and Data Mart” under Reports.

Just for your reference, what I did is:

Data was already present for Badija And Baoma under Bo. I was able to see charts for them in Data Visualizer. I created new Organization Unit Group Set called MyGroupSet in demo app. This has two Organization Unit Groups, Group1(associated with Badija) and Group 2(associated with Baoma). When i am trying to filter charts based on Organization Unit Group Set Filter, I am getting the error as said.

Can you help us figuring out what is wrong?

On Tue, Nov 4, 2014 at 6:59 PM, Dan Cocos dcocos@gmail.com wrote:

Hi Mansi,

Have you generated the Analytics?

Dan Cocos
BAO Systemswww.baosystems.com

T: +1 202-352-2671 | skype: dancocos

On Nov 4, 2014, at 8:26 AM, Jan Henrik Øverland janhenrik.overland@gmail.com wrote:

Hi Mansi,

which version are you running? If it is 2.16+, are you able to reproduce your issue in one of our demos?

https://apps.dhis2.org/demo (2.16)

https://apps.dhis2.org/dev (trunk)


Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp

Regards,

Mansi Singhal

+91 9900246052

On Tue, Nov 4, 2014 at 2:07 PM, Mansi Singhal msinghal@thoughtworks.com wrote:

Hello,

We were trying to filter data on Data Visualizer using Organization Unit Group Set filter. We are unable to get the expected result. Instead, we get an error saying : No Values Found.

PFA, the screenshot for the same.

Here Population is an Organization Unit Group Set having two Organization Unit Groups RP and GP.

The bar shows the combined value for all org units associated to both RP and GP.

Can you please help us understand what is the problem. Is it some bug or are we missing something?

Thanks,

Mansi Singhal


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

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

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

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

Regards,

Mansi Singhal

+91 9900246052

Hi Mansi,

based on the information you provide I guess this is what happened:

  1. In your instance you ran the analytics and then created the org unit group set? When you create a new org unit group set with “Data Dimension” set to true (which means it will show up in the analysis apps), you need to run analytics again.

  2. At this point you will have values for the new group set and filtering on it should work well. However it seems that you (at least in the demo) selected an indicator and put it as filter as well. Unfortunately we do not yet support having indicators as filter, so you need to open the layout window and move the “Data” item to either columns or rows.

Please let me know if this helps.

Jan

···

On Wed, Nov 5, 2014 at 5:59 AM, Mansi Singhal msinghal@thoughtworks.com wrote:

Hey Dan,

We generated the Analytics. It seems this is some other problem.

On Wed, Nov 5, 2014 at 10:28 AM, Mansi Singhal msinghal@thoughtworks.com wrote:

Hello Jan,

We are on trunk( Version 17355). We are not able to filter data on Data Visualizer based on Organization Unit Group Set in the demo app(https://apps.dhis2.org/dev ) as well.

We are getting different error though, that says: Indicators cannot be specified as filter.

Don’t know if we are missing something.

Also, I am unable to see “Analytics and Data Mart” under Reports.

Just for your reference, what I did is:

Data was already present for Badija And Baoma under Bo. I was able to see charts for them in Data Visualizer. I created new Organization Unit Group Set called MyGroupSet in demo app. This has two Organization Unit Groups, Group1(associated with Badija) and Group 2(associated with Baoma). When i am trying to filter charts based on Organization Unit Group Set Filter, I am getting the error as said.

Can you help us figuring out what is wrong?


Regards,

Mansi Singhal

+91 9900246052

On Tue, Nov 4, 2014 at 6:59 PM, Dan Cocos dcocos@gmail.com wrote:

Hi Mansi,

Have you generated the Analytics?

Dan Cocos
BAO Systemswww.baosystems.com

T: +1 202-352-2671 | skype: dancocos

On Nov 4, 2014, at 8:26 AM, Jan Henrik Øverland janhenrik.overland@gmail.com wrote:

Hi Mansi,

which version are you running? If it is 2.16+, are you able to reproduce your issue in one of our demos?

https://apps.dhis2.org/demo (2.16)

https://apps.dhis2.org/dev (trunk)


Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp

Regards,

Mansi Singhal

+91 9900246052

On Tue, Nov 4, 2014 at 2:07 PM, Mansi Singhal msinghal@thoughtworks.com wrote:

Hello,

We were trying to filter data on Data Visualizer using Organization Unit Group Set filter. We are unable to get the expected result. Instead, we get an error saying : No Values Found.

PFA, the screenshot for the same.

Here Population is an Organization Unit Group Set having two Organization Unit Groups RP and GP.

The bar shows the combined value for all org units associated to both RP and GP.

Can you please help us understand what is the problem. Is it some bug or are we missing something?

Thanks,

Mansi Singhal


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

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

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

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

I think this problem was caused by the org unit groups containing the
higher-level org units (e.g. districts) instead of the organisation units
that collects the data (e.g. the facilities).

The group set / org unit group analysis is reads data for the org units
which are explicit members of groups - not children of group members.

Lars

Hi Lars,
That was the issue. It is fixed now.

···

On 25 December 2014 at 21:10, Lars Helge Øverland larshelge@gmail.com wrote:

ThanksShashank RaghavendraQuality Analyst
Skype shashank.raghavendra

Telephone
+91 9632802392

ThoughtWorks

I think this problem was caused by the org unit groups containing the higher-level org units (e.g. districts) instead of the organisation units that collects the data (e.g. the facilities).

The group set / org unit group analysis is reads data for the org units which are explicit members of groups - not children of group members.

Lars