Why are values are missing and incorrect when I used stats values() in chart?

[Vish]

I had a tabular chart which has component, basket and age column. But the problem was I had same component with different basket values and different ageing as different rows as shown below, which was duplicating my rows with same component name

So, My query was to use to combine the same component as a single row with multiple basket values and display the ageing of each component with respect to the basket,so i used the below code

But the output was this

but, it turns out that my values for the combined rows (as a single row) is missing, few are reversed and incorrect can anyone help out please?

by values of that rows what supposed to be this

[ITWhisperer · Accepted solution]

When you used stats values() you are getting correct results for the function you are using - your issue is that you are using the wrong function for what you are trying to do. This is because values() puts the unique values in lexicographical order i.e. duplicates are removed as well as the values being sorted. To get the list the way you want, you should use list() instead of values().

[yuanliu]

It is not fair to ask volunteers to speculate

1. what data you mean to process.  It's OK to anonymize.  But you must give enough detail to illustrate its characteristics.
2. what command you use to get the "wrong" result.
3. what is really "wrong" with that result.  A smudged dot is not an illustration.
4. what is really expected result.  Again, smudges do not form an illustration.

Oh.  Don't forget, it's best to illustrate data and commands in text, not in screenshots, much less everything smudged screenshot.