I am facing an issue with "order by". I have an Y axis with an "average" aggregation. I have an X axis with a "Term" aggregation (where my terms are street names) => I have an average value for each street.
I would like my X axis to be sorted by the average aggregation. I thought it was working when I selected "order by metric: [my aggregation]", but when I set a filter to display only one street, the average value of this street changes. This does not happen when I use "order by: alphabetical": (in this case the values stay the same).
Here is an example.
Using order by: alphabetical
Then filtering on a random street... the value is still 4.399
Now ordering by metric: average
Then filtering on a random street => the value changes from 2.337 to 4.135
There is probably something that I am misunderstanding on how the order by works with aggregation... Any help would be very appreciated