datachile / datachile-mondrian

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

can't add year+month on NENE #8

Closed pachadotdev closed 7 years ago

pachadotdev commented 7 years ago

NENE is quarterly, so to count well I need year+month

the cube is not showing the API call but the URL is

http://chilecube.datawheel.us/ui/#eyJkcmlsbERvd25zIjpbWyJEYXRlIiwiRGF0ZSIsIlllYXIiXV0sImN1dHMiOltdLCJjdWJlIjoibmVuZSIsIm1lYXN1cmVzIjpbIk51bWJlciBvZiByZWNvcmRzIl19

screen shot 2017-08-08 at 00 48 00

pachadotdev commented 7 years ago

details

DataChile
nesi_income
Debug
×Close alert
Error: Bad Request[less]
root cause: mondrian.olap.MondrianException: Mondrian Error:Hierarchy '[Date]' appears in more than one independent axis.
root cause:   mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:984)
root cause:   mondrian.olap.Query.resolve(Query.java:625)
root cause:   mondrian.olap.Query.resolve(Query.java:476)
root cause:   mondrian.olap.Query.<init>(Query.java:200)
root cause:   mondrian.olap.Query.<init>(Query.java:161)
root cause:   mondrian.olap.Parser$FactoryImpl.makeQuery(Parser.java:927)
root cause:   mondrian.parser.MdxParserImpl.selectStatement(MdxParserImpl.java:1241)
root cause:   mondrian.parser.MdxParserImpl.statement(MdxParserImpl.java:1074)
root cause:   mondrian.parser.MdxParserImpl.statementEof(MdxParserImpl.java:188)
root cause:   mondrian.parser.JavaccParserValidatorImpl.parseInternal(JavaccParserValidatorImpl.java:57)
mondrian/olap4j/MondrianOlap4jConnection.java:858:in `createException'
mondrian/olap4j/MondrianOlap4jStatement.java:375:in `parseQuery'
mondrian/olap4j/MondrianOlap4jPreparedStatement.java:64:in `<init>'
mondrian/olap4j/FactoryJdbc4Plus.java:682:in `<init>'
mondrian/olap4j/FactoryJdbc41Impl.java:188:in `<init>'
mondrian/olap4j/FactoryJdbc41Impl.java:70:in `newPreparedStatement'
mondrian/olap4j/MondrianOlap4jConnection.java:505:in `prepareOlapStatement'
java/lang/reflect/Method.java:498:in `invoke'
org/jruby/javasupport/JavaMethod.java:453:in `invokeDirectWithExceptionHandling'
org/jruby/javasupport/JavaMethod.java:314:in `invokeDirect'
home/hermes/$_dot_rvm/gems/jruby_minus_9_dot_1_dot_5_dot_0/gems/mondrian_minus_olap_minus_0_dot_8_dot_0/lib/mondrian/olap//home/hermes/.rvm/gems/jruby-9.1.5.0/gems/mondrian-olap-0.8.0/lib/mondrian/olap/connection.rb:78:in `invokeOther1:prepareOlapStatement'
home/hermes/$_dot_rvm/gems/jruby_minus_9_dot_1_dot_5_dot_0/gems/mondrian_minus_olap_minus_0_dot_8_dot_0/lib/mondrian/olap//home/hermes/.rvm/gems/jruby-9.1.5.0/gems/mondrian-olap-0.8.0/lib/mondrian/olap/connection.rb:78:in `block in execute'
home/hermes/$_dot_rvm/gems/jruby_minus_9_dot_1_dot_5_dot_0/gems/mondrian_minus_olap_minus_0_dot_8_dot_0/lib/mondrian/olap//home/hermes/.rvm/gems/jruby-9.1.5.0/gems/mondrian-olap-0.8.0/lib/mondrian/olap/error.rb:19:in `wrap_native_exception'
home/hermes/$_dot_rvm/gems/jruby_minus_9_dot_1_dot_5_dot_0/gems/mondrian_minus_olap_minus_0_dot_8_dot_0/lib/mondrian/olap//home/hermes/.rvm/gems/jruby-9.1.5.0/gems/mondrian-olap-0.8.0/lib/mondrian/olap/connection.rb:77:in `invokeOther6:wrap_native_exception'
home/hermes/$_dot_rvm/gems/jruby_minus_9_dot_1_dot_5_dot_0/gems/mondrian_minus_olap_minus_0_dot_8_dot_0/lib/mondrian/olap//home/hermes/.rvm/gems/jruby-9.1.5.0/gems/mondrian-olap-0.8.0/lib/mondrian/olap/connection.rb:77:in `execute'
home/hermes/$_dot_rvm/gems/jruby_minus_9_dot_1_dot_5_dot_0/gems/mondrian_minus_rest_minus_0_dot_7_dot_0_minus_java/lib/mondrian_rest//home/hermes/.rvm/gems/jruby-9.1.5.0/gems/mondrian-rest-0.7.0-java/lib/mondrian_rest/api_helpers.rb:46:in `invokeOther15:execute'
home/hermes/$_dot_rvm/gems/jruby_minus_9_dot_1_dot_5_dot_0/gems/mondrian_minus_rest_minus_0_dot_7_dot_0_minus_java/lib/mondrian_rest//home/hermes/.rvm/gems/jruby-9.1.5.0/gems/mondrian-rest-0.7.0-java/lib/mondrian_rest/api_helpers.rb:46:in `mdx'
home/hermes/$_dot_rvm/gems/jruby_minus_9_dot_1_dot_5_dot_0/gems/mondrian_minus_rest_minus_0_dot_7_dot_0_minus_java/lib/mondrian_rest//home/hermes/.rvm/gems/jruby-9.1.5.0/gems/mondrian-rest-0.7.0-java/lib/mondrian_rest/api_helpers.rb:58:in `invokeOther23:mdx'
home/hermes/$_dot_rvm/gems/jruby_minus_9_dot_1_dot_5_dot_0/gems/mondrian_minus_rest_minus_0_dot_7_dot_0_minus_java/lib/mondrian_rest//home/hermes/.rvm/gems/jruby-9.1.5.0/gems/mondrian-rest-0.7.0-java/lib/mondrian_rest/api_helpers.rb:58:in `run_from_params'
home/hermes/$_dot_rvm/gems/jruby_minus_9_dot_1_dot_5_dot_0/gems/mondrian_minus_rest_minus_0_dot_7_dot_0_minus_java/lib/mondrian_rest//home/hermes/.rvm/gems/jruby-9.1.5.0/gems/mondrian-rest-0.7.0-java/lib/mondrian_rest/api.rb:142:in `invokeOther1:run_from_params'
home/hermes/$_dot_rvm/gems/jruby_minus_9_dot_1_dot_5_dot_0/gems/mondrian_minus_rest_minus_0_dot_7_dot_0_minus_java/lib/mondrian_rest//home/hermes/.rvm/gems/jruby-9.1.5.0/gems/mondrian-rest-0.7.0-java/lib/mondrian_rest/api.rb:142:in `block in Api'
org/jruby/RubyProc.java:324:in `call'
org/jruby/RubyMethod.java:111:in `call'
org/jruby/RubyMethod$INVOKER$i$call.gen:-1:in `call'
home/hermes/$_dot_rvm/gems/jruby_minus_9_dot_1_dot_5_dot_0/gems/grape_minus_1_dot_0_dot_0/lib/grape//home/hermes/.rvm/gems/jruby-9.1.5.0/gems/grape-1.0.0/lib/grape/endpoint.rb:57:in `invokeOther1:call'
home/hermes/$_dot_rvm/gems/jruby_minus_9_dot_1_dot_5_dot_0/gems/grape_minus_1_dot_0_dot_0/lib/grape//home/hermes/.rvm/gems/jruby-9.1.5.0/gems/grape-1.0.0/lib/grape/endpoint.rb:57:in `block in generate_api_method'
home/hermes/$_dot_rvm/gems/jruby_minus_9_dot_1_dot_5_dot_0/gems/activesupport_minus_5_dot_1_dot_2/lib/active_support//home/hermes/.rvm/gems/jruby-9.1.5.0/gems/activesupport-5.1.2/lib/active_support/notifications.rb:168:in `instrument'
home/hermes/$_dot_rvm/gems/jruby_minus_9_dot_1_dot_5_dot_0/gems/grape_minus_1_dot_0_dot_0/lib/grape//home/hermes/.rvm/gems/jruby-9.1.5.0/gems/grape-1.0.0/lib/grape/endpoint.rb:56:in `invokeOther5:instrument'
home/hermes/$_dot_rvm/gems/jruby_minus_9_dot_1_dot_5_dot_0/gems/grape_minus_1_dot_0_dot_0/lib/grape//home/hermes/.rvm/gems/jruby-9.1.5.0/gems/grape-1.0.0/lib/grape/endpoint.rb:56:in `block in generate_api_method'
org/jruby/RubyProc.java:324:in `call'
org/jruby/RubyProc.java:308:in `call19'
org/jruby/RubyProc$INVOKER$i$0$0$call19.gen:-1:in `call'
home/hermes/$_dot_rvm/gems/jruby_minus_9_dot_1_dot_5_dot_0/gems/grape_minus_1_dot_0_dot_0/lib/grape//home/hermes/.rvm/gems/jruby-9.1.5.0/gems/grape-1.0.0/lib/grape/endpoint.rb:262:in `invokeOther105:call'
home/hermes/$_dot_rvm/gems/jruby_minus_9_dot_1_dot_5_dot_0/gems/grape_minus_1_dot_0_dot_0/lib/grape//home/hermes/.rvm/gems/jruby-9.1.5.0/gems/grape-1.0.0/lib/grape/endpoint.rb:262:in `block in run'
home/hermes/$_dot_rvm/gems/jruby_minus_9_dot_1_dot_5_dot_0/gems/activesupport_minus_5_dot_1_dot_2/lib/active_support//home/hermes/.rvm/gems/jruby-9.1.5.0/gems/activesupport-5.1.2/lib/active_support/notifications.rb:168:in `instrument'
home/hermes/$_dot_rvm/gems/jruby_minus_9_dot_1_dot_5_dot_0/gems/grape_minus_1_dot_0_dot_0/lib/grape//home/hermes/.rvm/gems/jruby-9.1.5.0/gems/grape-1.0.0/lib/grape/endpoint.rb:243:in `invokeOther123:instrument'
home/hermes/$_dot_rvm/gems/jruby_minus_9_dot_1_dot_5_dot_0/gems/grape_minus_1_dot_0_dot_0/lib/grape//home/hermes/.rvm/gems/jruby-9.1.5.0/gems/grape-1.0.0/lib/grape/endpoint.rb:243:in `run'
home/hermes/$_dot_rvm/gems/jruby_minus_9_dot_1_dot_5_dot_0/gems/grape_minus_1_dot_0_dot_0/lib/grape//home/hermes/.rvm/gems/jruby-9.1.5.0/gems/grape-1.0.0/lib/grape/endpoint.rb:313:in `invokeOther1:run'
home/hermes/$_dot_rvm/gems/jruby_minus_9_dot_1_dot_5_dot_0/gems/grape_minus_1_dot_0_dot_0/lib/grape//home/hermes/.rvm/gems/jruby-9.1.5.0/gems/grape-1.0.0/lib/grape/endpoint.rb:313:in `block in build_stack'
org/jruby/RubyProc.java:324:in `call'
org/jruby/RubyProc.java:308:in `call19'
org/jruby/RubyProc$INVOKER$i$0$0$call19.gen:-1:in `call'
home/hermes/$_dot_rvm/gems/jruby_minus_9_dot_1_dot_5_dot_0/gems/grape_minus_1_dot_0_dot_0/lib/grape/middleware//home/hermes/.rvm/gems/jruby-9.1.5.0/gems/grape-1.0.0/lib/grape/middleware/base.rb:31:in `invokeOther30:call'
home/hermes/$_dot_rvm/gems/jruby_minus_9_dot_1_dot_5_dot_0/gems/grape_minus_1_dot_0_dot_0/lib/grape/middleware//home/hermes/.rvm/gems/jruby-9.1.5.0/gems/grape-1.0.0/lib/grape/middleware/base.rb:31:in `call!'
home/hermes/$_dot_rvm/gems/jruby_minus_9_dot_1_dot_5_dot_0/gems/grape_minus_1_dot_0_dot_0/lib/grape/middleware//home/hermes/.rvm/gems/jruby-9.1.5.0/gems/grape-1.0.0/lib/grape/middleware/base.rb:24:in `invokeOther3:call!'
home/hermes/$_dot_rvm/gems/jruby_minus_9_dot_1_dot_5_dot_0/gems/grape_minus_1_dot_0_dot_0/lib/grape/middleware//home/hermes/.rvm/gems/jruby-9.1.5.0/gems/grape-1.0.0/lib/grape/middleware/base.rb:24:in `call'
home/hermes/$_dot_rvm/gems/jruby_minus_9_dot_1_dot_5_dot_0/gems/grape_minus_1_dot_0_dot_0/lib/grape/middleware//home/hermes/.rvm/gems/jruby-9.1.5.0/gems/grape-1.0.0/lib/grape/middleware/base.rb:31:in `invokeOther30:call'
home/hermes/$_dot_rvm/gems/jruby_minus_9_dot_1_dot_5_dot_0/gems/grape_minus_1_dot_0_dot_0/lib/grape/middleware//home/hermes/.rvm/gems/jruby-9.1.5.0/gems/grape-1.0.0/lib/grape/middleware/base.rb:31:in `call!'
home/hermes/$_dot_rvm/gems/jruby_minus_9_dot_1_dot_5_dot_0/gems/grape_minus_1_dot_0_dot_0/lib/grape/middleware//home/hermes/.rvm/gems/jruby-9.1.5.0/gems/grape-1.0.0/lib/grape/middleware/base.rb:24:in `invokeOther3:call!'
home/hermes/$_dot_rvm/gems/jruby_minus_9_dot_1_dot_5_dot_0/gems/grape_minus_1_dot_0_dot_0/lib/grape/middleware//home/hermes/.rvm/gems/jruby-9.1.5.0/gems/grape-1.0.0/lib/grape/middleware/base.rb:24:in `call'
home/hermes/$_dot_rvm/gems/jruby_minus_9_dot_1_dot_5_dot_0/gems/grape_minus_1_dot_0_dot_0/lib/grape/middleware//home/hermes/.rvm/gems/jruby-9.1.5.0/gems/grape-1.0.0/lib/grape/middleware/error.rb:34:in `invokeOther24:call'
home/hermes/$_dot_rvm/gems/jruby_minus_9_dot_1_dot_5_dot_0/gems/grape_minus_1_dot_0_dot_0/lib/grape/middleware//home/hermes/.rvm/gems/jruby-9.1.5.0/gems/grape-1.0.0/lib/grape/middleware/error.rb:34:in `block in call!'
org/jruby/RubyContinuation.java:107:in `enter'
org/jruby/RubyKernel.java:1122:in `rbCatch19Common'
org/jruby/RubyKernel.java:1115:in `catch'
org/jruby/RubyKernel$INVOKER$s$rbCatch19.gen:-1:in `call'
home/hermes/$_dot_rvm/gems/jruby_minus_9_dot_1_dot_5_dot_0/gems/grape_minus_1_dot_0_dot_0/lib/grape/middleware//home/hermes/.rvm/gems/jruby-9.1.5.0/gems/grape-1.0.0/lib/grape/middleware/error.rb:33:in `invokeOther29:catch'
home/hermes/$_dot_rvm/gems/jruby_minus_9_dot_1_dot_5_dot_0/gems/grape_minus_1_dot_0_dot_0/lib/grape/middleware//home/hermes/.rvm/gems/jruby-9.1.5.0/gems/grape-1.0.0/lib/grape/middleware/error.rb:33:in `call!'
home/hermes/$_dot_rvm/gems/jruby_minus_9_dot_1_dot_5_dot_0/gems/grape_minus_1_dot_0_dot_0/lib/grape/middleware//home/hermes/.rvm/gems/jruby-9.1.5.0/gems/grape-1.0.0/lib/grape/middleware/base.rb:24:in `invokeOther3:call!'
home/hermes/$_dot_rvm/gems/jruby_minus_9_dot_1_dot_5_dot_0/gems/grape_minus_1_dot_0_dot_0/lib/grape/middleware//home/hermes/.rvm/gems/jruby-9.1.5.0/gems/grape-1.0.0/lib/grape/middleware/base.rb:24:in `call'
home/hermes/$_dot_rvm/gems/jruby_minus_9_dot_1_dot_5_dot_0/gems/rack_minus_2_dot_0_dot_3/lib/rack//home/hermes/.rvm/gems/jruby-9.1.5.0/gems/rack-2.0.3/lib/rack/head.rb:12:in `invokeOther13:call'
home/hermes/$_dot_rvm/gems/jruby_minus_9_dot_1_dot_5_dot_0/gems/rack_minus_2_dot_0_dot_3/lib/rack//home/hermes/.rvm/gems/jruby-9.1.5.0/gems/rack-2.0.3/lib/rack/head.rb:12:in `call'
home/hermes/$_dot_rvm/gems/jruby_minus_9_dot_1_dot_5_dot_0/gems/grape_minus_1_dot_0_dot_0/lib/grape//home/hermes/.rvm/gems/jruby-9.1.5.0/gems/grape-1.0.0/lib/grape/endpoint.rb:227:in `invokeOther7:call'
home/hermes/$_dot_rvm/gems/jruby_minus_9_dot_1_dot_5_dot_0/gems/grape_minus_1_dot_0_dot_0/lib/grape//home/hermes/.rvm/gems/jruby-9.1.5.0/gems/grape-1.0.0/lib/grape/endpoint.rb:227:in `call!'
home/hermes/$_dot_rvm/gems/jruby_minus_9_dot_1_dot_5_dot_0/gems/grape_minus_1_dot_0_dot_0/lib/grape//home/hermes/.rvm/gems/jruby-9.1.5.0/gems/grape-1.0.0/lib/grape/endpoint.rb:221:in `invokeOther5:call!'
home/hermes/$_dot_rvm/gems/jruby_minus_9_dot_1_dot_5_dot_0/gems/grape_minus_1_dot_0_dot_0/lib/grape//home/hermes/.rvm/gems/jruby-9.1.5.0/gems/grape-1.0.0/lib/grape/endpoint.rb:221:in `call'
home/hermes/$_dot_rvm/gems/jruby_minus_9_dot_1_dot_5_dot_0/gems/grape_minus_1_dot_0_dot_0/lib/grape/router//home/hermes/.rvm/gems/jruby-9.1.5.0/gems/grape-1.0.0/lib/grape/router/route.rb:72:in `invokeOther3:call'
home/hermes/$_dot_rvm/gems/jruby_minus_9_dot_1_dot_5_dot_0/gems/grape_minus_1_dot_0_dot_0/lib/grape/router//home/hermes/.rvm/gems/jruby-9.1.5.0/gems/grape-1.0.0/lib/grape/router/route.rb:72:in `exec'
home/hermes/$_dot_rvm/gems/jruby_minus_9_dot_1_dot_5_dot_0/gems/grape_minus_1_dot_0_dot_0/lib/grape//home/hermes/.rvm/gems/jruby-9.1.5.0/gems/grape-1.0.0/lib/grape/router.rb:119:in `invokeOther9:exec'
home/hermes/$_dot_rvm/gems/jruby_minus_9_dot_1_dot_5_dot_0/gems/grape_minus_1_dot_0_dot_0/lib/grape//home/hermes/.rvm/gems/jruby-9.1.5.0/gems/grape-1.0.0/lib/grape/router.rb:119:in `process_route'
home/hermes/$_dot_rvm/gems/jruby_minus_9_dot_1_dot_5_dot_0/gems/grape_minus_1_dot_0_dot_0/lib/grape//home/hermes/.rvm/gems/jruby-9.1.5.0/gems/grape-1.0.0/lib/grape/router.rb:74:in `invokeOther5:process_route'
home/hermes/$_dot_rvm/gems/jruby_minus_9_dot_1_dot_5_dot_0/gems/grape_minus_1_dot_0_dot_0/lib/grape//home/hermes/.rvm/gems/jruby-9.1.5.0/gems/grape-1.0.0/lib/grape/router.rb:74:in `block in identity'
home/hermes/$_dot_rvm/gems/jruby_minus_9_dot_1_dot_5_dot_0/gems/grape_minus_1_dot_0_dot_0/lib/grape//home/hermes/.rvm/gems/jruby-9.1.5.0/gems/grape-1.0.0/lib/grape/router.rb:93:in `transaction'
home/hermes/$_dot_rvm/gems/jruby_minus_9_dot_1_dot_5_dot_0/gems/grape_minus_1_dot_0_dot_0/lib/grape//home/hermes/.rvm/gems/jruby-9.1.5.0/gems/grape-1.0.0/lib/grape/router.rb:72:in `invokeOther7:transaction'
home/hermes/$_dot_rvm/gems/jruby_minus_9_dot_1_dot_5_dot_0/gems/grape_minus_1_dot_0_dot_0/lib/grape//home/hermes/.rvm/gems/jruby-9.1.5.0/gems/grape-1.0.0/lib/grape/router.rb:72:in `identity'
home/hermes/$_dot_rvm/gems/jruby_minus_9_dot_1_dot_5_dot_0/gems/grape_minus_1_dot_0_dot_0/lib/grape//home/hermes/.rvm/gems/jruby-9.1.5.0/gems/grape-1.0.0/lib/grape/router.rb:57:in `invokeOther4:identity'
home/hermes/$_dot_rvm/gems/jruby_minus_9_dot_1_dot_5_dot_0/gems/grape_minus_1_dot_0_dot_0/lib/grape//home/hermes/.rvm/gems/jruby-9.1.5.0/gems/grape-1.0.0/lib/grape/router.rb:57:in `block in call'
home/hermes/$_dot_rvm/gems/jruby_minus_9_dot_1_dot_5_dot_0/gems/grape_minus_1_dot_0_dot_0/lib/grape//home/hermes/.rvm/gems/jruby-9.1.5.0/gems/grape-1.0.0/lib/grape/router.rb:135:in `with_optimization'
home/hermes/$_dot_rvm/gems/jruby_minus_9_dot_1_dot_5_dot_0/gems/grape_minus_1_dot_0_dot_0/lib/grape//home/hermes/.rvm/gems/jruby-9.1.5.0/gems/grape-1.0.0/lib/grape/router.rb:56:in `invokeOther7:with_optimization'
home/hermes/$_dot_rvm/gems/jruby_minus_9_dot_1_dot_5_dot_0/gems/grape_minus_1_dot_0_dot_0/lib/grape//home/hermes/.rvm/gems/jruby-9.1.5.0/gems/grape-1.0.0/lib/grape/router.rb:56:in `call'
home/hermes/$_dot_rvm/gems/jruby_minus_9_dot_1_dot_5_dot_0/gems/grape_minus_1_dot_0_dot_0/lib/grape//home/hermes/.rvm/gems/jruby-9.1.5.0/gems/grape-1.0.0/lib/grape/api.rb:119:in `invokeOther7:call'
home/hermes/$_dot_rvm/gems/jruby_minus_9_dot_1_dot_5_dot_0/gems/grape_minus_1_dot_0_dot_0/lib/grape//home/hermes/.rvm/gems/jruby-9.1.5.0/gems/grape-1.0.0/lib/grape/api.rb:119:in `call'
home/hermes/$_dot_rvm/gems/jruby_minus_9_dot_1_dot_5_dot_0/gems/grape_minus_1_dot_0_dot_0/lib/grape//home/hermes/.rvm/gems/jruby-9.1.5.0/gems/grape-1.0.0/lib/grape/api.rb:45:in `invokeOther3:call'
home/hermes/$_dot_rvm/gems/jruby_minus_9_dot_1_dot_5_dot_0/gems/grape_minus_1_dot_0_dot_0/lib/grape//home/hermes/.rvm/gems/jruby-9.1.5.0/gems/grape-1.0.0/lib/grape/api.rb:45:in `call!'
home/hermes/$_dot_rvm/gems/jruby_minus_9_dot_1_dot_5_dot_0/gems/grape_minus_1_dot_0_dot_0/lib/grape//home/hermes/.rvm/gems/jruby-9.1.5.0/gems/grape-1.0.0/lib/grape/api.rb:40:in `invokeOther9:call!'
home/hermes/$_dot_rvm/gems/jruby_minus_9_dot_1_dot_5_dot_0/gems/grape_minus_1_dot_0_dot_0/lib/grape//home/hermes/.rvm/gems/jruby-9.1.5.0/gems/grape-1.0.0/lib/grape/api.rb:40:in `call'
home/hermes/$_dot_rvm/gems/jruby_minus_9_dot_1_dot_5_dot_0/gems/rack_minus_2_dot_0_dot_3/lib/rack//home/hermes/.rvm/gems/jruby-9.1.5.0/gems/rack-2.0.3/lib/rack/common_logger.rb:33:in `invokeOther10:call'
home/hermes/$_dot_rvm/gems/jruby_minus_9_dot_1_dot_5_dot_0/gems/rack_minus_2_dot_0_dot_3/lib/rack//home/hermes/.rvm/gems/jruby-9.1.5.0/gems/rack-2.0.3/lib/rack/common_logger.rb:33:in `call'
home/hermes/$_dot_rvm/gems/jruby_minus_9_dot_1_dot_5_dot_0/gems/rack_minus_cors_minus_1_dot_0_dot_1/lib/rack//home/hermes/.rvm/gems/jruby-9.1.5.0/gems/rack-cors-1.0.1/lib/rack/cors.rb:93:in `invokeOther110:call'
home/hermes/$_dot_rvm/gems/jruby_minus_9_dot_1_dot_5_dot_0/gems/rack_minus_cors_minus_1_dot_0_dot_1/lib/rack//home/hermes/.rvm/gems/jruby-9.1.5.0/gems/rack-cors-1.0.1/lib/rack/cors.rb:93:in `call'
home/hermes/$_dot_rvm/gems/jruby_minus_9_dot_1_dot_5_dot_0/gems/rack_minus_2_dot_0_dot_3/lib/rack//home/hermes/.rvm/gems/jruby-9.1.5.0/gems/rack-2.0.3/lib/rack/config.rb:17:in `invokeOther7:call'
home/hermes/$_dot_rvm/gems/jruby_minus_9_dot_1_dot_5_dot_0/gems/rack_minus_2_dot_0_dot_3/lib/rack//home/hermes/.rvm/gems/jruby-9.1.5.0/gems/rack-2.0.3/lib/rack/config.rb:17:in `call'
home/hermes/$_dot_rvm/gems/jruby_minus_9_dot_1_dot_5_dot_0/gems/puma_minus_3_dot_9_dot_1_minus_java/lib/puma//home/hermes/.rvm/gems/jruby-9.1.5.0/gems/puma-3.9.1-java/lib/puma/configuration.rb:224:in `invokeOther7:call'
home/hermes/$_dot_rvm/gems/jruby_minus_9_dot_1_dot_5_dot_0/gems/puma_minus_3_dot_9_dot_1_minus_java/lib/puma//home/hermes/.rvm/gems/jruby-9.1.5.0/gems/puma-3.9.1-java/lib/puma/configuration.rb:224:in `call'
home/hermes/$_dot_rvm/gems/jruby_minus_9_dot_1_dot_5_dot_0/gems/puma_minus_3_dot_9_dot_1_minus_java/lib/puma//home/hermes/.rvm/gems/jruby-9.1.5.0/gems/puma-3.9.1-java/lib/puma/server.rb:602:in `invokeOther246:call'
home/hermes/$_dot_rvm/gems/jruby_minus_9_dot_1_dot_5_dot_0/gems/puma_minus_3_dot_9_dot_1_minus_java/lib/puma//home/hermes/.rvm/gems/jruby-9.1.5.0/gems/puma-3.9.1-java/lib/puma/server.rb:602:in `handle_request'
home/hermes/$_dot_rvm/gems/jruby_minus_9_dot_1_dot_5_dot_0/gems/puma_minus_3_dot_9_dot_1_minus_java/lib/puma//home/hermes/.rvm/gems/jruby-9.1.5.0/gems/puma-3.9.1-java/lib/puma/server.rb:435:in `invokeOther79:handle_request'
home/hermes/$_dot_rvm/gems/jruby_minus_9_dot_1_dot_5_dot_0/gems/puma_minus_3_dot_9_dot_1_minus_java/lib/puma//home/hermes/.rvm/gems/jruby-9.1.5.0/gems/puma-3.9.1-java/lib/puma/server.rb:435:in `process_client'
home/hermes/$_dot_rvm/gems/jruby_minus_9_dot_1_dot_5_dot_0/gems/puma_minus_3_dot_9_dot_1_minus_java/lib/puma//home/hermes/.rvm/gems/jruby-9.1.5.0/gems/puma-3.9.1-java/lib/puma/server.rb:299:in `invokeOther17:process_client'
home/hermes/$_dot_rvm/gems/jruby_minus_9_dot_1_dot_5_dot_0/gems/puma_minus_3_dot_9_dot_1_minus_java/lib/puma//home/hermes/.rvm/gems/jruby-9.1.5.0/gems/puma-3.9.1-java/lib/puma/server.rb:299:in `block in run'
org/jruby/RubyProc.java:324:in `call'
org/jruby/RubyProc.java:308:in `call19'
org/jruby/RubyProc$INVOKER$i$0$0$call19.gen:-1:in `call'
home/hermes/$_dot_rvm/gems/jruby_minus_9_dot_1_dot_5_dot_0/gems/puma_minus_3_dot_9_dot_1_minus_java/lib/puma//home/hermes/.rvm/gems/jruby-9.1.5.0/gems/puma-3.9.1-java/lib/puma/thread_pool.rb:120:in `invokeOther103:call'
home/hermes/$_dot_rvm/gems/jruby_minus_9_dot_1_dot_5_dot_0/gems/puma_minus_3_dot_9_dot_1_minus_java/lib/puma//home/hermes/.rvm/gems/jruby-9.1.5.0/gems/puma-3.9.1-java/lib/puma/thread_pool.rb:120:in `block in spawn_thread'
org/jruby/RubyProc.java:324:in `call'
org/jruby/RubyProc.java:249:in `call'
java/lang/Thread.java:748:in `run'
Drilldowns:ADD DRILLDOWN 
Cuts:ADD CUT 
Measures:
IncomeExpansion FactorWeighted Income
Data
Chart
No Data
jazzido commented 7 years ago

If you want data at the month level, you should only drilldown by Month. I updated the way months are displayed to make that clear. Sorry about the confusion.

jazzido commented 7 years ago

http://chilecube.datawheel.us/ui/#eyJkcmlsbERvd25zIjpbWyJEYXRlIiwiRGF0ZSIsIk1vbnRoIl1dLCJjdXRzIjpbXSwiY3ViZSI6Im5lbmUiLCJtZWFzdXJlcyI6WyJOdW1iZXIgb2YgcmVjb3JkcyJdfQ==

image