Need help or suggestion on building TEI STAGE report

Implementation - Implémentation
1

Hello community,

Hope you all doing well.
I need some help on building pivot table or reports on my TEI.
I have TEI, and 1 program stage. The data to be collected on that stage are following:
Data elements has Tracker Domain type.

image

Option sets value:

image
image449×986 16.9 KB

Final purpose: produce the following tables
image
image

Question: How can I build such type of tables? How to aggregate data? How to create data dimensions?

I will appreciate any advice and real help on developing these report tables.

Thank you.
Regards, Ulanbek

2

Hi, all.

Would anyone help with a step by step guidance on this question. It is very interesting.

Thanks

3

Hey there,
I have done this reports by building HTML-reports. No other ways were possible, as the reports required a lot of conditions to be followed and calculations done.
So I can help if you need sime guidance hiw to build HTML-reports.
Thanks and good luck🙋‍♂️

4

Hi @Ulanbek,

I would be grateful if you could help me with guidance on how to build HTML reports.

Thanks

5

Hey @hernandezmachava ernandez,

Send me your report details.
Let’s see what I can do.

Regards, Ulanbek

6

Hi @Ulanbek,

I was wondering if we could use your example case: TEI STAGE report. My report details are not in English.

Thanks

7

The language is not an issue. The main thing is to describe properly your report and requirements for that report and depends on the complexity there might be different solutions. Send me a private message if you want, with your TEI, stage data, and your report form.

8

Hi @Ulanbek,
I intend to make a report, due to many indicators, I think this will be the best way. I already have all program indicators created and working. The report must have the following as a parameter:

Start date, End date, Organizational Unit.

I already have the HTML of the image made, any help is welcome.

Screenshot from 2020-11-17 18-18-54
Screenshot from 2020-11-17 18-18-541113×736 75 KB

Thanks

9

Hello @asacur,

Quite interesting report.
Q1: do you have Javascript /HTML/CSS experience?
Q2: how the data are collected: as event/tracker/data set?

If you can provide me more details on data structures how they are related, inclyding options they use.
Provide me your email, so I can help you directly.
Thanks.
Regards, Ulanbek

10

Hi,

Q1: do you have Javascript /HTML/CSS experience?

Yes

Q2: how the data are collected: as event/tracker/data set?

Tracker, with 7 stages.

I already design all the program indicator.

Thanks for your replay.