Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Repeated values in summary tables #5103

Open
timlinux opened this issue Oct 11, 2021 · 4 comments
Open

Repeated values in summary tables #5103

timlinux opened this issue Oct 11, 2021 · 4 comments
Assignees

Comments

@timlinux
Copy link
Contributor

Problem

Summary by district produces same numbers for all rows

image

@timlinux
Copy link
Contributor Author

Sample dataset in Nextcloud/Projects/DHI Group/InaSAFE-Bhutan/StLuciaInaSAFE.zip

@lucernae
Copy link
Collaborator

@timlinux I found out that this is caused by the aggregation_id field you used in Quarters layer all use the same id = 0. That's why the aggregation process put it in the same bucket, and every aggregation row use the same result.

We can ignore this as data preparation issue or treat is as bug because we should put validation in place for any id field. However I'm not sure where to put the validation logic and show the error.
Maybe in the pre analysis run hook if we have something like that?

@lucernae
Copy link
Collaborator

Sample of results if I manually edited all class attribute in Quarters layers to all have different value.
Not sure why you use class attribute in the first place as an id field. class implies that it categorizes each features into a common trait, so it is definitely not unique.

image

@timlinux
Copy link
Contributor Author

Great investigation, thanks! If you can make it prevent the run button being enabled if the id is not set

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants