← Back to team overview

dhis2-devs team mailing list archive

Re: Defect with the Aggregation Query feature?

 

Hello,

We were wondering if this bug has been fixed as part of rev #19075. We are
on rev #19097 and are still facing this issue

Regards,
Simanta


On Tue, Apr 28, 2015 at 5:51 PM, Tran Chau (HISP Vietnam) <
tran.hispvietnam@xxxxxxxxx> wrote:

> HI Simanta and others,
>
> The issue is in Manual Aggregate, the "0" values are not displayed/saved.
> I am working on it to display and save "0" values in Manual Aggregate
> functionality.
>
>
> Thank you for reporting this bug.
>
> ..........................................
> Best regards,
> Tran Chau
>
> On Mon, Apr 27, 2015 at 5:48 PM, Simanta Jyoti Handique <
> shandique@xxxxxxxxxxxxxxxx> wrote:
>
>> Hi, thanks for the response. The data elements were already configured to
>> store zero data values.
>>
>> This may be another symptom to the problem: If I run the aggregation
>> manually and preview the data that will be saved, there are no results with
>> 0 values
>>
>> Regards,
>> Simanta
>>
>>
>>
>> On Mon, Apr 27, 2015 at 1:58 PM, Adebusoye Anifalaje <busoye@xxxxxxxx>
>> wrote:
>>
>>> Sorry,
>>>
>>> Just re read your question. My mistake. To overwrite values with 0, you
>>> have to choose to store zero data values when creating the aggregate data
>>> element.
>>>
>>>
>>> On Monday, April 27, 2015, Adebusoye Anifalaje <busoye@xxxxxxxx> wrote:
>>>
>>>> Hi Simanta,
>>>>
>>>> You should try changing the Operator to Number of tracked entities.
>>>> Visits are technically for program stages and since you are not registering
>>>> programs then you can't have visits.
>>>>
>>>> Try tracked entities and let's know whether it worked.
>>>>
>>>> Cheers.
>>>>
>>>> Busoye
>>>>
>>>>
>>>>
>>>> On Monday, April 27, 2015, Simanta Jyoti Handique <
>>>> shandique@xxxxxxxxxxxxxxxx> wrote:
>>>>
>>>>> Hi,
>>>>>
>>>>> We have set up an aggregation query with the following details:
>>>>>
>>>>> Name: Number of Patients (Measles Outbreak)
>>>>> Operator: Number of Visits
>>>>> Data set: Geographic Origin
>>>>> Data Element: Number of Patients (Measles Outbreak) - Geographic
>>>>> Origin (Number)
>>>>> Condition: [Measles Outbreak.Measles Outbreak stage.Date of admission]
>>>>> is not null
>>>>>
>>>>> "Measles Outbreak" is a Single Event without Registration type
>>>>> program. "Date of admission" is a Data Element of type Date
>>>>>
>>>>> We register an event, run the aggregation query and the "Number of
>>>>> Patients (Measles Outbreak) - Geographic Origin (Number)" data element is
>>>>> correctly populated with the count of the number of patients. We delete the
>>>>> event and re-run the query. The data element for the number of patients
>>>>> does not get updated with the value 0.
>>>>>
>>>>> Is this a defect with the Aggregation Query feature or is there
>>>>> something wrong with the formula we're using?
>>>>>
>>>>> Regards,
>>>>> Simanta
>>>>>
>>>>>
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>

Follow ups

References