search

smartinsightsfromdata / rpivotTable

A R wrapper for the great library pivottable
Other
285 stars 71 forks source link

Order in "List unique values" #85

Closed rdornas closed 6 years ago

rdornas commented 6 years ago

Hi! First of all, congratulations for this excellent tool. It is really handy!

I am just in some trouble when selecting "List unique values" as I can't understand how it sorts neither I could do something to change its sorting. I tried, without success, changing the target field from numbers or letters. Maybe you can better understand with the following figures.

captura de tela 2018-01-03 23 32 20 captura de tela 2018-01-03 23 32 00

In both figures, you can see that the order is probably the order of the data, as in "Campanha 3". The area number 5 or EA05 appears below all other values. This happens with other "Campanha" too.

What am I doing wrong? Do you have some advice to give me in this respect?

Thank you very much indeed!

Rubem.

nicolaskruchten commented 6 years ago

This is something which will need to be fixed in the underlying Javascript library. I've created a corresponding issue in that repository: https://github.com/nicolaskruchten/pivottable/issues/854

nicolaskruchten commented 6 years ago

This should be fixed in version 0.3.0 of this library! https://github.com/smartinsightsfromdata/rpivotTable/releases/tag/v0.3.0