search

DOI-ONRR / nrrd

ONRR open data site hosted on cloud.gov
Other
13 stars 5 forks source link

Query tool can't show all GOMESA disbursements for a state #686

Closed mcharg closed 4 years ago

mcharg commented 4 years ago

If you group by recipient, it only shows county level. image.png

If you group by state, it only shows state level. image.png

Grouping shouldn't change the data that shows, it should just change how it's organized. Something is mislabeled here because the numbers are the same in both these instances.

mcharg commented 4 years ago

Part of the issue is that we're calling the "state and local governments" recipient "county". We then need to think about what happens if you organize by county after selecting a state. We'll need a line item for the state amount that isn't tied to a county.

mcharg commented 4 years ago

What we have now is a line for disbursements to the state, which I think works well. image.png

mcharg commented 4 years ago

Here's a proposal that drops the ability to filter by county, only allows selecting or grouping by a state if you pick state & local recipient, and then have a "local recipient" column available for grouping that includes the state and county level. image.png

mcharg commented 4 years ago

Closing in favor of #718