← Back to team overview

dhis2-users team mailing list archive

Re: Datamart

 

I would need to provide code to make it make sense,but indicators of number
type and data elements are handled in one way,indicators with denominators
in another manner.  I am travelling at the moment but can send some details
next week.

Regards,
Jason
--
Sent from my mobile
On Jul 20, 2012 1:39 PM, "Ola Hodne Titlestad" <olati@xxxxxxxxxx> wrote:

> Jason,
> How do you handle the values in this view? Indicator values should be set
> up as a calculated field to let excel aggregate numerators and denominators
> separately for percentage values. If not the values for higher levels will
> be wrong.
>
> Or are you using only one orgunit level in this view?
>
> I guess it is possible to use two separate value fields for data elements
> and indicators in the same pivot table?
> Sounds confusing, but for a very specific/static table maybe.... but then
> I would recommend standard reports.
>
> Ola
> -------
> On Jul 20, 2012 7:24 PM, "Kabango Malewezi" <kmalewezi@xxxxxxxxxxx> wrote:
>
>> Hi Kabango,
>>
>> That is not possible.
>>
>> You can do it with report tables and standard reports.
>>
>> Ola
>> -------
>> On Jul 20, 2012 10:49 AM, "Kabango Malewezi" <kmalewezi@xxxxxxxxxxx>
>> wrote:
>>
>>> Gentle People,
>>>
>>>
>>>
>>> I'd like to have Elements and indicators in one excel pivot table. How
>>> do I do that? The available views I have have either Pivot_Indicator or
>>> Pivot_Routinedata.
>>>
>>>
>>>
>>> Kabango Malewezi
>>>
>>> SSDI Services
>>>
>>> 2nd Floor, Pamodzi House, City Center, P.O Box 1091, Lilongwe, Malawi
>>> Tel: +265 (01) 776 412/3/4 | fax: +265 (01) 776 410 | Mobile: +265 (0)
>>> 88 4 245 431
>>>
>>> kmalewezi@xxxxxxxxxxx <mailto:kmalewezi@xxxxxxxxxxx > |  www.jhpiego.org
>>> <http://www.jhpiego.org/>
>>>
>>> Skype: kabango.malewezi | Twitter: kabangoM
>>>
>>> _______________________________________________
>>> 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
>>>
>>

References