Sub aggregation graph ordering off first bucket, not overall data set

Elastic Stack Kibana
1

I've attempted to search for anything similar on Google/here before posting this, but apologies if I've missed anything.

Using a time series graph (replicated on vertical bar and line) we're plotting Unique Count of usernames over time with the X Axis sub-bucketed by Term (country). While the data returned is correct, the way in which data is ordered (within the sub-aggs and the legend) is not what I expected.

Current result:

  • The order of sub-buckets only seems to be based off the values returned in the first bucket. As the first bucket in our data set is an outlier (Brazil is 3rd, Mexico is 4th) it carries this through the rest of the graph, where both are clearly well down the list if you considered the entire data set

Expected result:

  • All buckets in the time series should be considered when calculating the order of buckets

image
image.png3549×1867 383 KB

Cheers, CCM

2

Sounds like you're running into https://github.com/elastic/kibana/issues/17532. You might want to update that with any additional details you can provide and subscribe for updates there.

3

Thanks @spalger - appreciate you pointing out the github issue. I'll update with info relevant to our case.

CCM

4

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.