Forum Discussion
Keep Duplicate X-axis Categories on a Graph
Hi Kitty-SD
If you already include legend, then you can only append their IDs to the end of the customer's name if you want to display different customers with the same name on the x-axis, because if there is no specific column (e.g. customer ID), it will be automatically aggregated when you put the same name on the x-axis.
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous thanks for your suggestion. My issue is that a) I already have a legend on the graph that I'd quite like to include (sorry, I should have mentioned this!) and b) adding the Guest ID as the legend seems to make guests with 0 bookings appear at random places in the graph:
This is even after I've sorted the X-axis by booking volume in descending order. This resolves itself once I remove the Guest ID legend.
This is what my original graph looks like; you can see where there are two different guests (belonging to two different loyalty clubs) grouped together:
Thanks,
Kitty
Hi Kitty-SD
If you already include legend, then you can only append their IDs to the end of the customer's name if you want to display different customers with the same name on the x-axis, because if there is no specific column (e.g. customer ID), it will be automatically aggregated when you put the same name on the x-axis.
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.