Forum Discussion
X axis sort with data
Hello Team,
I have column chart where start time, end time , Shift is X axis. But while showing in visualization , Shift is not showing in order. I tried to sort but couldn't. Can you help us?
"I need sort General shift followed by Third"
3 Replies
Hi Karthik12
You have to add a sorting column for Time key to your data table .
For more details please refer :https://www.youtube.com/watch?v=1saRnlIHZVw
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Add a Custom Sort Column:
- In your data table, create a new column named something like "Shift Order."
- Assign the value 1 to "General" shifts and 2 to "Third" shifts.
08:00 16:00 General shift 1 16:00 00:00 Third shift 2 Sort Your Data:
- Go to your column chart settings.
- Find the sorting options.
- Sort by "Shift Order" instead of the "Shift" label.
This should arrange your shifts in the desired order, with "General shift" appearing first, followed by "Third shift."
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Regards,
Suresh Patra
https://www.linkedin.com/in/sureshpatra
