indicators

Support - Assistance technique
1

Hello,

If I may ask about indicators

How can I count data element that has no null values?

Can I do that; can I use functions like count or other?

Kindly note that I am not talking about program indicators , I am talking about normal indicators

Thanks in advance

2

Hi Nami,

I suggest you write an SQL query through data administration > sql view to achieve this.

Docs: https://www.dhis2.org/doc/snapshot/en/developer/html/ch01s25.html

regards,

Lars

···

On Thu, Dec 17, 2015 at 1:18 PM, Nami Ghadri nami_ghadri@hotmail.com wrote:

Hello,

If I may ask about indicators

How can I count data element that has no null values?

Can I do that; can I use functions like count or other?

Kindly note that I am not talking about program indicators , I am talking about normal indicators

Thanks in advance

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

–

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org

3

Thanks very much I will try it

Regards,

···

From: Lars Helge Øverland [mailto:larshelge@gmail.com]
Sent: Thursday, December 17, 2015 3:08 PM
To: Nami Ghadri nami_ghadri@hotmail.com
Cc: DHIS 2 Users list dhis2-users@lists.launchpad.net
Subject: Re: [Dhis2-users] indicators

Hi Nami,

I suggest you write an SQL query through data administration > sql view to achieve this.

Docs: https://www.dhis2.org/doc/snapshot/en/developer/html/ch01s25.html

regards,

Lars

On Thu, Dec 17, 2015 at 1:18 PM, Nami Ghadri nami_ghadri@hotmail.com wrote:

Hello,

If I may ask about indicators

How can I count data element that has no null values?

Can I do that; can I use functions like count or other?

Kindly note that I am not talking about program indicators , I am talking about normal indicators

Thanks in advance

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

–

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org

4

Hello Lars,

Can I reflect the SQL view on data visualizer or pivot table?

Thanks in advance

···

From: Lars Helge Øverland [mailto:larshelge@gmail.com]
Sent: Thursday, December 17, 2015 3:08 PM
To: Nami Ghadri nami_ghadri@hotmail.com
Cc: DHIS 2 Users list dhis2-users@lists.launchpad.net
Subject: Re: [Dhis2-users] indicators

Hi Nami,

I suggest you write an SQL query through data administration > sql view to achieve this.

Docs: https://www.dhis2.org/doc/snapshot/en/developer/html/ch01s25.html

regards,

Lars

On Thu, Dec 17, 2015 at 1:18 PM, Nami Ghadri nami_ghadri@hotmail.com wrote:

Hello,

If I may ask about indicators

How can I count data element that has no null values?

Can I do that; can I use functions like count or other?

Kindly note that I am not talking about program indicators , I am talking about normal indicators

Thanks in advance

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

–

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org

5

Not at the moment.

regards,

Lars

···

On Thu, Dec 17, 2015 at 2:23 PM, Nami Ghadri nami_ghadri@hotmail.com wrote:

Hello Lars,

Can I reflect the SQL view on data visualizer or pivot table?

Thanks in advance

From: Lars Helge Øverland [mailto:larshelge@gmail.com]
Sent: Thursday, December 17, 2015 3:08 PM
To: Nami Ghadri nami_ghadri@hotmail.com
Cc: DHIS 2 Users list dhis2-users@lists.launchpad.net
Subject: Re: [Dhis2-users] indicators

Hi Nami,

I suggest you write an SQL query through data administration > sql view to achieve this.

Docs: https://www.dhis2.org/doc/snapshot/en/developer/html/ch01s25.html

regards,

Lars

On Thu, Dec 17, 2015 at 1:18 PM, Nami Ghadri nami_ghadri@hotmail.com wrote:

Hello,

If I may ask about indicators

How can I count data element that has no null values?

Can I do that; can I use functions like count or other?

Kindly note that I am not talking about program indicators , I am talking about normal indicators

Thanks in advance

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

–

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org

–

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org