DATA ELEMENTS NOT SHOWING DATA IN PIVOT TABLES

Hi All,

I posted something similar sometime two weeks ago.

I have data elements whose value type is number and aggregation type is Sum.I created a data set and assigned it to the Organisation unit.

I captured data and run analytics.When i run the pivot tables,no data values.

However,when i add a Category Combination which is an attribute to the data set,enter data and run pivot tables,data is there.

I am confused.

Anyone with an idea?

Thank you

Stanley,

Please run analytics and check your pivot tables again.

···

On Tue, Feb 6, 2018 at 11:11 AM, Stanley Kalyati skalyati@gmail.com wrote:

Hi All,

I posted something similar sometime two weeks ago.

I have data elements whose value type is number and aggregation type is Sum.I created a data set and assigned it to the Organisation unit.

I captured data and run analytics.When i run the pivot tables,no data values.

However,when i add a Category Combination which is an attribute to the data set,enter data and run pivot tables,data is there.

I am confused.

Anyone with an idea?

Thank you


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

Regards,

Gerald

Hi Gerald,

I have run analytics,i have also gone to data admin and also cleared catch but no results.

Only when i add a category combination to the data set,that is when i am able to see data when i run pivot or data visualizer.

I cant understand

···

On Tue, Feb 6, 2018 at 1:40 PM, gerald thomas gerald17006@gmail.com wrote:

Stanley,

Please run analytics and check your pivot tables again.

On Tue, Feb 6, 2018 at 11:11 AM, Stanley Kalyati skalyati@gmail.com wrote:

Hi All,

I posted something similar sometime two weeks ago.

I have data elements whose value type is number and aggregation type is Sum.I created a data set and assigned it to the Organisation unit.

I captured data and run analytics.When i run the pivot tables,no data values.

However,when i add a Category Combination which is an attribute to the data set,enter data and run pivot tables,data is there.

I am confused.

Anyone with an idea?

Thank you


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

Regards,

Gerald

Stanley,

It simply means your data is based on those category combinations that is why you are seeing them. Please share a print screen of that data set whose data elements you pivoting for now.

···

On Tue, Feb 6, 2018 at 12:33 PM, Stanley Kalyati skalyati@gmail.com wrote:

Hi Gerald,

I have run analytics,i have also gone to data admin and also cleared catch but no results.

Only when i add a category combination to the data set,that is when i am able to see data when i run pivot or data visualizer.

I cant understand

On Tue, Feb 6, 2018 at 1:40 PM, gerald thomas gerald17006@gmail.com wrote:

Stanley,

Please run analytics and check your pivot tables again.

On Tue, Feb 6, 2018 at 11:11 AM, Stanley Kalyati skalyati@gmail.com wrote:

Hi All,

I posted something similar sometime two weeks ago.

I have data elements whose value type is number and aggregation type is Sum.I created a data set and assigned it to the Organisation unit.

I captured data and run analytics.When i run the pivot tables,no data values.

However,when i add a Category Combination which is an attribute to the data set,enter data and run pivot tables,data is there.

I am confused.

Anyone with an idea?

Thank you


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

Regards,

Gerald

Regards,

Gerald

Hi, Gerald and Stanley.

I have the same issue, data can not be aggregated. Tried everything (regenerate reporting, clear cache).

I’ve tried it on the official demo server (https://play.dhis2.org/2.27/). Version 2.26 works as expected, but not 2.27 and 2.28.

Here are steps to reproduce: https://docs.google.com/document/d/1mRjfBvVfwqjxz9c0JotRIlQMJK4wV5V7qf6wEkskkrc/edit

Will be appreciated for any help

···

On Tue, Feb 6, 2018 at 12:33 PM, Stanley Kalyati skalyati@gmail.com wrote:

Hi Gerald,

I have run analytics,i have also gone to data admin and also cleared catch but no results.

Only when i add a category combination to the data set,that is when i am able to see data when i run pivot or data visualizer.

I cant understand

On Tue, Feb 6, 2018 at 1:40 PM, gerald thomas gerald17006@gmail.com wrote:

Stanley,

Please run analytics and check your pivot tables again.

On Tue, Feb 6, 2018 at 11:11 AM, Stanley Kalyati skalyati@gmail.com wrote:

Hi All,

I posted something similar sometime two weeks ago.

I have data elements whose value type is number and aggregation type is Sum.I created a data set and assigned it to the Organisation unit.

I captured data and run analytics.When i run the pivot tables,no data values.

However,when i add a Category Combination which is an attribute to the data set,enter data and run pivot tables,data is there.

I am confused.

Anyone with an idea?

Thank you


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

Regards,

Gerald

Regards,

Gerald

Hi Andrey,

Please report this in JIRA: http://jira.dhis2.org/

Thanks,
Knut

···

On 2/8/18, Andrey Kolpakov <aakolpakov@gmail.com> wrote:

Hi, Gerald and Stanley.

I have the same issue, data can not be aggregated. Tried everything
(regenerate reporting, clear cache).

I've tried it on the official demo server (https://play.dhis2.org/2.27/).
Version 2.26 works as expected, but not 2.27 and 2.28.
Here are steps to reproduce:
https://docs.google.com/document/d/1mRjfBvVfwqjxz9c0JotRIlQMJK4wV5V7qf6wEkskkrc/edit
<https://docs.google.com/document/d/1mRjfBvVfwqjxz9c0JotRIlQMJK4wV5V7qf6wEkskkrc/edit>

Will be appreciated for any help

On 6 Feb 2018, at 13:47, gerald thomas <gerald17006@gmail.com> wrote:

Stanley,
It simply means your data is based on those category combinations that is
why you are seeing them. Please share a print screen of that data set
whose data elements you pivoting for now.

On Tue, Feb 6, 2018 at 12:33 PM, Stanley Kalyati <skalyati@gmail.com >> <mailto:skalyati@gmail.com>> wrote:
Hi Gerald,

I have run analytics,i have also gone to data admin and also cleared catch
but no results.

Only when i add a category combination to the data set,that is when i am
able to see data when i run pivot or data visualizer.

I cant understand

On Tue, Feb 6, 2018 at 1:40 PM, gerald thomas <gerald17006@gmail.com >> <mailto:gerald17006@gmail.com>> wrote:
Stanley,
Please run analytics and check your pivot tables again.

On Tue, Feb 6, 2018 at 11:11 AM, Stanley Kalyati <skalyati@gmail.com >> <mailto:skalyati@gmail.com>> wrote:
Hi All,

I posted something similar sometime two weeks ago.

I have data elements whose value type is number and aggregation type is
Sum.I created a data set and assigned it to the Organisation unit.

I captured data and run analytics.When i run the pivot tables,no data
values.

However,when i add a Category Combination which is an attribute to the
data set,enter data and run pivot tables,data is there.

I am confused.

Anyone with an idea?

Thank you

_______________________________________________
Mailing list: https://launchpad.net/~dhis2-users
<https://launchpad.net/~dhis2-users>
Post to : dhis2-users@lists.launchpad.net
<mailto:dhis2-users@lists.launchpad.net>
Unsubscribe : https://launchpad.net/~dhis2-users
<https://launchpad.net/~dhis2-users>
More help : https://help.launchpad.net/ListHelp
<https://help.launchpad.net/ListHelp>

--
Regards,

Gerald

--
Regards,

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

--
Knut Staring

Department of Information, Evidence and Research
World Health Organization, Geneva, Switzerland
Office: +41 22 791 3683 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
Skype: knutstar

Hi Stanley and Dear dhis2 community.

I have been in the same situation and its now two days while still trying to figure out why some of my data elements are not showing values in the pivot table.

Maybe my set up is different. I have data elements assigned into a data set with category combination. My data elements are using the default category combo -after I was unable to assign categories combo to the data elements.

I posted some data into the data elements while following the section on: sending datavalues in the dhis2 developers guide. My API client returns a status code: 200, meaning that data was successfully sent.

So when I run analytics, there are only few data elements displaying data on the pivot table. I have tried to rerun the analytics and cleared cache several times, there is no change.

Maybe this is an issue with dhis2 version 2.28? I do understand.

I need help.

Thank you.

···

On Feb 6, 2018 14:12, “Stanley Kalyati” skalyati@gmail.com wrote:

Hi All,

I posted something similar sometime two weeks ago.

I have data elements whose value type is number and aggregation type is Sum.I created a data set and assigned it to the Organisation unit.

I captured data and run analytics.When i run the pivot tables,no data values.

However,when i add a Category Combination which is an attribute to the data set,enter data and run pivot tables,data is there.

I am confused.

Anyone with an idea?

Thank you


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

Dear Isaiah,

I am sure this is a bug. Knut had already asked Stanley to a ticket of this issue on http://jira.dhis2.org/ We will continue to do follow up on this issue there.

···

On Thu, Feb 8, 2018 at 6:36 PM, Isaiah Nyabuto isaiahnyabuto@gmail.com wrote:

Hi Stanley and Dear dhis2 community.

I have been in the same situation and its now two days while still trying to figure out why some of my data elements are not showing values in the pivot table.

Maybe my set up is different. I have data elements assigned into a data set with category combination. My data elements are using the default category combo -after I was unable to assign categories combo to the data elements.

I posted some data into the data elements while following the section on: sending datavalues in the dhis2 developers guide. My API client returns a status code: 200, meaning that data was successfully sent.

So when I run analytics, there are only few data elements displaying data on the pivot table. I have tried to rerun the analytics and cleared cache several times, there is no change.

Maybe this is an issue with dhis2 version 2.28? I do understand.

I need help.

Thank you.

==========================
Isaiah Nyabuto
+254729572616
Bsc. Health Records Management and Informatics


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

On Feb 6, 2018 14:12, “Stanley Kalyati” skalyati@gmail.com wrote:

Hi All,

I posted something similar sometime two weeks ago.

I have data elements whose value type is number and aggregation type is Sum.I created a data set and assigned it to the Organisation unit.

I captured data and run analytics.When i run the pivot tables,no data values.

However,when i add a Category Combination which is an attribute to the data set,enter data and run pivot tables,data is there.

I am confused.

Anyone with an idea?

Thank you


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

Regards,

Gerald

1 Like