Data approval visualization

Support - Assistance technique
1

hello everyone,

i have this question is it possible to create a dashboard showing data or dataset that is waiting to be approved,approved,ready to be approved. like showing all this status before navigating to the data approval app.

1 Like
2

Hi @mugisha_alain

There’s the option to view the Reporting Rate Summary but that doesn’t show exactly (approved, waiting, and ready), but you could create a Standard Report and then add it to a dashboard (Report - DHIS2 Documentation).

Another option is to request the info using the API:
webapi_data_set_report

I think this is actually an interesting app idea if you are working on. :+1:

3

Hey all,
Has a solution been developed for this? Any app or anything in the core?

1 Like
4

Sorry- when you say “Create a Standard Report and then add it to a dashboard” do you mean add a link to go to the standard report, or do you mean that you can see the report appearing in the dashboard?

1 Like
5

Hi @mugisha_alain , @Matthew_Boddie , @dkusiima ,

There’s been a lot of changes and updates since 2024.. and one important update is the support ‘for dashboard plugins built with the App Platform’

This means that we can use the power of creating apps and implement them as Dashboard plugins.

For example, here’s a quick sketch of the idea @mugisha_alain mentioned:

Dashboard Approvals Plugin

While of course, a real working plugin would require a lot more effort and design considerations including use-case specific design, but the reason is to show that this is possible and it’s in-fact the supported way in the newer versions.

If it’s a simple report similar to the standard reports, it might not need more complication. It could be similar to how it was implemented here:
Standard Reports in React - HISP Asia Hub 2022: https://www.youtube.com/watch?v=66KXMY9f7nU (the only difference is that you will instead use the new Dashboard plugin apps steps.

Using the old widgets method is no longer supported, also it appears that adding the standard report as @Matthew_Boddie pointed would actually create a link (I think back then I went to the Dashboard app and saw that ‘Reports’ can be selected and added but I forgot that they’d only appear as a link); however, I’m glad now that it’s actually possible with the Dashboard plugins.

Here are some resources that explain the Plugin component and how Dashboard Plugins can be created:

  1. Getting started | DHIS2 Developer Portal
  2. Implementing a Dashboard plugin | DHIS2 Developer Portal
1 Like
6

Hi @dkusiima
If your use case is pretty simple, you can also create a SQL view which lists the status of appproval for each period and organisation units, and generates an excel file which you can download.

This is of course less pretty and scalabe than a dashboard plugin, as shown by Gassim, but a quick way to get an export of the currents periods and ous to be approved, including AOC.
If you are interested, I cretaed such a view for a specific dataSet and could share it if required.

Regards