DSS Chart Field Sorting
gblack686
Partner, Registered Posts: 62 Partner
Is it possible to sort based on a manual order?
I see natural ordering, but no explanation of what that is.
For our example, we have a stacked area graph, and we want to set a specific order of the stacks.
Answers
-
tgb417 Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS ML Practitioner, Dataiku DSS Core Concepts, Neuron 2020, Neuron, Registered, Dataiku Frontrunner Awards 2021 Finalist, Neuron 2021, Neuron 2022, Frontrunner 2022 Finalist, Frontrunner 2022 Winner, Dataiku Frontrunner Awards 2021 Participant, Frontrunner 2022 Participant, Neuron 2023 Posts: 1,601 NeuronI'm not aware of one. Maybe others might know.
Have you considered a column with a sort order number in it? However, I'm not clear that this will even resolve your issue. Because you might not want to display the sort value. I'm not clear that DSS's Graphics can sort by an undisplayed value.
Options:
- You could export to something like Tableau, or even MS Excel
- You could display with the ggplot2 library from the R Language
Note: Seting Up R can be a bit of a big lift getting it to work with DSS, then learning how to use it in either a notebook or as a Shiny App, which would allow for interactive graphics.