I’m working on a DHIS2 project where daily data is entered, and I would like to display a dynamic report that shows daily values for the previous month directly in a dashboard.
Goal:
Automatically update a Pivot Table each month to show daily data for the previous month, one row per day.
The report should be added to the dashboard and refresh automatically without requiring manual date selection.
Context:
Data is entered daily through a Data Set (aggregated data), not via a program or event capture(yeah I know it weird ).
I’ve tried using relative periods like LAST_MONTH, but these only return monthly aggregated values, not a breakdown by day.
Manually selecting each day of the previous month works, but it’s not practical for an automatically updating dashboard.
Questions:
Is there a native way in DHIS2 to display daily breakdowns of the previous month in a visualization?
If not, what are the best practices or workarounds recommended by the community?
Is this feature planned for a future release of DHIS2?
Hi, thanks for your reply. But last 30 days does not really suit my needs. Imagine we are today April 22, last 30 days will include data from march 23 to April 21. What I want is data from start to end of march only (the last month: march 01 to march 31)
Yes, sorry I don’t think there’s an out of the box solution to this; however, what about using dashboard filter and selecting “Last 60 days” (however, using the dashboard filter you will be able to limit it to the current month).
Sorry about this issue, I think what would work for your use case is “Days this Month” which is not part of the relative periods under Days as shown here for Months