Aggreration query for single event without registration

Hi all,

Is it possible in the Aggregation Query Builder to use the "Number of tracked entities" operator to calculate a number of events, especially when it concerns Single events without registration?

I tried it and although it finds the events based on the conditions, it always returns 0 as a value.

Regards,

Robin

Robin,

Unlikely that the "number of tracked entities" operator will work for
programs defined as single events without registration, because that
type of program does not have ANY entities.

A relatively simple work-around is to define one extra data element in
your event - maybe called just "Event" - with a default value of 1.
Adding those up will give you the number of events.

We've been using Single Events for storing a range of survey data -
every survey or sub-survey (questionnaire) is defined as a program.
With the aggregation query builder (a) running against the raw event
data value table and not the analytics event tables; and (b) inability
to use a weighting factor on each case before aggregation, we
(HISP-SA) have designed an app that filters a range of cases based on
whatever criteria is relevant, multiplies the base value with a
weighting factor if required, and then aggregates the (weighted) base
value up to district or national level and inserts the aggregated
records into the datavalues table.

Since many indicators will require the number of cases as the
denominator, it makes sense to have one "Event" or "Survey_Respondent"
data element with number = 1 for all cases. So when calculating e.g.
the indicator "Households with safe water rate", we can generate both
the (weighted) total number of households in the survey and then
filter all the households for specific criteria based on one or more
"Household source of drinking water" and then aggregate that up
(weighted) to form the numerator data.

The app is still a bit crude, but I expect we will be able to polish
it up and publish it to the library shortly.

Regards
calle

···

On 21/01/2015, Robin Martens <martens@sher.be> wrote:

Hi all,

Is it possible in the Aggregation Query Builder to use the "Number of
tracked entities" operator to calculate a number of events, especially when
it concerns Single events without registration?

I tried it and although it finds the events based on the conditions, it
always returns 0 as a value.

Regards,

Robin

--

*******************************************

Calle Hedberg

46D Alma Road, 7700 Rosebank, SOUTH AFRICA

Tel/fax (home): +27-21-685-6472

Cell: +27-82-853-5352

Iridium SatPhone: +8816-315-19274

Email: calle.hedberg@gmail.com

Skype: calle_hedberg

*******************************************

Robin,

We have a feature to get number of events for a given program stage.

Two options need to be set:

  1. Operator, at the top of the page, need to be ‘Number of visits’

  2. Under the Program tab, select ‘Visited selected program stage’

The formula will then be on this format :

[PS:391]

With 391 being the internal id of the program stage.

That should give you the total number of events for your single event without registration program.

Ola

···

Hi all,

Is it possible in the Aggregation Query Builder to use the “Number of tracked entities” operator to calculate a number of events, especially when it concerns Single events without registration?

I tried it and although it finds the events based on the conditions, it always returns 0 as a value.

Regards,

Robin

Hi Ola,

Thanks a lot, that works great!

Regards,

Robin

···

Hi all,

Is it possible in the Aggregation Query Builder to use the “Number of tracked entities” operator to calculate a number of events, especially when it concerns Single events without registration?

I tried it and although it finds the events based on the conditions, it always returns 0 as a value.

Regards,

Robin