It seems to me that the number of Actual Reports that are counted in the Reporting Rate Summary under Reports are somewhat different from Reporting rates in Data Visualizer. We are getting differences of one or two actual reports (the numerator) for the same report/district/period.
So are these numbers generated according to different methods??
We can not able to generate Pivot Report/Data Visualizer. Actually Data Mart in not functioning properly. What are the possible solution for me?
With Best regards
Navraj Bhatta
HMIS, Nepal
On Monday, June 9, 2014 4:30 PM, Knut Staring knutst@gmail.com wrote:
It seems to me that the number of Actual Reports that are counted in the Reporting Rate Summary under Reports are somewhat different from Reporting rates in Data Visualizer. We are getting differences of one or two actual reports (the numerator) for the same report/district/period.
So are these numbers generated according to different methods??
yes they actually have different implementations, although the logic should be the same. On the demo database they are equal (except for some rounding errors). We are planning to replace the reporting rate summary by extending pivot table to support the same output.
cheers
Lars
···
On Mon, Jun 9, 2014 at 12:45 PM, Knut Staring knutst@gmail.com wrote:
It seems to me that the number of Actual Reports that are counted in the Reporting Rate Summary under Reports are somewhat different from Reporting rates in Data Visualizer. We are getting differences of one or two actual reports (the numerator) for the same report/district/period.
Decided to reply this thread since this is related. Looks like dummy rows are inserted into the analytics completeness tables – this looks random though and does not follow a particular pattern. This gave a reporting unit a rate of 104% on the pivot table although it was 100% in the reporting rate, there was an extra row in the analytics but without the target uidlevel field. I don’t know if anybody has experienced this also? And maybe a possible bug but it’s hard to replicate.
yes they actually have different implementations, although the logic should be the same. On the demo database they are equal (except for some rounding errors). We are planning to replace the reporting rate summary by extending pivot table to support the same output.
cheers
Lars
On Mon, Jun 9, 2014 at 12:45 PM, Knut Staring knutst@gmail.com wrote:
It seems to me that the number of Actual Reports that are counted in the Reporting Rate Summary under Reports are somewhat different from Reporting rates in Data Visualizer. We are getting differences of one or two actual reports (the numerator) for the same report/district/period.
So are these numbers generated according to different methods??