fix: compute subtotals/totals for boolean types (DHIS2-9155) #1696
+26
−13
Add this suggestion to a batch that can be applied as a single commit.
This suggestion is invalid because no changes were made to the code.
Suggestions cannot be applied while the pull request is closed.
Suggestions cannot be applied while viewing a subset of changes.
Only one suggestion per line can be applied in a batch.
Add this suggestion to a batch that can be applied as a single commit.
Applying suggestions on deleted lines is not supported.
You must change the existing code in this line in order to create a valid suggestion.
Outdated suggestions cannot be applied.
This suggestion has been applied or marked resolved.
Suggestions cannot be applied from pending reviews.
Suggestions cannot be applied on multi-line comments.
Suggestions cannot be applied while the pull request is queued to merge.
Suggestion cannot be applied right now. Please check back later.
Implements DHIS2-9155
Key features
Description
In aggregate analytics, boolean types can be summed up.
Prior to this PR, only dimensions with value type
NUMBER
were summed up when subtotals and/or totals options were enabled.After this PR, all numeric and boolean types will be summed up.
Screenshots
Before:
![Screenshot 2024-08-21 at 10 54 41](https://private-user-images.githubusercontent.com/150978/359826744-00740e42-42cb-4a7c-82e2-282f39a94c21.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3Mzk3NjcxOTUsIm5iZiI6MTczOTc2Njg5NSwicGF0aCI6Ii8xNTA5NzgvMzU5ODI2NzQ0LTAwNzQwZTQyLTQyY2ItNGE3Yy04MmUyLTI4MmYzOWE5NGMyMS5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjUwMjE3JTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI1MDIxN1QwNDM0NTVaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT0zYjE4ZDE1NWM4ZDk3ODRlYWMyZDhkMmZkMGU2ZjQxMTk4NzVjYTUyODUxMWFjNGU0NjAyNjgxM2E4MDdlNjM0JlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCJ9.jzjNIPFzwvByc4n7G5dhLHkX4beE8IcDxuQ8_OOa0Fw)
After:
![Screenshot 2024-08-20 at 14 42 33](https://private-user-images.githubusercontent.com/150978/359826768-a53c7c9b-9b1d-489f-8333-1cb6c3c5ced6.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3Mzk3NjcxOTUsIm5iZiI6MTczOTc2Njg5NSwicGF0aCI6Ii8xNTA5NzgvMzU5ODI2NzY4LWE1M2M3YzliLTliMWQtNDg5Zi04MzMzLTFjYjZjM2M1Y2VkNi5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjUwMjE3JTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI1MDIxN1QwNDM0NTVaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT1kYmQyNDkzM2IwMTFkYWRkYWJjZjU3NDY5MWEyN2ZlMTM5ZWUxMDYwMzY4MjBlZGZhMTdkNWVhYmUzODJiMzA5JlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCJ9.ZSA64AFIRNXgTgwxLBbnCsfDVKN7kb5EYjJWHhkYqOg)