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

Group by metric when aggregating #2023

Open
jc-harrison opened this issue Feb 28, 2020 · 0 comments
Open

Group by metric when aggregating #2023

jc-harrison opened this issue Feb 28, 2020 · 0 comments
Labels
FlowMachine Issues related to FlowMachine investigation needed Extra attention is needed

Comments

@jc-harrison
Copy link
Member

We could consider adding a 'groupby' parameter to joined spatial aggregate queries (and non-spatial aggregates - c.f. #2022), to specify a categorical metric to group by before aggregating. Query results would then have columns [<location_id_col(s)>, group, value] instead of just [<location_id_col(s)>, value] (similar to the current method="distr" option, but values would be aggregates of a second metric, instead of proportions).

We could also consider exposing a way of binning continuous metrics, so they could be used for grouping. If so, bins should be consistent with those obtained from a histogram aggregeation.

@jc-harrison jc-harrison added the FlowMachine Issues related to FlowMachine label Feb 28, 2020
@greenape greenape added investigation needed Extra attention is needed P-Next labels Oct 8, 2021
@greenape greenape removed the P-Next label Apr 24, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
FlowMachine Issues related to FlowMachine investigation needed Extra attention is needed
Projects
None yet
Development

No branches or pull requests

2 participants