Order of data in visualization app

Support - Assistance technique
1

Hi everyone,

I have the following situation:
We have a repeatable stage/ a checklist that calculates a percentage/score. As a demo we have registered Test 1 as a tracked entity and three events. in three different dates.

image
image1326×432 17.4 KB

In the visualization app, we would like to get data in table format like below, displaying the registered person, all the events they went through , event dates and the score per event/stage

image

We welcome all ideas that can help us achieve this

Thanks

2

Hi @ferdinandmussavene,

The Visualizer app displays data in aggregate results; however, what you are looking for seems to be more suitable in the Event Reports app or preferably in the Line Listing app, you will be able to display detailed tables similar but not exactly identical to the table you pasted. Please have a look at those apps first.

Thank you!

3

Hi @Gassim,

I had a look at different options available in event report, but it seems no possible to get what I want. Maybe explaining it in another way: We registered individuals who got different scores/percentages (calculated as program indicators) in different events/checklists in a repeatable stage. The question is: How to line list in event report the different scores each individual got over time in that repeatable stage. That’s what I mean by the post above.

E.G. if individual A got 66.66, 100, 33.33, etc in different events/dates in a repeatable stage, how should view this in the event report?

Thanks.

1 Like
4

Hi @ferdinandmussavene,

In the new Line Listing app (available for 2.38 and above), you can potentially solve this use cases in two different ways:

  1. visualize values from multiple repeatable events. Note that this has to be a DE (so can the program indicator somehow be calculated into a DE through a program rule?).
    Example screenshot:
    image
    image2296×955 212 KB
  2. Create program indicator per repeatable event through stageoffset (Follow the explanation in this
    issue    , so one PI for most recent event, one for event before that (stageoffset-1) etc and add each of them in the line list.

Let me know if you try out either of these solutions with the LL app and if it works!

Thanks in advance,
Karoline
DHIS2 Functional Design

1 Like
5

Hi @Karoline,

I have read the explanation recommended below, but it is not yet clear for me where to put stageoffset.

Here is the explanation text I copied from the post:

[D][Testing] Selection of repeatable stages in analytics

General

Advanced

Description

If the values of repeatable stages are requested, we are delivering just the latest repeated stage value (latest execution date). This task is to deliver selected stage via index, or all of them.

Indicator example:

Expression:

#{edqlbukwRfQ.vANAXwtLwcT}.stageOffset(0) + #{edqlbukwRfQ.vANAXwtLwcT}.stageOffset(1) - #{WZbXY0S00lP.vANAXwtLwcT}

Filter:

#{edqlbukwRfQ.vANAXwtLwcT}.stageOffset(1) != 0 and #{WZbXY0S00lP.vANAXwtLwcT} != 0

Analytics query example:

dimension=edqlbukwRfQ[1].vANAXwtLwcT

Stage offset value:

1 = first event
2 = second event
…
-2 = third latest event
-1 = second latest event
0 = latest event(default)

Thanks again.

6

Hi @Karoline and @Gassim,

We have a tracker program:

There are three program stages: the first and second stages are non-repeatable stages; the third stage is repeatable. Ill all the stages we track the condoms received (DE) by a beneficiary. For the third stage, condoms are distributed to beneficiaries quarterly. We are having difficulty line listing the occurrence of all values captured for this data element in the event report.

We have set the table style to ‘line list’ and output type to ‘enrollment. We selected the data element from different stages, but for the third stage, it only displays the latest value.

And setting the table style to ‘line list’ and output type to event does not allow us to select data element from multiple stages.

We need to view all values captured in the repeatable stage together with those values captured in the non repeatable stages at once/the same time ?

Thanks