These are chat archives for getredash/redash

1st
Aug 2016
Clio Harper
@clioharp
Aug 01 2016 15:27
Hey @arikfr, I just moved over to here
Arik Fraimovich
@arikfr
Aug 01 2016 15:27
Hi @clioharp .
Clio Harper
@clioharp
Aug 01 2016 15:27
So I think I'm using 0.11
I just pulled in like an hour ago
Arik Fraimovich
@arikfr
Aug 01 2016 16:05
@clioharp then you have support for aggregates
Clio Harper
@clioharp
Aug 01 2016 16:09
That's what I figured. The reason I switched over to re:dash is because I couldn't do what I wanted in Kibana, so I'll give it a try, but I'm thinking what I want is not going to be possible in Kibana either. Basically, I'm looking at logs and want to perform aggregations based on the application they came from, then the user count and total request count so I can divide the two to get a ratio of totalRequest/totalUsers per company. Any idea if that would be possible?
The Elasticsearch query looks like this: { "size":0, "aggregations": { "apps": { "terms": { "field": "application_name" }, "aggregations" : { "user_count" : { "cardinality" : { "field" : "user_id" } }, "total_request" : { "value_count" : { "field" : "created_at" } } , "avg_request_per_app" : { "bucket_script": { "buckets_path": { "totalUsers": "user_count", "totalRequest": "total_request" }, "script": "totalRequest / totalUsers" } } } } } }
Arik Fraimovich
@arikfr
Aug 01 2016 18:51
@clioharp I'm not familiar enough with ElasticSearch/Kibana to answer. :-\