Creating SQL views

Development - Développement
1

Hello community

I want to create an sql query in the sql view to retrieve all data sets that have been entered data for meaning I want to see the name and the period of data entry as well as organization units

After I want to visualize this retrieved data in a pivot table

Could anyone help am stack

2

Hi,
That feature is currenty not supported, but you can achieve that by using the data visualiser app and use pivot table and select dataset in data type and use actual reports

3

You can’t visualize “arbitrary” data in the data visualizer app.

2 options :

  • create a dhis2 app that does it
  • use an existing dhis2 app like taskr

graphs are not super documented
you can have a look at this recipe : dhis2-taskr/src/recipes.js at master · BLSQ/dhis2-taskr · GitHub

to see it live: Dhis2 Taskr