dhis2-users team mailing list archive

[Nami Ghadri <nami_ghadri@xxxxxxxxxxx>]

Hello Lars,

 

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

 

Thanks in advance

 

From: Lars Helge Øverland [mailto:larshelge@xxxxxxxxx] 
Sent: Thursday, December 17, 2015 3:08 PM
To: Nami Ghadri <nami_ghadri@xxxxxxxxxxx>
Cc: DHIS 2 Users list <dhis2-users@xxxxxxxxxxxxxxxxxxx>
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@xxxxxxxxxxx <mailto:nami_ghadri@xxxxxxxxxxx> > 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@xxxxxxxxxxxxxxxxxxx <mailto:dhis2-users@xxxxxxxxxxxxxxxxxxx> 
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 <https://www.dhis2.org>