Attributes fixed to Filter in the Events Report

Support - Assistance technique
1

Hi Team,

Thanks for adding attributes into the program stages in the event reports, however all attributes are fixed to filter when line listing data.

Line listing all data elements alongside the attributes helps in data cleaning and exporting for further analysis.

Was this intended or its a bug?

I have tested this on the demo server

Version:
2.16
Build revision:
Build date:
2014-09-04 02:04

Regards

···

–
Prosper Behumbiize, MPH
Phone: +256 414 320076
Cell: +256 772 139037
+256 752 751776

2

Sorry ignore this,

Had not realized I was running aggregates instead of individual records

Apologies

···

On Thu, Sep 4, 2014 at 6:35 PM, Prosper BT ptb3000@gmail.com wrote:

Hi Team,

Thanks for adding attributes into the program stages in the event reports, however all attributes are fixed to filter when line listing data.

Line listing all data elements alongside the attributes helps in data cleaning and exporting for further analysis.

Was this intended or its a bug?

I have tested this on the demo server

Version:
2.16
Build revision:
Build date:
2014-09-04 02:04

Prosper Behumbiize, MPH
Phone: +256 414 320076
Cell: +256 772 139037
+256 752 751776

Regards

–
Prosper Behumbiize, MPH
Phone: +256 414 320076
Cell: +256 772 139037
+256 752 751776

3

Yes, you are right.

Text attributes and data elements will explode the pivot table - that’s why we don’t allow them to be dimensions (columns/rows) in the aggregated mode.

···

On Thu, Sep 4, 2014 at 5:37 PM, Prosper BT ptb3000@gmail.com wrote:

Sorry ignore this,

Had not realized I was running aggregates instead of individual records

Apologies

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 Thu, Sep 4, 2014 at 6:35 PM, Prosper BT ptb3000@gmail.com wrote:

Hi Team,

Thanks for adding attributes into the program stages in the event reports, however all attributes are fixed to filter when line listing data.

Line listing all data elements alongside the attributes helps in data cleaning and exporting for further analysis.

Was this intended or its a bug?

I have tested this on the demo server

Version:
2.16
Build revision:
Build date:
2014-09-04 02:04

Prosper Behumbiize, MPH
Phone: +256 414 320076
Cell: +256 772 139037
+256 752 751776

Regards

–
Prosper Behumbiize, MPH
Phone: +256 414 320076
Cell: +256 772 139037
+256 752 751776

4

Thanks Jan,

Understood.

But for aggregate we are missing the description of what is being aggregated. i.e, If you pick a data element like ANC visit number with Options 1, 2, 3, 4, 4+ you will only see the option with the respective numbers, this works if you are working with one data element but gets messed up with more than one data element.

Regards

···

On Thu, Sep 4, 2014 at 6:49 PM, Jan Henrik Øverland janhenrik.overland@gmail.com wrote:

Yes, you are right.

Text attributes and data elements will explode the pivot table - that’s why we don’t allow them to be dimensions (columns/rows) in the aggregated mode.

–
Prosper Behumbiize, MPH
Phone: +256 414 320076
Cell: +256 772 139037
+256 752 751776

On Thu, Sep 4, 2014 at 5:37 PM, Prosper BT ptb3000@gmail.com wrote:

Sorry ignore this,

Had not realized I was running aggregates instead of individual records

Apologies

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 Thu, Sep 4, 2014 at 6:35 PM, Prosper BT ptb3000@gmail.com wrote:

Hi Team,

Thanks for adding attributes into the program stages in the event reports, however all attributes are fixed to filter when line listing data.

Line listing all data elements alongside the attributes helps in data cleaning and exporting for further analysis.

Was this intended or its a bug?

I have tested this on the demo server

Version:
2.16
Build revision:
Build date:
2014-09-04 02:04

Prosper Behumbiize, MPH
Phone: +256 414 320076
Cell: +256 772 139037
+256 752 751776

Regards

–
Prosper Behumbiize, MPH
Phone: +256 414 320076
Cell: +256 772 139037
+256 752 751776

5

If you select a numeric data element, like “Age”, you will see “Age 1”, “Age 2”, “Age 3” etc in the table.

This is not the case for options as you make the option names yourself.

···

On Thu, Sep 4, 2014 at 5:58 PM, Prosper BT ptb3000@gmail.com wrote:

Thanks Jan,

Understood.

But for aggregate we are missing the description of what is being aggregated. i.e, If you pick a data element like ANC visit number with Options 1, 2, 3, 4, 4+ you will only see the option with the respective numbers, this works if you are working with one data element but gets messed up with more than one data element.

Regards

On Thu, Sep 4, 2014 at 6:49 PM, Jan Henrik Øverland janhenrik.overland@gmail.com wrote:

Yes, you are right.

Text attributes and data elements will explode the pivot table - that’s why we don’t allow them to be dimensions (columns/rows) in the aggregated mode.

–
Prosper Behumbiize, MPH
Phone: +256 414 320076
Cell: +256 772 139037
+256 752 751776

On Thu, Sep 4, 2014 at 5:37 PM, Prosper BT ptb3000@gmail.com wrote:

Sorry ignore this,

Had not realized I was running aggregates instead of individual records

Apologies

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 Thu, Sep 4, 2014 at 6:35 PM, Prosper BT ptb3000@gmail.com wrote:

Hi Team,

Thanks for adding attributes into the program stages in the event reports, however all attributes are fixed to filter when line listing data.

Line listing all data elements alongside the attributes helps in data cleaning and exporting for further analysis.

Was this intended or its a bug?

I have tested this on the demo server

Version:
2.16
Build revision:
Build date:
2014-09-04 02:04

Prosper Behumbiize, MPH
Phone: +256 414 320076
Cell: +256 772 139037
+256 752 751776

Regards

–
Prosper Behumbiize, MPH
Phone: +256 414 320076
Cell: +256 772 139037
+256 752 751776

6

So data element labels only display with numeric data elements, I think it should also for text with options

See the attached example

No data element labels.pdf (127 KB)

···

On Thu, Sep 4, 2014 at 7:15 PM, Jan Henrik Øverland janhenrik.overland@gmail.com wrote:

If you select a numeric data element, like “Age”, you will see “Age 1”, “Age 2”, “Age 3” etc in the table.

This is not the case for options as you make the option names yourself.

–
Prosper Behumbiize, MPH
Phone: +256 414 320076
Cell: +256 772 139037
+256 752 751776

On Thu, Sep 4, 2014 at 5:58 PM, Prosper BT ptb3000@gmail.com wrote:

Thanks Jan,

Understood.

But for aggregate we are missing the description of what is being aggregated. i.e, If you pick a data element like ANC visit number with Options 1, 2, 3, 4, 4+ you will only see the option with the respective numbers, this works if you are working with one data element but gets messed up with more than one data element.

Regards

On Thu, Sep 4, 2014 at 6:49 PM, Jan Henrik Øverland janhenrik.overland@gmail.com wrote:

Yes, you are right.

Text attributes and data elements will explode the pivot table - that’s why we don’t allow them to be dimensions (columns/rows) in the aggregated mode.

–
Prosper Behumbiize, MPH
Phone: +256 414 320076
Cell: +256 772 139037
+256 752 751776

On Thu, Sep 4, 2014 at 5:37 PM, Prosper BT ptb3000@gmail.com wrote:

Sorry ignore this,

Had not realized I was running aggregates instead of individual records

Apologies

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 Thu, Sep 4, 2014 at 6:35 PM, Prosper BT ptb3000@gmail.com wrote:

Hi Team,

Thanks for adding attributes into the program stages in the event reports, however all attributes are fixed to filter when line listing data.

Line listing all data elements alongside the attributes helps in data cleaning and exporting for further analysis.

Was this intended or its a bug?

I have tested this on the demo server

Version:
2.16
Build revision:
Build date:
2014-09-04 02:04

Prosper Behumbiize, MPH
Phone: +256 414 320076
Cell: +256 772 139037
+256 752 751776

Regards

–
Prosper Behumbiize, MPH
Phone: +256 414 320076
Cell: +256 772 139037
+256 752 751776

7

Hi,

in trunk there is now an option called “Show dimension labels” in pivot table and event reports.

Jan

···

On Thu, Sep 4, 2014 at 6:27 PM, Prosper BT ptb3000@gmail.com wrote:

So data element labels only display with numeric data elements, I think it should also for text with options

See the attached example

On Thu, Sep 4, 2014 at 7:15 PM, Jan Henrik Øverland janhenrik.overland@gmail.com wrote:

If you select a numeric data element, like “Age”, you will see “Age 1”, “Age 2”, “Age 3” etc in the table.

This is not the case for options as you make the option names yourself.

–
Prosper Behumbiize, MPH
Phone: +256 414 320076
Cell: +256 772 139037
+256 752 751776

On Thu, Sep 4, 2014 at 5:58 PM, Prosper BT ptb3000@gmail.com wrote:

Thanks Jan,

Understood.

But for aggregate we are missing the description of what is being aggregated. i.e, If you pick a data element like ANC visit number with Options 1, 2, 3, 4, 4+ you will only see the option with the respective numbers, this works if you are working with one data element but gets messed up with more than one data element.

Regards

On Thu, Sep 4, 2014 at 6:49 PM, Jan Henrik Øverland janhenrik.overland@gmail.com wrote:

Yes, you are right.

Text attributes and data elements will explode the pivot table - that’s why we don’t allow them to be dimensions (columns/rows) in the aggregated mode.

–
Prosper Behumbiize, MPH
Phone: +256 414 320076
Cell: +256 772 139037
+256 752 751776

On Thu, Sep 4, 2014 at 5:37 PM, Prosper BT ptb3000@gmail.com wrote:

Sorry ignore this,

Had not realized I was running aggregates instead of individual records

Apologies

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 Thu, Sep 4, 2014 at 6:35 PM, Prosper BT ptb3000@gmail.com wrote:

Hi Team,

Thanks for adding attributes into the program stages in the event reports, however all attributes are fixed to filter when line listing data.

Line listing all data elements alongside the attributes helps in data cleaning and exporting for further analysis.

Was this intended or its a bug?

I have tested this on the demo server

Version:
2.16
Build revision:
Build date:
2014-09-04 02:04

Prosper Behumbiize, MPH
Phone: +256 414 320076
Cell: +256 772 139037
+256 752 751776

Regards

–
Prosper Behumbiize, MPH
Phone: +256 414 320076
Cell: +256 772 139037
+256 752 751776