search

datachile / datachile-mondrian

Schema de Mondrian para DataChile. Server API.
https://chilecube.datachile.io/cubes
1 stars 2 forks source link

Cut NENE's expansion factor results by last available month #21

Closed palamago closed 5 years ago

palamago commented 6 years ago

If you cut a query by year on NENE cube the aggregations are not what we want. That's because the data has month level for Date.

https://chilecube.datawheel.us/ui/#eyJkcmlsbERvd25zIjpbWyJEYXRlIiwiRGF0ZSIsIlllYXIiXSxbIklTSUNyZXY0IiwiSVNJQ3JldjQiLCJMZXZlbCAxIl1dLCJjdXRzIjpbW1syMDE3XSxbIkRhdGUiLCJEYXRlIiwiWWVhciJdXV0sImN1YmUiOiJuZW5lIiwibWVhc3VyZXMiOlsiRXhwYW5zaW9uIGZhY3RvciJdfQ==

Change the config to: Cut NENE's expansion factor results by last available month when you cut by year.

palamago commented 6 years ago

Also, create RANK and DECILE.

jazzido commented 6 years ago

Also, create RANK and DECILE.

For Geographies?

palamago commented 6 years ago

@jazzido no, by ISIC level 1 and level 2