dhis2-users team mailing list archive

[Lars Helge Øverland <larshelge@xxxxxxxxx>]

Not at the moment.

regards,

Lars



On Thu, Dec 17, 2015 at 2:23 PM, Nami Ghadri <nami_ghadri@xxxxxxxxxxx>
wrote:

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



-- 
Lars Helge Øverland
Lead developer, DHIS 2
University of Oslo
Skype: larshelgeoverland
http://www.dhis2.org <https://www.dhis2.org>