I have a line graph chart comparing showing % change of a certain metric for each of the many sectors.
Bucket : split series
Order by "Custom Metric"
Aggregation: Max (field: changepercent)
order: ascending 15
X - axis date is date timestamp
, y axis is cumultivee sum percent
However, what I notice is, that it does not show the tru top 15 sectors based on % change. It shows some random 15. In other words, let's say I asked for top 3
and my SQL (from the db) shows output as
It shows top 3 as sectorA, sector C and sector E or some random ones like that.
It is never the tru top 10 or 15 based on % change. It's always some random 15.
I tried doing min chaangepercent, and also, descending instead of ascending,,, no matter what I do, it always skips some .